Difference between revisions of "Water's Blessing"
Jump to navigation
Jump to search
>Mornsta-gpuser |
>Mornsta-gpuser |
||
| Line 20: | Line 20: | ||
|q?tables=Adventurers | |q?tables=Adventurers | ||
|q?fields=CONCAT('Adventurer')=Type,FullName=Name | |q?fields=CONCAT('Adventurer')=Type,FullName=Name | ||
| − | |q?where=IsPlayable!=0 AND ElementalType="Water" AND | + | |q?where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00" |
|q?groupBy=_pageName | |q?groupBy=_pageName | ||
|q?orderBy= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC | |q?orderBy= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC | ||
| Line 30: | Line 30: | ||
|tables=Adventurers | |tables=Adventurers | ||
|fields=FullName=Name | |fields=FullName=Name | ||
| − | |where=IsPlayable!=0 AND ElementalType="Water" AND | + | |where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00" |
|group by=_pageName | |group by=_pageName | ||
|order by= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC | |order by= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC | ||
| Line 40: | Line 40: | ||
|q?tables=Dragons | |q?tables=Dragons | ||
|q?fields=CONCAT('Dragon')=Type,FullName=Name | |q?fields=CONCAT('Dragon')=Type,FullName=Name | ||
| − | |q?where=IsPlayable!=0 AND ElementalType="Water" AND | + | |q?where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00" |
|q?groupBy=_pageName | |q?groupBy=_pageName | ||
|q?orderBy= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC | |q?orderBy= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC | ||
| Line 50: | Line 50: | ||
|tables=Dragons | |tables=Dragons | ||
|fields=FullName=Name | |fields=FullName=Name | ||
| − | |where=IsPlayable!=0 AND ElementalType="Water" AND | + | |where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00" |
|group by=_pageName | |group by=_pageName | ||
|order by= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC | |order by= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC | ||
Revision as of 10:49, 22 March 2019
Rate Up Units:
Lua error: Error: Table Adventurers not found..Lua error: Error: Table Dragons not found..Start Date: March 20, 2019 06:00:00 AM UTC
End Date: March 27, 2019 05:59:59 AM UTC