Template:Sandbox/Aurelain/Unit Infobox

Error: the string "--" cannot be used within #cargo_query.

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

Error: the string "--" cannot be used within #cargo_query.

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

Error: the string "--" cannot be used within #cargo_query.

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

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 '.`squad_value` = squad_value AS `CONCAT( ) = units weekly\x0A U squad val...' at line 2

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`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`,`F`.`name` AS `faction_en`,`U`.`tier` AS `tier`,CONCAT("") = units_weekly

   `U`.`squad_value` = squad_value AS `CONCAT(  ) = units weekly
   U squad value = squad value`,`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__Translation` `F` ON ((`U`.`faction`=`F`.`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'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`F`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID` LIMIT 100

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

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 '.`squad_value` = squad_value AS `CONCAT( ) = units weekly\x0A U squad val...' at line 2

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`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`,`F`.`name` AS `faction_en`,`U`.`tier` AS `tier`,CONCAT("") = units_weekly

   `U`.`squad_value` = squad_value AS `CONCAT(  ) = units weekly
   U squad value = squad value`,`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__Translation` `F` ON ((`U`.`faction`=`F`.`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'
   AND `F`.`type` = 'faction'
   AND `F`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`F`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID` LIMIT 100

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