select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497855355 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] => 504.423952999071
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137540
[distance] => 78.624537269149
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
[important_3] => 1
[asc_3] => 536
[asc_4] => 135381
[asc_5] => 137526
[distance] => 565.981219638421
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137522
[distance] => 519.551748889812
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137517
[distance] => 510.566878846278
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137515
[distance] => 450.257992361916
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137512
[distance] => 526.144737676931
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137508
[distance] => 623.402570210585
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137507
[distance] => 677.848010467556
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137510
[distance] => 512.596477347064
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137502
[distance] => 372.286445724530
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137380
[distance] => 474.517563282322
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137492
[distance] => 306.449572544173
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137477
[distance] => 502.306465064513
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137476
[distance] => 417.989257515421
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137475
[distance] => 525.112993756540
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137473
[distance] => 507.099591524919
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135368
[asc_5] => 137461
[distance] => 368.196794956514
)
[18] => Array
(
[id] => 497884026
[en] => Essen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137458
[distance] => 517.901401684239
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137451
[distance] => 327.059655870488
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137449
[distance] => 250.902194128676
)
[21] => Array
(
[id] => 497871764
[en] => Furth
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137442
[distance] => 200.680522539814
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137440
[distance] => 516.923200986051
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137431
[distance] => 437.582426913769
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137423
[distance] => 490.185053774370
)
[25] => Array
(
[id] => 497884072
[en] => Halle
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137421
[distance] => 426.237912707394
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135378
[asc_5] => 137420
[distance] => 657.167877640733
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137418
[distance] => 505.801026934890
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137417
[distance] => 534.900771493762
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137413
[distance] => 266.465502316256
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137411
[distance] => 217.424731928521
)
[31] => Array
(
[id] => 497884148
[en] => Herne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137407
[distance] => 515.599335528423
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137394
[distance] => 122.602805044186
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137389
[distance] => 252.475702713256
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137388
[distance] => 422.905458513213
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137384
[distance] => 741.990191345298
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137377
[distance] => 525.584246817207
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137348
[distance] => 417.444158207787
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137346
[distance] => 481.131251170359
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137339
[distance] => 689.227041965030
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137336
[distance] => 284.006729940253
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137333
[distance] => 495.792025760024
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137328
[distance] => 334.916605008696
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137326
[distance] => 283.997642323913
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137309
[distance] => 520.953473975248
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137306
[distance] => 520.334453603936
)
[46] => Array
(
[id] => 497858364
[en] => Munich
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137305
[distance] => 64.701538395064
)
[47] => Array
(
[id] => 497884752
[en] => Munster
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137304
[distance] => 539.930133523686
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137296
[distance] => 508.297567611093
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137283
[distance] => 197.037301889026
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137279
[distance] => 523.825599383547
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137273
[distance] => 321.590432930871
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137270
[distance] => 643.434549339263
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137267
[distance] => 558.156786821436
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137259
[distance] => 482.190633499131
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137254
[distance] => 228.106782552427
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
[important_3] => 1
[asc_3] => 536
[asc_4] => 135380
[asc_5] => 137249
[distance] => 541.839684945254
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137241
[distance] => 164.075160994224
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137243
[distance] => 522.765759373997
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137240
[distance] => 484.303148613558
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137237
[distance] => 171.813989203297
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
[important_3] => 1
[asc_3] => 536
[asc_4] => 135376
[asc_5] => 137226
[distance] => 715.622341041511
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
[important_3] => 1
[asc_3] => 536
[asc_4] => 135372
[asc_5] => 137188
[distance] => 356.037938102065
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137195
[distance] => 489.950566473510
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137178
[distance] => 192.221577574106
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137163
[distance] => 120.416495752093
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137137
[distance] => 343.078701305226
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137131
[distance] => 528.918250312163
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137128
[distance] => 491.758385668681
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137127
[distance] => 252.640321747099
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه