User:KickahaOta/sandbox/maps: Difference between revisions
< User:KickahaOta | sandbox
KickahaOta (talk | contribs) No edit summary |
KickahaOta (talk | contribs) (MORE SCIENCE) |
||
Line 3: | Line 3: | ||
|join on = items._pageName=maps._pageName, items._pageName=atlas_maps._pageName, maps.area_id=areas.id, areas.boss_monster_ids HOLDS 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 AND items._pageName=atlas_maps._pageName | |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( | |fields = CONCAT("[[", items._pageName, "|", items.name, "]]")=Map, IF(items._pageName=atlas_maps._pageName, "Yes", "No")=In Atlas, maps.tier=Base Tier, IF(atlas_maps.map_tier0=0, "", atlas_maps.map_tier0)=Tier 0, IF(atlas_maps.map_tier1=0, "", atlas_maps.map_tier1)=Tier 1, IF(atlas_maps.map_tier2=0, "", atlas_maps.map_tier2)=Tier 2, IF(atlas_maps.map_tier3=0, "", atlas_maps.map_tier3)=Tier 3, IF(atlas_maps.map_tier4=0, "", atlas_maps.map_tier4)=Tier 4, CONCAT("[[", monsters.name, "]]", IF(COUNT(*)>1, CONCAT(" +", COUNT(*)-1), ""))=Boss(es) | ||
|order by=maps.tier | |order by=maps.tier ASC, items.name ASC | ||
|group by=items.name | |group by=items.name | ||
}} | }} |