mysql> select badge_name,z.zone_name,t.type_name,b.loc from coh_badges b, coh_zones z,coh_badge_types t where t.type_key = b.type_key and b.zone = z.zone_key and (b.type_key = 8 or b.type_key = 11) order by zone_name, badge_name; +------------------------------+-------------------+-------------+-------------------------+ | badge_name | zone_name | type_name | loc | +------------------------------+-------------------+-------------+-------------------------+ | Expert 1 | Atlas Park | History | 631.7, 0.0, 961.0 | | Freedom | Atlas Park | Exploration | 124, 121, -640 | | Hero Corps Insider | Atlas Park | Exploration | 286.2, 15.9, -880.5 | | Intellectual 1 | Atlas Park | History | 2546.8, -0.0, -1177.2 | | Patriot | Atlas Park | Exploration | 151, -768, -674 | | Pupil 1 | Atlas Park | History | 510.8, 0.5, -1150.8 | | Silent Sentinel | Atlas Park | Exploration | -607.7, 70.3, 1888.3 | | Student 1 | Atlas Park | History | -1144.6, -16.0, -172.2 | | Student 2 | Atlas Park | History | 1324.7, 4.3, 416.0 | | Top Dog | Atlas Park | Exploration | 133.5, 314.0, -340.7 | | Undefeated | Atlas Park | Exploration | 632.6, 84.9, -2327.5 | | Shrouded | Black Shroud | Exploration | ?, ?, ? | | Destined for Valhalla | Boomtown | Exploration | --4097, 351, 2471 | | Disciple 3 | Boomtown | History | -1904.7, 126.7, 755.5 | | Disciple 4 | Boomtown | History | -2652.8, -0.0, 3054.6 | | Disciple 5 | Boomtown | History | -680, 272, 3118 | | Just Said No to Superadine 4 | Boomtown | History | 1144, 0, -145 | | Phalanxer | Boomtown | Exploration | -2002, -15, 5181 | | Regal | Boomtown | Exploration | -450, 42, 2173 | | Scholar 4 | Boomtown | History | -1672, -0.0, 4723.8 | | Vision of Despair | Boomtown | Exploration | -754, 0, -594 | | Inmate | Brickstown | Exploration | -1725.4, 24.3, 1153.3 | | Mystic | Brickstown | Exploration | -592, 32, 1379 | | Scholastic 2 | Brickstown | History | -229.0, 0.0, -369.5 | | Scholastic 3 | Brickstown | History | -3463.0, 0.0, 2067.1 | | Burning the Midnight Oil | Crey's Folly | Exploration | 843, 24, 1799 | | Crey Watcher | Crey's Folly | Exploration | 1079, 0, 2320 | | Savant 2 | Crey's Folly | History | 7226.3, 32.0, -549.8 | | Savant 3 | Crey's Folly | History | 2569.5, 0.0, 2680.1 | | Authority 4 | Dark Astoria | History | 3409.3, 42, 3035 | | Cairn Warder | Dark Astoria | Exploration | 1026, 51, 218 | | Dark Mystic | Dark Astoria | Exploration | 1679, 6, 2835 | | Historian 3 | Dark Astoria | History | 2498.4, 87.4, 488.8 | | Researcher 4 | Dark Astoria | History | 5218.2, 0.0, 135.0 | | Researcher 5 | Dark Astoria | History | 5890, 0, 1547 | | Seeker of the Unknown | Dark Astoria | Exploration | 1868, -80, 1354 | | Crey Fish | Eden | Exploration | -1785, 0, 4549 | | Savant 4 | Eden | History | -2815, -26, 2968 | | Savant 5 | Eden | History | -1317, 0, 4487 | | Unspoiled | Eden | Exploration | 2481, 34, 2352 | | Apex | Faultline | Exploration | 277.7, 57.1, -2256.8 | | Disciple 6 | Faultline | History | 136.8, -866.8, 1019.3 | | Disciple 7 | Faultline | History | 76, -611, -14 | | Faultless Mystic | Faultline | Exploration | -844.6, -406.8, -714.8 | | Just Said No to Superadine 5 | Faultline | History | -904, 17, -1980 | | Newsman | Faultline | Exploration | 1124.5, -27.0, 1295.6 | | Scholar 5 | Faultline | History | -23.9, -574.6, 352.2 | | Undammed | Faultline | Exploration | 76.5, -858.3, 1686.0 | | Chaotician | Founder's Falls | Exploration | 817, -21, 2400 | | Foggy | Founder's Falls | Exploration | 969, 0, 2621 | | Savant 1 | Founder's Falls | History | 4245, 0, 3685 | | Scholastic 1 | Founder's Falls | History | 1721.2, -16.0, 2400.9 | | Bird Watcher | Galaxy City | Exploration | -1099, 48, -2263 | | Blue Shield | Galaxy City | Exploration | -1170, 39, -2469 | | Brawler | Galaxy City | Exploration | -1182, 64, -933 | | Expert 2 | Galaxy City | History | 1160.7, 32.0, -714.0 | | Expert 3 | Galaxy City | History | -413.8, 0.7, 889.6 | | Intellectual 2 | Galaxy City | History | 521.3, 0.8, -489.9 | | Land Locked | Galaxy City | Exploration | -2036, -43, 1002 | | Pupil 2 | Galaxy City | History | -730.4, -0.0, -1337.9 | | Student 3 | Galaxy City | History | -1784.8, 0.0, 498.5 | | Tank | Galaxy City | Exploration | -1178, 73, -586 | | Authority 1 | Independence Port | History | 906.8, 98.1, -4178.4 | | Authority 2 | Independence Port | History | -1036.0, 32.0, -2443.3 | | Crey Havoc | Independence Port | Exploration | -441, 2, -270 | | Historian 1 | Independence Port | History | -1078.7, 3.2, 2316.2 | | Researcher 1 | Independence Port | History | -1627.5, 0 .2, 5256.3 | | Valorous | Independence Port | Exploration | 945, 609, -1151 | | Vigorous | Independence Port | Exploration | -1618.0, 80.0, -1872.2 | | Intellectual 3 | King's Row | History | 627.7, -42, 969.8 | | Intellectual 4 | King's Row | History | -1365.2, -42.0, 687.8 | | Intellectual 6 | King's Row | History | -56, -42, -1082 | | Keen Sighted | King's Row | Exploration | -2176, 97, 1142 | | Mystic King | King's Row | Exploration | -375.3, 70.8, 244.9 | | Pupil 3 | King's Row | History | -177, -42, -1466 | | Pupil 4 | King's Row | History | -401.1, 0.0, 1754.9 | | Smokey | King's Row | Exploration | -3041.9, -41.7, -1356.5 | | Summoned | King's Row | Exploration | -941, -42, 2977 | | Upgraded | King's Row | Exploration | -494.1, 101.4, 766.1 | | Academic 1 | Peregrine Island | History | -1900.2, 0.2, -7229.3 | | Portal Parter | Peregrine Island | Exploration | 3045, 0, 1288 | | Around the Bendis | Perez Park | Exploration | -87, -31, 3660 | | Avatar | Perez Park | Exploration | -1538, -32, 3175 | | Bridge | Perez Park | Exploration | -2016.2, -56.3, 1584.7 | | Doc Whedon | Perez Park | Exploration | -2083, -31, 2853 | | Expert 4 | Perez Park | History | -1277.9, -34.3, 938.2 | | Intellectual 5 | Perez Park | History | 227, 0, 1640 | | Justice Avenger | Perez Park | Exploration | -1033.1, 1.3, 3976.8 | | Pupil 5 | Perez Park | History | -1170.0, -32.0, 2248.6 | | Student 4 | Perez Park | History | -1523.1, 0.0, 3957.5 | | Student 5 | Perez Park | History | -2633, 0, 378 | | Academic 2 | Rikti Crash Site | History | 2012.2, 126.2, -7050.7 | | Ace | Rikti Crash Site | Exploration | 1359, 293, -274 | | Academic 3 | Sewers | History | 465.2, -576.0, -1558.0 | | Heart of the Hamidon | Sewers | Exploration | ?,?,? | | Dauntless | Skyway City | Exploration | -707.1, 0.0, -1075.9 | | Disciple 2 | Skyway City | History | 737.1, -126.0, -3746.7 | | Healing Node | Skyway City | Exploration | 1578.3 -83.7, -677.4 | | Just Said No to Superadine 3 | Skyway City | History | 507.8, 85.2, -5511.5 | | Purifier | Skyway City | Exploration | -1087, -16, -7613 | | Scholar 2 | Skyway City | History | -1466.8, 16.0, -2346.0 | | Scholar 3 | Skyway City | History | 1397.2, -115.8, -1145.3 | | Solace | Skyway City | Exploration | 2262.7,-84.0,-3367.4 | | Bright Star | Steel Canyon | Exploration | -2956.5, -35.7, 1815.4 | | Disciple 1 | Steel Canyon | History | -4023.3, -79.7, -278.3 | | Hero Corps Recruit | Steel Canyon | Exploration | -1765.1, 16.0, 1362.2 | | Just Said No to Superadine 1 | Steel Canyon | History | -1765.9, 0.0, -1277.1 | | Just Said No to Superadine 2 | Steel Canyon | History | -2178.6, 0.2, 751.0 | | Nimble Mynx | Steel Canyon | Exploration | -2427, 48, -3406 | | Scholar 1 | Steel Canyon | History | 4154, 0.0, 2067.2 | | Secret Admirer | Steel Canyon | Exploration | -3438, 0, 2535 | | Authority 3 | Talos Island | History | 1777.3, 18.5, 7846.2 | | Historian 2 | Talos Island | History | 1531, 160, 7553 | | Minotaur | Talos Island | Exploration | 1698, 16, 7700 | | Nature Lover | Talos Island | Exploration | 2671, 124, 9117 | | Researcher 2 | Talos Island | History | 1144.9, 224.8, 5687.9 | | Researcher 3 | Talos Island | History | -3680.3, 128.5, 1517.1 | | Whitecap | Talos Island | Exploration | -5612, 80, 1855 | | Authority 5 | Terra Volta | History | 348.0, 188.0, -3603.4 | | Conjunction Junction | Terra Volta | Exploration | 2224.1, 0.0, -7101.7 | | Historian 4 | Terra Volta | History | 2876.5, 96.0, -3976.9 | | Historian 5 | Terra Volta | History | -637.0, 0.0, -6185.6 | | Meltdown | Terra Volta | Exploration | 1185, 735, -3054 | | Nervous Dreck | Terra Volta | Exploration | 4456.0, 0.4, -6123.8 | | Researcher 6 | Terra Volta | History | 2088.4, 0.0, -6054.5 | | Time Bandit | The Hive | Exploration | 1742, 1, -3823 | +------------------------------+-------------------+-------------+-------------------------+