Template:Trade Good Navbox: Difference between revisions
Jump to navigation
Jump to search
m (query optimize) |
(fix navbox to include all updated item categories) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Navbox | <includeonly>{{Navbox | ||
| name = Trade Good Navbox | | name = Trade Good Navbox | ||
| title = List of [[:Category:Trade Goods|Trade Goods]] | | title = List of [[:Category:Trade Goods|Trade Goods]] | ||
| 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 | ||
|template=favilink format | |template=favilink format | ||
|delimiter= - </span><span style="display:inline-block">}}</span> | |delimiter= - </span><span style="display:inline-block">}}</span> | ||
}} | }}</includeonly><noinclude>[[Category:Navigation]]</noinclude> | ||
<noinclude>[[Category:Navigation]]</noinclude> | |||