select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497855462 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] => 459.017019547353
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137540
[distance] => 84.744335140749
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
[important_3] => 1
[asc_3] => 536
[asc_4] => 135381
[asc_5] => 137526
[distance] => 586.262151177892
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137522
[distance] => 498.207761716273
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137517
[distance] => 476.571541445915
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137515
[distance] => 410.034358316288
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137512
[distance] => 490.787495050185
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137508
[distance] => 607.662689569165
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137507
[distance] => 661.881232364300
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137510
[distance] => 508.316129288435
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137502
[distance] => 395.803581671275
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137380
[distance] => 435.240081544594
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137492
[distance] => 270.841783123516
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137477
[distance] => 470.379532382181
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137476
[distance] => 447.155642337215
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137475
[distance] => 488.011821230113
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137473
[distance] => 468.901645016829
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135368
[asc_5] => 137461
[distance] => 369.405741406820
)
[18] => Array
(
[id] => 497884026
[en] => Essen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137458
[distance] => 482.572716107114
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137451
[distance] => 294.543067672232
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137449
[distance] => 187.110437485159
)
[21] => Array
(
[id] => 497871764
[en] => Furth
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137442
[distance] => 203.780056634229
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137440
[distance] => 482.549859573957
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137431
[distance] => 426.827025169318
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137423
[distance] => 457.196694423634
)
[25] => Array
(
[id] => 497884072
[en] => Halle
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137421
[distance] => 436.572057859768
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135378
[asc_5] => 137420
[distance] => 651.421786667469
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137418
[distance] => 477.122627471165
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137417
[distance] => 524.279681829462
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137413
[distance] => 225.736833172248
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137411
[distance] => 179.507957565655
)
[31] => Array
(
[id] => 497884148
[en] => Herne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137407
[distance] => 482.063279396468
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137394
[distance] => 144.607937030645
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137389
[distance] => 202.527356184914
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137388
[distance] => 407.040609969574
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137384
[distance] => 736.205313559130
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137377
[distance] => 486.654551739325
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137348
[distance] => 432.670179598512
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137346
[distance] => 442.668119649826
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137339
[distance] => 686.451992426935
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137336
[distance] => 241.412456772725
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137333
[distance] => 501.262665936260
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137328
[distance] => 296.818785329416
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137326
[distance] => 241.976685711094
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137309
[distance] => 480.394416022100
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137306
[distance] => 483.882844402580
)
[46] => Array
(
[id] => 497858364
[en] => Munich
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137305
[distance] => 113.371349536037
)
[47] => Array
(
[id] => 497884752
[en] => Munster
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137304
[distance] => 511.632153676633
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137296
[distance] => 469.229941912016
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137283
[distance] => 201.853629223934
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137279
[distance] => 487.645414451077
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137273
[distance] => 289.891540711772
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137270
[distance] => 624.068711544552
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137267
[distance] => 534.405561870911
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137259
[distance] => 461.161584061423
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137254
[distance] => 179.005998613208
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
[important_3] => 1
[asc_3] => 536
[asc_4] => 135380
[asc_5] => 137249
[distance] => 558.149953185440
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137241
[distance] => 197.548624671905
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137243
[distance] => 489.552279143987
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137240
[distance] => 448.157905304123
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137237
[distance] => 120.458263100384
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
[important_3] => 1
[asc_3] => 536
[asc_4] => 135376
[asc_5] => 137226
[distance] => 721.320408176301
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
[important_3] => 1
[asc_3] => 536
[asc_4] => 135372
[asc_5] => 137188
[distance] => 301.085594753995
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137195
[distance] => 452.967699146282
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137178
[distance] => 147.269988642670
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137163
[distance] => 82.064786362023
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137137
[distance] => 305.544790003179
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137131
[distance] => 526.946141362602
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137128
[distance] => 456.122409165431
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137127
[distance] => 235.152659501450
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه