User:Electricsheep/sandbox: Difference between revisions
→Cargo query test table output
Line 1:
__TOC__
=Cargo query test table output=
{{#cargo_query:
tables =
| fields =
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="
| order by = Start_date
| limit = 1
| more results text =
| format = template
| template =
| named args = yes
| default = None!
}}
{{#cargo_query:
tables = raids
| fields = Name, Start_date=Start_date, End_date=End_date
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP"
| order by = Start_date ASC
| offset = 1
| more results text =
| format = template
| template = FrontpageRaid
| named args = yes
| default =
}}
|