8,756
edits
(added two queries and making your pack value per weigh efficient) |
(→Getting the Most Value Out Of Weight: changed so plain name is returned) |
||
Line 39: | Line 39: | ||
Below is a table that lists all items with their [[commerce]] value divided by their own weight, and sorted from most expensive to least. | Below is a table that lists all items with their [[commerce]] value divided by their own weight, and sorted from most expensive to least. | ||
{{#cargo_query:table=GeneralData|fields=_pageName=Item,POWER(Commerce,1)/Weight=Value per Pound,|where=_pageNamespace ='0' AND Commerce <> "" AND Weight <> "0"|order by=Value per Pound DESC|limit=25}} | {{#cargo_query:table=GeneralData|fields=CONCAT('[[',_pageName,'|',PlainName,']]')=Item,POWER(Commerce,1)/Weight=Value per Pound,|where=_pageNamespace ='0' AND Commerce <> "" AND Weight <> "0"|order by=Value per Pound DESC|limit=25}} | ||
===0 Weight Items=== | ===0 Weight Items=== | ||
Items that weigh nothing are also highly valuable since they do not take up weight. Note that the majority are [[food]] and [[cybernetics]]. | Items that weigh nothing are also highly valuable since they do not take up weight. Note that the majority are [[food]] and [[cybernetics]]. | ||
{{#cargo_query:table=GeneralData|fields=_pageName=Item,Commerce=Value|where=_pageNamespace ='0' AND Weight = "0"|order by=Value DESC|limit=20}} | {{#cargo_query:table=GeneralData|fields=CONCAT('[[',_pageName,'|',PlainName,']]')=Item,Commerce=Value|where=_pageNamespace ='0' AND Weight = "0"|order by=Value DESC|limit=20}} | ||
[[Category:Guides]] | [[Category:Guides]] |