8,756
edits
Creatures by experience value: Difference between revisions
Creatures by experience value (view source)
Revision as of 15:53, 15 April 2021
, 15:53, 15 April 2021no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Characters | tables=Characters=C,GeneralData=GD | ||
|fields=CONCAT('{{ | | join on = C.ObjectID=GD.ObjectID | ||
|where=XPValue IS NOT NULL and XPVALUE > 0 AND (_pageNamespace = "0" OR _pageNamespace= "10002") | |fields=CONCAT('{{Favilink page{{!}}', GD._pageName, '}}')=Creature, XPValue=XP_Value,XPTier=XP_(Level)_Tier | ||
|where=XPValue IS NOT NULL and XPVALUE > 0 AND (GD._pageNamespace = "0" OR GD._pageNamespace= "10002") | |||
|order by=XPValue DESC | |order by=XPValue DESC | ||
| group by = GD.ObjectID | |||
|limit=999 | |limit=999 | ||
}} | }} | ||