8,290
edits
m (formatting fix) |
mNo edit summary |
||
Line 87: | Line 87: | ||
{{#cargo_query:tables=GeneralData,ItemsTable | {{#cargo_query:tables=GeneralData,ItemsTable | ||
| join on=GeneralData.ObjectID=ItemsTable.ObjectID | | join on=GeneralData.ObjectID=ItemsTable.ObjectID | ||
| fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=PV,CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(ItemsTable.Damage),'{{))}}')=Damage | | fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=Max PV,CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(ItemsTable.Damage),'{{))}}')=Damage | ||
| where=GeneralData.Categories='Thrown Weapons' | | where=GeneralData.Categories='Thrown Weapons' | ||
| order by=ItemsTable.MaxPV DESC,ItemsTable.Damage DESC | | order by=ItemsTable.MaxPV DESC,ItemsTable.Damage DESC | ||
Line 99: | Line 99: | ||
{{#cargo_query:tables=GeneralData,ItemsTable | {{#cargo_query:tables=GeneralData,ItemsTable | ||
| join on=GeneralData.ObjectID=ItemsTable.ObjectID | | join on=GeneralData.ObjectID=ItemsTable.ObjectID | ||
| fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=PV,CONCAT('{{((}}Heart{{))}}',CONCAT(ItemsTable.Damage))=Damage | | fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=Max PV,CONCAT('{{((}}Heart{{))}}',CONCAT(ItemsTable.Damage))=Damage | ||
| where=GeneralData.Categories='Tonics' | | where=GeneralData.Categories='Tonics' | ||
| order by=Item | | order by=Item |