5e:Artificer/Infused Items List

From Rlyehwiki
Revision as of 16:05, 7 April 2020 by Rlyehable (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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

magic items

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`,CONCAT( '', `rly2_cargo__5e_Magic_Items`.`Item_Name`, '' ) AS `Infused Item`,`rly2_cargo__5e_Magic_Items`.`Sort_Text` AS `Sort Text`,`rly2_cargo__5e_Magic_Items`.`Item_Type` AS `Item Type`,`rly2_cargo__5e_Magic_Items`.`Rarity` AS `Rarity`,`rly2_cargo__5e_Magic_Items`.`Prerequisites` AS `Prerequisites`,`rly2_cargo__5e_Magic_Items`.`Artificer_Item` AS `Item Infused`,`rly2_cargo__5e_Magic_Items`.`Attunement` AS `Attunement`,`rly2_cargo__5e_Magic_Items`.`Charges` AS `Charges`,`rly2_cargo__5e_Magic_Items`.`Artificer_Canon` AS `Canon`,`rly2_cargo__Pages_Info`.`Pointer` AS `Pointer`,`rly2_cargo__Pages_Info`.`UA` AS `UA`,`rly2_cargo__Pages_Info`.`User` AS `User`,`Sources__full` AS `Sources` 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__5e_Magic_Items`.`Sort_Text` LIMIT 100