5e:Artificer/Infused Items List: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<!--({{#ask: Category:5e Magic Items Artificer Infused Item::true|format=count}} official and unofficial {{5ep|Artificer}} Infused Magic Items) {{#ask: Category:5e M...") |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | |||
{{#ask: [[Category:5e Magic Items]] [[Artificer Infused Item::true]] | tables=5e_Magic_Items, Pages_Info | ||
|join on=5e_Magic_Items._pageName=Pages_Info._pageName | |||
|where=5e_Magic_Items.Artificer_Infused=1 AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |||
|fields=COUNT(5e_Magic_Items._pageName) | |||
}} {{srd5lc|Magic Item}}s | |||
{{#cargo_query: | |||
tables=5e_Magic_Items, Pages_Info | |||
|join on=5e_Magic_Items._pageName=Pages_Info._pageName | |||
|where=5e_Magic_Items.Artificer_Infused=1 AND (5e_Magic_Items.Hidden=0 OR 5e_Magic_Items.Hidden IS NULL) | |||
|fields=CONCAT( '[[', 5e_Magic_Items._pageName, '|', 5e_Magic_Items.Item_Name, ']]' )=Infused Item,5e_Magic_Items.Item_Type,5e_Magic_Items.Rarity,5e_Magic_Items.Prerequisites,5e_Magic_Items.Artificer_Item=Item Infused,5e_Magic_Items.Attunement,5e_Magic_Items.Charges,5e_Magic_Items.Artificer Canon=Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources | |||
|order by=5e_Magic_Items.Sort_Text | |||
|format=table | |||
|limit=1000 | |||
|more results text=More items | |||
}} | |||
<!--{{#ask: [[Category:5e Magic Items]] [[Artificer Infused Item::true]] | |||
|?=Name | |?=Name | ||
|?Item Type | |||
|?Rarity | |?Rarity | ||
|?Prerequisite | |?Prerequisite | ||
|?Item | |?Item | ||
Revision as of 14:58, 7 April 2020
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Magic_Items`.`_pageID` AS `cargo_backlink_page_id_5e_Magic_Items`,COUNT(`rly2_cargo__5e_Magic_Items`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Magic_Items` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Magic_Items`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE `rly2_cargo__5e_Magic_Items`.`Artificer_Infused`=1 AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Magic_Items`.`_pageID`,COUNT(`rly2_cargo__5e_Magic_Items`.`_pageName`) LIMIT 100
Error: No field named "5e_Magic_Items.Artificer Canon" found for any of the specified database tables.