Difference between revisions of "Dragalia Lost Wiki/Latest Events"
Jump to navigation
Jump to search
>Boblers (changing date sorting, such that ongoing puts newer events at the top, and upcoming puts sooner-coming events at the top) |
>Boblers (changing ongoing events to sort by EndDate, with ending-soon events at the top) |
||
| Line 7: | Line 7: | ||
|q?tables=Events | |q?tables=Events | ||
|q?fields=Name,StartDate,EndDate | |q?fields=Name,StartDate,EndDate | ||
| − | |q?orderBy= | + | |q?orderBy=EndDate ASC, Name ASC |
|q?groupBy=_pageName | |q?groupBy=_pageName | ||
|q?where=NOW() between StartDate and EndDate | |q?where=NOW() between StartDate and EndDate | ||
| Line 17: | Line 17: | ||
|q?tables=SecondaryEvents | |q?tables=SecondaryEvents | ||
|q?fields=Name,ImageFile,PageLink,OfficialLink,StartDate,EndDate,_rowID | |q?fields=Name,ImageFile,PageLink,OfficialLink,StartDate,EndDate,_rowID | ||
| − | |q?orderBy= | + | |q?orderBy=EndDate ASC, Name ASC |
|q?groupBy= | |q?groupBy= | ||
|q?where=NOW() between StartDate and EndDate AND _pageName='Dragalia Lost Wiki/Secondary Events' | |q?where=NOW() between StartDate and EndDate AND _pageName='Dragalia Lost Wiki/Secondary Events' | ||
Revision as of 07:14, 25 March 2020