Template:Sandbox/Aurelain/Unit Infobox
1. Temple base unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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, with specialist hero:
Hive Queen  |
|||
 |
|||
Faction |
|||
Tier VII |
|||
Squad value 3135 |
|||
| Stats | |||
 Health 200
|
 Attack 25
|
 Defense 25
|
 Damage 60-60
|
 Morale 0
|
 Luck 0
|
 Initiative 8
|
 Speed 6
|
| Related Units | |||
Base unit  Hive Queen |
|||
Upgrade A |
|||
Upgrade B |
|||
| Internal ID | |||
| hive_queen | |||
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hive_queen
| specialist = demon_hero_14
}}
5. Schism unit, in Japanese:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") = specialist
CONCAT("") = units_weekly AS `CONCAT( <strong class= error ><span class= scribunto-error mw-scribunto-error-9a2cb624 >Script error: The function "findSpecialist" does not exist </span></strong> ) = specialist
CONCAT( ) = units weekly`,CONCAT("") AS `dwelling`,CONCAT("") AS `bank`,`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
}}
