Main Page: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
No edit summary |
mNo edit summary |
||
Line 18: | Line 18: | ||
{{#cargo_query: |
{{#cargo_query: |
||
tables = banners |
tables = banners |
||
| fields = Image, Rateup_character=Rateup_character, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
| fields = Image, Rateup_character=Rateup_character, Limited, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
||
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) AND Server="JP" |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) AND Server="JP" |
||
| order by = Start_date DESC, Id ASC |
| order by = Start_date DESC, Id ASC |