User:Electricsheep/sandbox: Difference between revisions

Line 13:
| default = None!
}}
{{#cargo_compound_query:
{{#cargo_query:
|tables=raids;where=Server='JP';fields=Name,Start_date,End_date,CONCAT('#4b884b')=color,Notes=description;text color=white;name=Name;start=Start_date;end=End_date
tables = raids
|format=calendar}}
| fields = Name, Start_date=Start_date, End_date=End_date
{{#cargo_compound_query:
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP"
|tables=raids;where=Server='JP';fields=Name,Start_date,End_date,CONCAT('#4b884b')=color,Notes=description;text color=white;name=Name;start=Start_date;end=End_date
| order by = Start_date ASC
|format=timeline}}
| offset = 1
 
| more results text =
| format = template
| template = FrontpageRaid
| named args = yes
| default =
}}
=Raid cargo=