8,756
edits
mNo edit summary |
(ported some tables over) |
||
Line 52: | Line 52: | ||
==Items by Commerce Value== | ==Items by Commerce Value== | ||
{{#cargo_query:tables=GeneralData=GD | {{#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}} | ||
== 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}} | |||
== 0 Weight Items sorted by Commerce == | |||
{{#cargo_query:table=GeneralData|fields=CONCAT('{{((}}favilink id{{!}}', ObjectID, '{{))}}')=Item,CONCAT('{{((}}drams{{))}}', Commerce)=Value|where=_pageNamespace ='0' AND Weight = "0"|order by=Value DESC|format=dynamic table|rows per page=20}} | |||
[[Category:Mechanics]] | [[Category:Mechanics]] |