Template:Trade Good Navbox: Difference between revisions
Jump to navigation
Jump to search
m (remove extra line break after navbox) |
(fix navbox to include all updated item categories) |
||
Line 14: | Line 14: | ||
|q?join=GD.JoinKey=EI.JoinKey | |q?join=GD.JoinKey=EI.JoinKey | ||
|q?fields={{Favilink format args}} | |q?fields={{Favilink format args}} | ||
|q?where=|where=GD.categories='Trade Goods' AND EI.Info LIKE '%Currency,,,%' | |q?where=|where=(GD.categories='Trade Goods' OR GD.categories='Figurines' OR GD.categories='Rough Gemstones' OR GD.categories='Smooth Gemstones') AND EI.Info LIKE '%Currency,,,%' | ||
|q?groupBy=GD._pageName | |q?groupBy=GD._pageName | ||
|q?orderBy=GD.Commerce,GD._pageName | |q?orderBy=GD.Commerce,GD._pageName | ||
Line 26: | Line 26: | ||
|q?join=GD.JoinKey=EI.JoinKey | |q?join=GD.JoinKey=EI.JoinKey | ||
|q?fields={{Favilink format args}} | |q?fields={{Favilink format args}} | ||
|q?where=|where=GD.categories='Trade Goods' AND (EI.Info NOT LIKE '%Currency,,,%' OR EI.Info IS NULL) | |q?where=|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) | ||
|q?groupBy=GD._pageName | |q?groupBy=GD._pageName | ||
|q?orderBy=GD.Commerce,GD._pageName | |q?orderBy=GD.Commerce,GD._pageName |