Template:Sandbox/Aurelain/Unit Infobox
Function: CargoSQLQuery::run Query: SELECT `U2`.`_pageID` AS `cargo_backlink_page_id_U2`,`U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`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`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`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`,`B`.`gold_cost` AS `gold_cost0`,`B`.`wood_cost` AS `wood_cost0`,`B`.`ore_cost` AS `ore_cost0`,`B`.`mercury_cost` AS `mercury_cost0`,`B`.`dust_cost` AS `dust_cost0`,`B`.`crystal_cost` AS `crystal_cost0`,`B`.`gemstone_cost` AS `gemstone_cost0`,`B`.`hp` AS `hp0`,`B`.`offence` AS `offence0`,`B`.`defence` AS `defence0`,`B`.`damage_min` AS `damage_min0`,`B`.`damage_max` AS `damage_max0`,`B`.`morale` AS `morale0`,`B`.`luck` AS `luck0`,`B`.`initiative` AS `initiative0`,`B`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U1`,`mw4v_cargo__Unit` `U2` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`U1`.`faction`=`U`.`faction`) AND (`U1`.`tier`=`U`.`tier`) AND (`U2`.`faction`=`U`.`faction`) AND (`U2`.`tier`=`U`.`tier`)) 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` `B` ON ((`U`.`id`=`B`.`id`) AND (`U1`.`base_sid`=`B`.`id`) AND (`U2`.`upgrade_sid`=`B`.`base_sid`)) 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 `U2`.`_pageID`,`U1`.`_pageID`,`B`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen
}}
Function: CargoSQLQuery::run Query: SELECT `U2`.`_pageID` AS `cargo_backlink_page_id_U2`,`U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`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`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`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`,`B`.`gold_cost` AS `gold_cost0`,`B`.`wood_cost` AS `wood_cost0`,`B`.`ore_cost` AS `ore_cost0`,`B`.`mercury_cost` AS `mercury_cost0`,`B`.`dust_cost` AS `dust_cost0`,`B`.`crystal_cost` AS `crystal_cost0`,`B`.`gemstone_cost` AS `gemstone_cost0`,`B`.`hp` AS `hp0`,`B`.`offence` AS `offence0`,`B`.`defence` AS `defence0`,`B`.`damage_min` AS `damage_min0`,`B`.`damage_max` AS `damage_max0`,`B`.`morale` AS `morale0`,`B`.`luck` AS `luck0`,`B`.`initiative` AS `initiative0`,`B`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U1`,`mw4v_cargo__Unit` `U2` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`U1`.`faction`=`U`.`faction`) AND (`U1`.`tier`=`U`.`tier`) AND (`U2`.`faction`=`U`.`faction`) AND (`U2`.`tier`=`U`.`tier`)) 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` `B` ON ((`U`.`base_sid`=`B`.`id`) AND (`U1`.`base_sid`=`B`.`id`) AND (`U2`.`upgrade_sid`=`B`.`base_sid`)) 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 `U2`.`_pageID`,`U1`.`_pageID`,`B`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen_upg
|dwelling=[[Radiant Forge]]
}}
Function: CargoSQLQuery::run Query: SELECT `U2`.`_pageID` AS `cargo_backlink_page_id_U2`,`U1`.`_pageID` AS `cargo_backlink_page_id_U1`,`B`.`_pageID` AS `cargo_backlink_page_id_B`,`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`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier`,`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`,`B`.`gold_cost` AS `gold_cost0`,`B`.`wood_cost` AS `wood_cost0`,`B`.`ore_cost` AS `ore_cost0`,`B`.`mercury_cost` AS `mercury_cost0`,`B`.`dust_cost` AS `dust_cost0`,`B`.`crystal_cost` AS `crystal_cost0`,`B`.`gemstone_cost` AS `gemstone_cost0`,`B`.`hp` AS `hp0`,`B`.`offence` AS `offence0`,`B`.`defence` AS `defence0`,`B`.`damage_min` AS `damage_min0`,`B`.`damage_max` AS `damage_max0`,`B`.`morale` AS `morale0`,`B`.`luck` AS `luck0`,`B`.`initiative` AS `initiative0`,`B`.`speed` AS `speed0` FROM `mw4v_cargo__Unit` `U1`,`mw4v_cargo__Unit` `U2` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`U1`.`faction`=`U`.`faction`) AND (`U1`.`tier`=`U`.`tier`) AND (`U2`.`faction`=`U`.`faction`) AND (`U2`.`tier`=`U`.`tier`)) 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` `B` ON ((`U`.`base_sid`=`B`.`upgrade_sid`) AND (`U1`.`base_sid`=`B`.`id`) AND (`U2`.`upgrade_sid`=`B`.`base_sid`)) 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 `U2`.`_pageID`,`U1`.`_pageID`,`B`.`_pageID`,`F`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen_upg_alt
|dwelling=[[Radiant Forge]]
}}
