8,756
edits
(add navbox) |
|||
Line 52: | Line 52: | ||
==Items by Commerce Value== | ==Items by Commerce Value== | ||
{{#cargo_query:tables=GeneralData=GD|fields=CONCAT('{{((}}favilink id{{!}}', GD.ObjectID, '{{))}}')=Item, CONCAT('{{((}}drams{{))}}',GD.Commerce)=Value, CONCAT(GD.Weight,'{{((}}pounds{{))}}')=Weight, GD.Categories=Category|order by=Commerce DESC|where=GD._pageNamespace = "0"|format=dynamic table|rows per page=20}} | {{#cargo_query:tables=GeneralData=GD|fields=CONCAT('{{((}}favilink id{{!}}', GD.ObjectID, '{{))}}')=Item, CONCAT('{{((}}drams{{))}}',GD.Commerce)=Value, CONCAT(GD.Weight,'{{((}}pounds{{))}}')=Weight, GD.Categories=Category|order by=Commerce DESC|where=GD._pageNamespace = "0"|format=dynamic table|rows per page=20|footer=Note for liquids, their base commerce is multiplied by 4 to have an integer weight.}} | ||
== Items sorted by Commerce/Weight == | == Items sorted by Commerce/Weight == | ||
{{#cargo_query:table=GeneralData|fields=CONCAT('{{((}}favilink id{{!}}', ObjectID, '{{))}}')=Item,POWER(Commerce,1)/Weight=Value per Pound,|where=_pageNamespace ='0' AND Commerce <> "" AND Weight <> "0"|order by=Value per Pound DESC|format=dynamic table|rows per page=20}} | {{#cargo_query:table=GeneralData|fields=CONCAT('{{((}}favilink id{{!}}', ObjectID, '{{))}}')=Item,POWER(Commerce,1)/Weight=Value per Pound,|where=_pageNamespace ='0' AND Commerce <> "" AND Weight <> "0"|order by=Value per Pound DESC|format=dynamic table|rows per page=20}} |