User:KickahaOta/sandbox/maps: Difference between revisions
< User:KickahaOta | sandbox
KickahaOta (talk | contribs) (Broken) |
KickahaOta (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items, maps, atlas_maps, areas, monsters | |tables = items, maps, atlas_maps, areas, monsters | ||
|join on = items._pageName=maps._pageName, items._pageName=atlas_maps._pageName, maps.area_id=areas.id, monsters.metadata_id | |join on = items._pageName=maps._pageName, items._pageName=atlas_maps._pageName, maps.area_id=areas.id, areas.boss_monster_ids HOLDS monsters.metadata_id | ||
|where=maps._pageName=items._pageName AND items.drop_enabled | |where=maps._pageName=items._pageName AND items.drop_enabled AND items._pageName=atlas_maps._pageName | ||
|fields = CONCAT("[[", items._pageName, "|", items.name, "]]")=Map, maps.tier=Base Tier, IF(items._pageName=atlas_maps._pageName, "Yes", "No")=In Atlas, | |fields = CONCAT("[[", items._pageName, "|", items.name, "]]")=Map, maps.tier=Base Tier, IF(items._pageName=atlas_maps._pageName, "Yes", "No")=In Atlas, CONCAT("[[", monsters.name, "]]")=Boss | ||
|order by=maps.tier | |order by=maps.tier | ||
|group by=items.name | |||
}} | }} |