Template:Items that can be built with: Difference between revisions
Jump to navigation
Jump to search
(favilink items and better alignment) |
mNo edit summary |
||
Line 3: | Line 3: | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND _pageNamespace ='0' AND _pageName <> '' | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND _pageNamespace ='0' AND _pageName <> '' | ||
|no html}} }} | |no html}} }} | ||
{| | {| style="display:inline-table; vertical-align:top;" | ||
|style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
Line 11: | Line 11: | ||
|limit={{#var:ITEMCOUNT}} | |limit={{#var:ITEMCOUNT}} | ||
|more results text=}} | |more results text=}} | ||
|style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |} | ||
{| style="display:inline-table; vertical-align:top;" | |||
||{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits |
Revision as of 01:02, 16 August 2020
Error: the string "SELECT" cannot be used within #cargo_query.
|
Error: the string "SELECT" cannot be used within #cargo_query.
|