8,756
edits
(rewording, added query that returns trade goods by whether they are fixed/unfixed price, and how much they are worth) |
m (minor query reformat) |
||
Line 11: | Line 11: | ||
|fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | |fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | ||
|where=GD.categories='Trade Goods' AND EI.Info LIKE '%Currency,,,%' | |where=GD.categories='Trade Goods' AND EI.Info LIKE '%Currency,,,%' | ||
|format= | |format=list | ||
|delimiter=</br> | |||
|order by=GD.commerce}} | |order by=GD.commerce}} | ||
| style="text-align: left;vertical-align:top; | {{#cargo_query:tables=GeneralData=GD,ExtraInfo=EI | | style="text-align: left;vertical-align:top; | {{#cargo_query:tables=GeneralData=GD,ExtraInfo=EI | ||
Line 17: | Line 18: | ||
|fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | |fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | ||
|where=GD.categories='Trade Goods' AND (EI.Info NOT LIKE '%Currency,,,%' OR EI.Info IS NULL) | |where=GD.categories='Trade Goods' AND (EI.Info NOT LIKE '%Currency,,,%' OR EI.Info IS NULL) | ||
|format= | |format=list | ||
|delimiter=</br> | |||
|order by=GD.Commerce}} | |order by=GD.Commerce}} | ||