User:Electricsheep/sandbox: Difference between revisions
→Cargo query test
Line 7:
{{#cargo_query:
tables = events
| fields = Image, NameEN,
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Event" AND Server="JP"
| order by = Start_date ASC
Line 19:
{{#cargo_query:
tables = events
| fields = Image, NameEN,
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Rewards" AND Server="JP"
| order by = Start_date ASC
Line 31:
{{#cargo_query:
tables = events
| fields = Image, NameEN,
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Login" AND Server="JP"
| order by = Start_date ASC
| |||