Template:Sandbox/Aurelain/Unit Infobox

From Heroes of Might and Magic: Olden Era Official Wiki
Revision as of 05:51, 17 July 2026 by Aurelain (talk | contribs)

Renders the right-floating unit box.


1. Temple base unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("angel") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`)) WHERE `U`.`id` = 'angel'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = angel
}}

2. Necropolis upgraded unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("vampire") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`base_sid`=`U0`.`id`)) WHERE `U`.`id` = 'vampire_upg'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = vampire_upg
}}

3. Grove upgraded alternative unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("phoenix") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`base_sid`=`U0`.`upgrade_sid`)) WHERE `U`.`id` = 'phoenix_upg_alt'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = phoenix_upg_alt
}}

4. Hive unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("hive_queen") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`)) WHERE `U`.`id` = 'hive_queen'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hive_queen
}}

5. Schism unit, in Japanese:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("succubus") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("3") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`)) WHERE `U`.`id` = 'succubus'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'ja'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = ja
| id = succubus
}}

6. Dungeon unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("hydra") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`)) WHERE `U`.`id` = 'hydra'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hydra
}}

7. Neutral unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("pixie") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("100") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`)) WHERE `U`.`id` = 'pixie'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = pixie
}}

8. Neutral upgraded unit:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("dragon") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `gold_cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`base_sid`=`U0`.`id`)) WHERE `U`.`id` = 'dragon_upg'

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = dragon_upg
}}