User:KickahaOta/sandbox/maps: Difference between revisions
KickahaOta (talk | contribs) (Science in progress) |
KickahaOta (talk | contribs) (Broken) |
||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items, maps, atlas_maps, areas | |tables = items, maps, atlas_maps, areas, monsters | ||
|join on = items._pageName=maps._pageName, items._pageName = atlas_maps._pageName, maps.area_id=areas.id | |join on = items._pageName=maps._pageName, items._pageName=atlas_maps._pageName, maps.area_id=areas.id, monsters.metadata_id=areas.boss_monster_ids | ||
|where=maps._pageName=items._pageName AND items.drop_enabled | |where=maps._pageName=items._pageName AND items.drop_enabled | ||
|fields = CONCAT("[[", items._pageName, "|", items.name, "]]")=Map, maps.tier=Base Tier, IF(items._pageName=atlas_maps._pageName, "Yes", "No")=In Atlas, maps.area_id=Area ID, areas.boss_monster_ids=Boss ID | |fields = CONCAT("[[", items._pageName, "|", items.name, "]]")=Map, maps.tier=Base Tier, IF(items._pageName=atlas_maps._pageName, "Yes", "No")=In Atlas, maps.area_id=Area ID, areas.boss_monster_ids=Boss ID | ||
|order by=tier | |order by=maps.tier | ||
}} | }} |
Revision as of 19:09, 22 November 2021
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