I haven't seen these listed for a while, thought it might be useful:
Zone IDs in id order
Code:
+--------------+------------------+
| zoneidnumber | short_name |
+--------------+------------------+
| 1 | qeynos |
| 2 | qeynos2 |
| 3 | qrg |
| 4 | qeytoqrg |
| 5 | highpass |
| 6 | highkeep |
| 8 | freportn |
| 9 | freportw |
| 10 | freporte |
| 11 | runnyeye |
| 12 | qey2hh1 |
| 13 | northkarana |
| 14 | southkarana |
| 15 | eastkarana |
| 16 | beholder |
| 17 | blackburrow |
| 18 | paw |
| 19 | rivervale |
| 20 | kithicor |
| 21 | commons |
| 22 | ecommons |
| 23 | erudnint |
| 24 | erudnext |
| 25 | nektulos |
| 26 | cshome |
| 27 | lavastorm |
| 28 | nektropos |
| 29 | halas |
| 30 | everfrost |
| 31 | soldunga |
| 32 | soldungb |
| 33 | misty |
| 34 | nro |
| 35 | sro |
| 36 | befallen |
| 37 | oasis |
| 38 | tox |
| 39 | hole |
| 40 | neriaka |
| 41 | neriakb |
| 42 | neriakc |
| 43 | neriakd |
| 44 | najena |
| 45 | qcat |
| 46 | innothule |
| 47 | feerrott |
| 48 | cazicthule |
| 49 | oggok |
| 50 | rathemtn |
| 51 | lakerathe |
| 52 | gukta |
| 53 | aviak |
| 54 | gfaydark |
| 55 | akanon |
| 56 | steamfont |
| 57 | lfaydark |
| 58 | crushbone |
| 59 | mistmoore |
| 60 | kaladima |
| 61 | felwithea |
| 62 | felwitheb |
| 63 | unrest |
| 64 | kedge |
| 65 | guktop |
| 66 | gukbottom |
| 67 | kaladimb |
| 68 | butcher |
| 69 | oot |
| 70 | cauldron |
| 71 | airplane |
| 72 | fearplane |
| 73 | permafrost |
| 74 | kerraridge |
| 75 | paineel |
| 76 | hateplane |
| 77 | arena |
| 78 | fieldofbone |
| 79 | warslikswood |
| 80 | soltemple |
| 81 | droga |
| 82 | cabwest |
| 83 | swampofnohope |
| 84 | firiona |
| 85 | lakeofillomen |
| 86 | dreadlands |
| 87 | burningwood |
| 88 | kaesora |
| 89 | sebilis |
| 90 | citymist |
| 91 | skyfire |
| 92 | frontiermtns |
| 93 | overthere |
| 94 | emeraldjungle |
| 95 | trakanon |
| 96 | timorous |
| 97 | kurn |
| 98 | erudsxing |
| 100 | stonebrunt |
| 101 | warrens |
| 102 | karnor |
| 103 | chardok |
| 104 | dalnir |
| 105 | charasis |
| 106 | cabeast |
| 107 | nurga |
| 108 | veeshan |
| 109 | veksar |
| 110 | iceclad |
| 111 | frozenshadow |
| 112 | velketor |
| 113 | kael |
| 114 | skyshrine |
| 115 | thurgadina |
| 116 | eastwastes |
| 117 | cobaltscar |
| 118 | greatdivide |
| 119 | wakening |
| 120 | westwastes |
| 121 | crystal |
| 123 | necropolis |
| 124 | templeveeshan |
| 125 | sirens |
| 126 | mischiefplane |
| 127 | growthplane |
| 128 | sleeper |
| 129 | thurgadinb |
| 130 | erudsxing2 |
| 150 | shadowhaven |
| 151 | bazaar |
| 152 | nexus |
| 153 | echo |
| 154 | acrylia |
| 155 | sharvahl |
| 156 | paludal |
| 157 | fungusgrove |
| 158 | vexthal |
| 159 | sseru |
| 160 | katta |
| 161 | netherbian |
| 162 | ssratemple |
| 163 | griegsend |
| 164 | thedeep |
| 165 | shadeweaver |
| 166 | hollowshade |
| 167 | grimling |
| 168 | mseru |
| 169 | letalis |
| 170 | twilight |
| 171 | thegrey |
| 172 | tenebrous |
| 173 | maiden |
| 174 | dawnshroud |
| 175 | scarlet |
| 176 | umbral |
| 179 | akheva |
| 180 | arena2 |
| 181 | jaggedpine |
| 182 | nedaria |
| 183 | tutorial |
| 184 | load |
| 185 | load2 |
| 186 | hateplaneb |
| 187 | shadowrest |
| 188 | tutoriala |
| 189 | tutorialb |
| 200 | codecay |
| 201 | pojustice |
| 202 | poknowledge |
| 203 | potranquility |
| 204 | ponightmare |
| 205 | podisease |
| 206 | poinnovation |
| 207 | potorment |
| 208 | povalor |
| 209 | bothunder |
| 210 | postorms |
| 211 | hohonora |
| 212 | solrotower |
| 213 | powar |
| 214 | potactics |
| 215 | poair |
| 216 | powater |
| 217 | pofire |
| 218 | poeartha |
| 219 | potimea |
| 220 | hohonorb |
| 221 | nightmareb |
| 222 | poearthb |
| 223 | potimeb |
| 224 | gunthak |
| 225 | dulak |
| 226 | torgiran |
| 227 | nadox |
| 228 | hatesfury |
| 229 | guka |
| 230 | ruja |
| 231 | taka |
| 232 | mira |
| 233 | mmca |
| 234 | gukb |
| 235 | rujb |
| 236 | takb |
| 237 | mirb |
| 238 | mmcb |
| 239 | gukc |
| 240 | rujc |
| 241 | takc |
| 242 | mirc |
| 243 | mmcc |
| 244 | gukd |
| 245 | rujd |
| 246 | takd |
| 247 | mird |
| 248 | mmcd |
| 249 | guke |
| 250 | ruje |
| 251 | take |
| 252 | mire |
| 253 | mmce |
| 254 | gukf |
| 255 | rujf |
| 256 | takf |
| 257 | mirf |
| 258 | mmcf |
| 259 | gukg |
| 260 | rujg |
| 261 | takg |
| 262 | mirg |
| 263 | mmcg |
| 264 | gukh |
| 265 | rujh |
| 266 | takh |
| 267 | mirh |
| 268 | mmch |
| 269 | ruji |
| 270 | taki |
| 271 | miri |
| 272 | mmci |
| 273 | rujj |
| 274 | takj |
| 275 | mirj |
| 276 | mmcj |
| 277 | chardokb |
| 278 | soldungc |
| 279 | abysmal |
| 280 | natimbi |
| 281 | qinimi |
| 282 | riwwi |
| 283 | barindu |
| 284 | ferubi |
| 285 | snpool |
| 286 | snlair |
| 287 | snplant |
| 288 | snfurnace |
| 289 | tipt |
| 290 | vxed |
| 291 | yxtta |
| 292 | uqua |
| 293 | kodtaz |
| 294 | ikkinz |
| 295 | inktuta |
| 296 | txevu |
| 297 | tacvi |
| 298 | qvic |
| 299 | qvicb |
| 300 | wallofslaughter |
| 301 | bloodfields |
| 302 | draniksscar |
| 303 | causeway |
| 304 | chambersa |
| 305 | chambersb |
| 306 | chambersc |
| 307 | chambersd |
| 308 | chamberse |
| 309 | chambersf |
| 316 | provinggrounds |
| 317 | anguish |
| 318 | dranikhollowsa |
| 319 | dranikhollowsb |
| 320 | dranikhollowsc |
| 321 | dranikhollowsd |
| 322 | dranikhollowse |
| 323 | dranikhollowsf |
| 324 | dranikhollowsg |
| 325 | dranikhollowsh |
| 326 | dranikhollowsi |
| 327 | dranikhollowsj |
| 328 | dranikcatacombsa |
| 329 | dranikcatacombsb |
| 330 | dranikcatacombsc |
| 331 | draniksewersa |
| 332 | draniksewersb |
| 333 | draniksewersc |
| 334 | riftseekers |
| 335 | harbingers |
| 336 | dranik |
| 995 | arttest |
| 998 | fhalls |
+--------------+------------------+
298 rows in set (0.09 sec)
Zone IDs in short name order
Code:
+--------------+------------------+
| zoneidnumber | short_name |
+--------------+------------------+
| 279 | abysmal |
| 154 | acrylia |
| 71 | airplane |
| 55 | akanon |
| 179 | akheva |
| 317 | anguish |
| 77 | arena |
| 180 | arena2 |
| 995 | arttest |
| 53 | aviak |
| 283 | barindu |
| 151 | bazaar |
| 36 | befallen |
| 16 | beholder |
| 17 | blackburrow |
| 301 | bloodfields |
| 209 | bothunder |
| 87 | burningwood |
| 68 | butcher |
| 106 | cabeast |
| 82 | cabwest |
| 70 | cauldron |
| 303 | causeway |
| 48 | cazicthule |
| 304 | chambersa |
| 305 | chambersb |
| 306 | chambersc |
| 307 | chambersd |
| 308 | chamberse |
| 309 | chambersf |
| 105 | charasis |
| 103 | chardok |
| 277 | chardokb |
| 90 | citymist |
| 117 | cobaltscar |
| 200 | codecay |
| 21 | commons |
| 58 | crushbone |
| 121 | crystal |
| 26 | cshome |
| 104 | dalnir |
| 174 | dawnshroud |
| 336 | dranik |
| 328 | dranikcatacombsa |
| 329 | dranikcatacombsb |
| 330 | dranikcatacombsc |
| 318 | dranikhollowsa |
| 319 | dranikhollowsb |
| 320 | dranikhollowsc |
| 321 | dranikhollowsd |
| 322 | dranikhollowse |
| 323 | dranikhollowsf |
| 324 | dranikhollowsg |
| 325 | dranikhollowsh |
| 326 | dranikhollowsi |
| 327 | dranikhollowsj |
| 331 | draniksewersa |
| 332 | draniksewersb |
| 333 | draniksewersc |
| 302 | draniksscar |
| 86 | dreadlands |
| 81 | droga |
| 225 | dulak |
| 15 | eastkarana |
| 116 | eastwastes |
| 153 | echo |
| 22 | ecommons |
| 94 | emeraldjungle |
| 24 | erudnext |
| 23 | erudnint |
| 98 | erudsxing |
| 130 | erudsxing2 |
| 30 | everfrost |
| 72 | fearplane |
| 47 | feerrott |
| 61 | felwithea |
| 62 | felwitheb |
| 284 | ferubi |
| 998 | fhalls |
| 78 | fieldofbone |
| 84 | firiona |
| 10 | freporte |
| 8 | freportn |
| 9 | freportw |
| 92 | frontiermtns |
| 111 | frozenshadow |
| 157 | fungusgrove |
| 54 | gfaydark |
| 118 | greatdivide |
| 163 | griegsend |
| 167 | grimling |
| 127 | growthplane |
| 229 | guka |
| 234 | gukb |
| 66 | gukbottom |
| 239 | gukc |
| 244 | gukd |
| 249 | guke |
| 254 | gukf |
| 259 | gukg |
| 264 | gukh |
| 52 | gukta |
| 65 | guktop |
| 224 | gunthak |
| 29 | halas |
| 335 | harbingers |
| 76 | hateplane |
| 186 | hateplaneb |
| 228 | hatesfury |
| 6 | highkeep |
| 5 | highpass |
| 211 | hohonora |
| 220 | hohonorb |
| 39 | hole |
| 166 | hollowshade |
| 110 | iceclad |
| 294 | ikkinz |
| 295 | inktuta |
| 46 | innothule |
| 181 | jaggedpine |
| 113 | kael |
| 88 | kaesora |
| 60 | kaladima |
| 67 | kaladimb |
| 102 | karnor |
| 160 | katta |
| 64 | kedge |
| 74 | kerraridge |
| 20 | kithicor |
| 293 | kodtaz |
| 97 | kurn |
| 85 | lakeofillomen |
| 51 | lakerathe |
| 27 | lavastorm |
| 169 | letalis |
| 57 | lfaydark |
| 184 | load |
| 185 | load2 |
| 173 | maiden |
| 232 | mira |
| 237 | mirb |
| 242 | mirc |
| 247 | mird |
| 252 | mire |
| 257 | mirf |
| 262 | mirg |
| 267 | mirh |
| 271 | miri |
| 275 | mirj |
| 126 | mischiefplane |
| 59 | mistmoore |
| 33 | misty |
| 233 | mmca |
| 238 | mmcb |
| 243 | mmcc |
| 248 | mmcd |
| 253 | mmce |
| 258 | mmcf |
| 263 | mmcg |
| 268 | mmch |
| 272 | mmci |
| 276 | mmcj |
| 168 | mseru |
| 227 | nadox |
| 44 | najena |
| 280 | natimbi |
| 123 | necropolis |
| 182 | nedaria |
| 28 | nektropos |
| 25 | nektulos |
| 40 | neriaka |
| 41 | neriakb |
| 42 | neriakc |
| 43 | neriakd |
| 161 | netherbian |
| 152 | nexus |
| 221 | nightmareb |
| 13 | northkarana |
| 34 | nro |
| 107 | nurga |
| 37 | oasis |
| 49 | oggok |
| 69 | oot |
| 93 | overthere |
| 75 | paineel |
| 156 | paludal |
| 18 | paw |
| 73 | permafrost |
| 215 | poair |
| 205 | podisease |
| 218 | poeartha |
| 222 | poearthb |
| 217 | pofire |
| 206 | poinnovation |
| 201 | pojustice |
| 202 | poknowledge |
| 204 | ponightmare |
| 210 | postorms |
| 214 | potactics |
| 219 | potimea |
| 223 | potimeb |
| 207 | potorment |
| 203 | potranquility |
| 208 | povalor |
| 213 | powar |
| 216 | powater |
| 316 | provinggrounds |
| 45 | qcat |
| 12 | qey2hh1 |
| 1 | qeynos |
| 2 | qeynos2 |
| 4 | qeytoqrg |
| 281 | qinimi |
| 3 | qrg |
| 298 | qvic |
| 299 | qvicb |
| 50 | rathemtn |
| 334 | riftseekers |
| 19 | rivervale |
| 282 | riwwi |
| 230 | ruja |
| 235 | rujb |
| 240 | rujc |
| 245 | rujd |
| 250 | ruje |
| 255 | rujf |
| 260 | rujg |
| 265 | rujh |
| 269 | ruji |
| 273 | rujj |
| 11 | runnyeye |
| 175 | scarlet |
| 89 | sebilis |
| 165 | shadeweaver |
| 150 | shadowhaven |
| 187 | shadowrest |
| 155 | sharvahl |
| 125 | sirens |
| 91 | skyfire |
| 114 | skyshrine |
| 128 | sleeper |
| 288 | snfurnace |
| 286 | snlair |
| 287 | snplant |
| 285 | snpool |
| 31 | soldunga |
| 32 | soldungb |
| 278 | soldungc |
| 212 | solrotower |
| 80 | soltemple |
| 14 | southkarana |
| 35 | sro |
| 159 | sseru |
| 162 | ssratemple |
| 56 | steamfont |
| 100 | stonebrunt |
| 83 | swampofnohope |
| 297 | tacvi |
| 231 | taka |
| 236 | takb |
| 241 | takc |
| 246 | takd |
| 251 | take |
| 256 | takf |
| 261 | takg |
| 266 | takh |
| 270 | taki |
| 274 | takj |
| 124 | templeveeshan |
| 172 | tenebrous |
| 164 | thedeep |
| 171 | thegrey |
| 115 | thurgadina |
| 129 | thurgadinb |
| 96 | timorous |
| 289 | tipt |
| 226 | torgiran |
| 38 | tox |
| 95 | trakanon |
| 183 | tutorial |
| 188 | tutoriala |
| 189 | tutorialb |
| 170 | twilight |
| 296 | txevu |
| 176 | umbral |
| 63 | unrest |
| 292 | uqua |
| 108 | veeshan |
| 109 | veksar |
| 112 | velketor |
| 158 | vexthal |
| 290 | vxed |
| 119 | wakening |
| 300 | wallofslaughter |
| 101 | warrens |
| 79 | warslikswood |
| 120 | westwastes |
| 291 | yxtta |
+--------------+------------------+
298 rows in set (0.05 sec)