Trade goods: Difference between revisions
Jump to navigation
Jump to search
m (fix query to account for gemstone recategorization) |
m (update cargo query for new gemstone categorization) |
||
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' OR GD.categories='Figurines' OR GD.categories='Gemstones') 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' OR GD.categories='Gemstones') 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> |