8,290
edits
Trade goods: Difference between revisions
m
update cargo query for new gemstone categorization
m (clarification) |
m (update cargo query for new gemstone categorization) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
|join on=GD.JoinKey=EI.JoinKey | |join on=GD.JoinKey=EI.JoinKey | ||
|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' OR GD.categories='Figurines' OR GD.categories='Rough Gemstones' OR GD.categories='Smooth Gemstones') AND EI.Info LIKE '%Currency,,,%' | ||
|format=list | |format=list | ||
|delimiter=</br> | |delimiter=</br> | ||
| Line 16: | Line 16: | ||
|join on=GD.JoinKey=EI.JoinKey | |join on=GD.JoinKey=EI.JoinKey | ||
|fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | |fields=CONCAT('{{((}}favilink page{{!}}', GD._pageName, '{{))}}'), GD.Commerce | ||
|where=(GD.categories='Trade Goods' OR GD.categories='Figurines') AND (EI.Info NOT LIKE '%Currency,,,%' OR EI.Info IS NULL) | |where=(GD.categories='Trade Goods' OR GD.categories='Figurines' OR GD.categories='Rough Gemstones' OR GD.categories='Smooth Gemstones') AND (EI.Info NOT LIKE '%Currency,,,%' OR EI.Info IS NULL) | ||
|format=list | |format=list | ||
|delimiter=</br> | |delimiter=</br> | ||