User:KickahaOta/sandbox/maps
Function: CargoSQLQuery::run Query: SELECT CONCAT("", `cargo__items`.`name`, "") AS `Map`,`cargo__maps`.`tier` AS `Base Tier`,IF(`cargo__items`.`_pageName`=`cargo__atlas_maps`.`_pageName`, "Yes", "No") AS `In Atlas`,`cargo__maps`.`area_id` AS `Area ID`,`boss_monster_ids__full` AS `Boss ID` FROM `cargo__items` LEFT OUTER JOIN `cargo__maps` ON ((`cargo__items`.`_pageName`=`cargo__maps`.`_pageName`)) LEFT OUTER JOIN `cargo__atlas_maps` ON ((`cargo__items`.`_pageName`=`cargo__atlas_maps`.`_pageName`)) LEFT OUTER JOIN `cargo__areas` ON ((`cargo__maps`.`area_id`=`cargo__areas`.`id`)) LEFT OUTER JOIN `cargo__monsters` ON ((`cargo__areas`.`boss_monster_ids`=`cargo__monsters`.`metadata_id`)) WHERE `cargo__maps`.`_pageName`=`cargo__items`.`_pageName` AND `cargo__items`.`drop_enabled` ORDER BY `cargo__maps`.`tier` LIMIT 100