Commerce: Difference between revisions

Commerce (view source)

666 bytes added , 03:31, 29 December 2020

ported some tables over

8,756

edits

@@ Line 52: / Line 52: @@
 ==Items by Commerce Value==
-{{#cargo_query:tables=GeneralData=GD,ItemsTable=I|join on=I._pageName = GD._pageName|fields=I._pageName=Page, GD.Commerce=Commerce, GD.Categories=Category|order by=Commerce DESC|where=I._pageNamespace = "0"|format=dynamic table|rows per page=30}}
+{{#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]]