Template:Sandbox/Aurelain/Unit Infobox
Function: CargoSQLQuery::run Query: SELECT `B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier` FROM `mw4v_cargo__Translation` `E`,`mw4v_cargo__Translation` `F`,`mw4v_cargo__Translation` `T`,`mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`E`.`target_id`=`U`.`id`) AND (`F`.`target_id`=`U`.`faction`) AND (`T`.`target_id`=`U`.`id`) AND (`B`.`id`=`U`.`id`)) 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 `B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`U`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen
}}
Function: CargoSQLQuery::run Query: SELECT `B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier` FROM `mw4v_cargo__Translation` `E`,`mw4v_cargo__Translation` `F`,`mw4v_cargo__Translation` `T`,`mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`E`.`target_id`=`U`.`id`) AND (`F`.`target_id`=`U`.`faction`) AND (`T`.`target_id`=`U`.`id`) AND (`B`.`id`=`U`.`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 `B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`U`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen_upg
|dwelling=[[Radiant Forge]]
}}
Function: CargoSQLQuery::run Query: SELECT `B`.`_pageID` AS `cargo_backlink_page_id_B`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`F`.`_pageID` AS `cargo_backlink_page_id_F`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`E`.`name` AS `name`,`T`.`name` AS `title`,CONCAT("en") AS `lang`,`U`.`id` AS `id`,`F`.`name` AS `faction`,`U`.`tier` AS `tier` FROM `mw4v_cargo__Translation` `E`,`mw4v_cargo__Translation` `F`,`mw4v_cargo__Translation` `T`,`mw4v_cargo__Unit` `B` LEFT OUTER JOIN `mw4v_cargo__Unit` `U` ON ((`E`.`target_id`=`U`.`id`) AND (`F`.`target_id`=`U`.`faction`) AND (`T`.`target_id`=`U`.`id`) AND (`B`.`upgrade_sid`=`U`.`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 `B`.`_pageID`,`T`.`_pageID`,`F`.`_pageID`,`U`.`_pageID`,`E`.`_pageID` LIMIT 100
{{Sandbox/Aurelain/Unit Infobox
|id=hive_queen_upg_alt
|dwelling=[[Radiant Forge]]
}}


