User:Electricsheep/sandbox: Difference between revisions

Line 4:
tables=banners
| fields = Image, Rateup_character, 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)
| order by = Start_date DESC
| format = template