User:Electricsheep/sandbox: Difference between revisions
→Cargo query test
No edit summary |
|||
Line 11:
}}
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) AND Server="JP"
| order by = Category ASC, Start_date ASC
| format = ul
| template = FrontpageBanner
| named args = yes
}}
</ul>
=Cargo query test table output=
| |||