Difference between revisions of "testpage"
From pathCast
(20 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 | |
− | |order by= | + | |more results text= |
− | |limit= | + | |}} |
− | | |
Latest revision as of 11:36, 31 December 2020
No results