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