User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
Line 3: | Line 3: | ||
{{#cargo_query: |
{{#cargo_query: |
||
tables=banners |
tables=banners |
||
| fields = Image, Rateup_character, Start_date, End_date |
| fields = Image, Rateup_character, Start_date, End_date, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
||
| where = End_date > DATE_SUB(NOW(), INTERVAL 12 HOUR) AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) |
| where = End_date > DATE_SUB(NOW(), INTERVAL 12 HOUR) AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) |
||
| order by = Start_date DESC |
| order by = Start_date DESC |