Template:Sandbox/Aurelain/Unit Infobox

From Heroes of Might and Magic: Olden Era Official Wiki
Revision as of 15:06, 13 July 2026 by Aurelain (talk | contribs)


Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`id`=`U`.`id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'hive_queen' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=hive_queen}}

Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`id`=`U`.`base_sid`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'hive_queen_upg' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=hive_queen_upg}}

Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`upgrade_sid`=`U`.`base_sid`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'hive_queen_upg_alt' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=hive_queen_upg_alt}}

Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`id`=`U`.`id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'dragon' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=dragon}}

Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`id`=`U`.`base_sid`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'dragon_upg' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=dragon_upg}}

Error 1054: Unknown column 'U1.faction or 1' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`U`.`hp` AS `hp`,`B`.`hp` AS `hp0`,`B`.`id` AS `id0`,`U1`.`id` AS `id1`,`U`.`id` AS `id` FROM `mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`B`.`id`=`U`.`id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `F` ON ((`U`.`faction`=`F`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U1` ON ((`U`.`faction`=`U1`.`faction or 1`) AND (`U`.`tier`=`U1`.`tier or 1`) AND (`B`.`id`=`U1`.`base_sid or 1`)) WHERE `U`.`id` = 'pixie' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U1`.`_pageID`,`B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100

{{Sandbox/Aurelain/Unit Infobox | id=pixie}}

Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:Sandbox/Aurelain/Unit_Infobox&oldid=28253"