select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497862047 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] => 500.453779272249
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137540
[distance] => 97.479165984252
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
[important_3] => 1
[asc_3] => 536
[asc_4] => 135381
[asc_5] => 137526
[distance] => 449.827978240098
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137522
[distance] => 462.441915923882
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137517
[distance] => 479.377535309874
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137515
[distance] => 436.127569755362
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137512
[distance] => 497.297574365874
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137508
[distance] => 553.052556958818
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137507
[distance] => 606.690053778585
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137510
[distance] => 426.775965001741
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137502
[distance] => 255.919217469207
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137380
[distance] => 456.900256317860
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137492
[distance] => 293.693741704745
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137477
[distance] => 467.031379585428
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137476
[distance] => 296.821596701166
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137475
[distance] => 500.217383999167
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137473
[distance] => 485.466660581196
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135368
[asc_5] => 137461
[distance] => 280.175937386531
)
[18] => Array
(
[id] => 497884026
[en] => Essen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137458
[distance] => 489.329360684758
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137451
[distance] => 305.274200315829
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137449
[distance] => 326.243916552219
)
[21] => Array
(
[id] => 497871764
[en] => Furth
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137442
[distance] => 132.436655675978
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137440
[distance] => 486.289168022123
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137431
[distance] => 365.182413710092
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137423
[distance] => 457.730224894244
)
[25] => Array
(
[id] => 497884072
[en] => Halle
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137421
[distance] => 322.797262986738
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135378
[asc_5] => 137420
[distance] => 570.190556611214
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137418
[distance] => 463.609275457814
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137417
[distance] => 458.407082819740
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137413
[distance] => 270.459882809126
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137411
[distance] => 224.583606320702
)
[31] => Array
(
[id] => 497884148
[en] => Herne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137407
[distance] => 483.198991367467
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137394
[distance] => 58.294354775851
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137389
[distance] => 280.056691783054
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137388
[distance] => 360.299383347881
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137384
[distance] => 653.768688242519
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137377
[distance] => 504.872055951995
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137348
[distance] => 308.432915568284
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137346
[distance] => 461.300340718521
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137339
[distance] => 597.478240997288
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137336
[distance] => 289.717358337351
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137333
[distance] => 396.642483640716
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137328
[distance] => 324.491844647347
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137326
[distance] => 288.396433878870
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137309
[distance] => 504.269181777203
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137306
[distance] => 494.167262989044
)
[46] => Array
(
[id] => 497858364
[en] => Munich
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137305
[distance] => 59.453810400204
)
[47] => Array
(
[id] => 497884752
[en] => Munster
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137304
[distance] => 495.590591407621
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137296
[distance] => 488.627601974762
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137283
[distance] => 126.600826908803
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137279
[distance] => 496.905995282190
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137273
[distance] => 298.679790847864
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137270
[distance] => 578.951970139467
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137267
[distance] => 504.209487298078
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137259
[distance] => 426.059467736449
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137254
[distance] => 257.496350351962
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
[important_3] => 1
[asc_3] => 536
[asc_4] => 135380
[asc_5] => 137249
[distance] => 429.478654325085
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137241
[distance] => 49.120244286876
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137243
[distance] => 489.371627931207
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137240
[distance] => 459.052600068570
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137237
[distance] => 218.147039832470
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
[important_3] => 1
[asc_3] => 536
[asc_4] => 135376
[asc_5] => 137226
[distance] => 612.672259370666
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
[important_3] => 1
[asc_3] => 536
[asc_4] => 135372
[asc_5] => 137188
[distance] => 387.120829663196
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137195
[distance] => 466.317426923862
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137178
[distance] => 219.981054459433
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137163
[distance] => 163.344603437355
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137137
[distance] => 330.583927792034
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137131
[distance] => 439.196855434768
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137128
[distance] => 465.019825533440
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137127
[distance] => 211.315952461084
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه