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