8,756
edits
Template:Trade Good Navbox: Difference between revisions
Jump to navigation
Jump to search
m
query optimize
(Created page with "{{Navbox | name = Trade Good Navbox | title = List of Trade Goods | listclass = hlist | state = {{{state|collapsed}}} | titlestyle =...") |
m (query optimize) |
||
| Line 13: | Line 13: | ||
|q?tables=GeneralData=GD,ExtraInfo=EI | |q?tables=GeneralData=GD,ExtraInfo=EI | ||
|q?join=GD.JoinKey=EI.JoinKey | |q?join=GD.JoinKey=EI.JoinKey | ||
|q?fields= | |q?fields={{Favilink format args}} | ||
|q?where=|where=GD.categories='Trade Goods' AND EI.Info LIKE '%Currency,,,%' | |q?where=|where=GD.categories='Trade Goods' 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 | ||
|template=favilink | |template=favilink format | ||
|delimiter= - </span><span style="display:inline-block">}}</span> | |delimiter= - </span><span style="display:inline-block">}}</span> | ||
| Line 25: | Line 25: | ||
|q?tables=GeneralData=GD,ExtraInfo=EI | |q?tables=GeneralData=GD,ExtraInfo=EI | ||
|q?join=GD.JoinKey=EI.JoinKey | |q?join=GD.JoinKey=EI.JoinKey | ||
|q?fields= | |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' 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 | |template=favilink format | ||
|delimiter= - </span><span style="display:inline-block">}}</span> | |delimiter= - </span><span style="display:inline-block">}}</span> | ||
}} | }} | ||
<noinclude>[[Category:Navigation]]</noinclude> | <noinclude>[[Category:Navigation]]</noinclude> | ||