select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497879036 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array
(
[0] => Array
(
[id] => 497882396
[en] => Aachen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137558
[distance] => 389.308676782419
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137540
[distance] => 213.037983497526
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
[important_3] => 1
[asc_3] => 536
[asc_4] => 135381
[asc_5] => 137526
[distance] => 294.697605872841
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137522
[distance] => 289.568714902711
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137517
[distance] => 334.133584256849
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137515
[distance] => 318.285901944229
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137512
[distance] => 353.521451226008
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137508
[distance] => 368.208538941208
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137507
[distance] => 420.926069497703
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137510
[distance] => 237.668474385213
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137502
[distance] => 118.752280929512
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137380
[distance] => 331.636942386557
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137492
[distance] => 210.168982707413
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137477
[distance] => 317.771834782953
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137476
[distance] => 180.539619715319
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137475
[distance] => 361.156656102769
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137473
[distance] => 351.886440447064
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135368
[asc_5] => 137461
[distance] => 91.572302873436
)
[18] => Array
(
[id] => 497884026
[en] => Essen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137458
[distance] => 346.529693578489
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137451
[distance] => 203.305984526401
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137449
[distance] => 365.673445282487
)
[21] => Array
(
[id] => 497871764
[en] => Furth
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137442
[distance] => 92.242232945950
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137440
[distance] => 341.170802135840
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137431
[distance] => 183.432447341519
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137423
[distance] => 312.791101504222
)
[25] => Array
(
[id] => 497884072
[en] => Halle
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137421
[distance] => 142.225421996365
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135378
[asc_5] => 137420
[distance] => 381.002497940693
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137418
[distance] => 306.382697408724
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137417
[distance] => 271.760786098038
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137413
[distance] => 222.717271041510
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137411
[distance] => 205.662412325669
)
[31] => Array
(
[id] => 497884148
[en] => Herne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137407
[distance] => 336.151921840934
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137394
[distance] => 162.496863758743
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137389
[distance] => 263.690811816279
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137388
[distance] => 188.309017552057
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137384
[distance] => 464.745942985489
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137377
[distance] => 370.776745275805
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137348
[distance] => 138.733993733347
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137346
[distance] => 332.537121920161
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137339
[distance] => 409.069035641260
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137336
[distance] => 236.665954384750
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137333
[distance] => 211.352740652265
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137328
[distance] => 234.530003421716
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137326
[distance] => 233.831784045602
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137309
[distance] => 375.485731403059
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137306
[distance] => 353.993806703652
)
[46] => Array
(
[id] => 497858364
[en] => Munich
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137305
[distance] => 231.000971648856
)
[47] => Array
(
[id] => 497884752
[en] => Munster
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137304
[distance] => 333.917803381604
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137296
[distance] => 357.331199317183
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137283
[distance] => 93.307741040425
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137279
[distance] => 355.562391395500
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137273
[distance] => 197.101736408792
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137270
[distance] => 397.121870194885
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137267
[distance] => 332.497511065267
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137259
[distance] => 256.096105338019
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137254
[distance] => 253.257746091414
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
[important_3] => 1
[asc_3] => 536
[asc_4] => 135380
[asc_5] => 137249
[distance] => 263.937189815311
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137241
[distance] => 140.874491277005
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137243
[distance] => 340.640483516408
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137240
[distance] => 323.292896382406
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137237
[distance] => 256.211819238937
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
[important_3] => 1
[asc_3] => 536
[asc_4] => 135376
[asc_5] => 137226
[distance] => 430.944156864017
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
[important_3] => 1
[asc_3] => 536
[asc_4] => 135372
[asc_5] => 137188
[distance] => 345.243143957076
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137195
[distance] => 331.953869373976
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137178
[distance] => 232.738160000896
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137163
[distance] => 232.771923278793
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137137
[distance] => 235.664793578001
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137131
[distance] => 250.100665126328
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137128
[distance] => 326.718654984824
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137127
[distance] => 123.251377316065
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه