Difference between revisions of "testpage"
From pathCast
(30 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | {{#cargo_query: | |
− | tables=pathCast | + | tables=pathCast,pathCastFiles |
+ | |join on=pathCast._pageName=pathCastFiles.pathCast | ||
|fields= | |fields= | ||
− | , | + | ,pathCast._pageName |
− | , | + | ,pathCast.title |
− | + | ,pathCastFiles._pageTitle | |
− | + | |where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner' | |
− | + | |order by=pathCast.date ASC | |
− | | | + | |limit=1 |
+ | |more results text= | ||
+ | |}} |
Latest revision as of 11:36, 31 December 2020
No results