select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497881782 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] => 232.807953281054
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137540
[distance] => 275.667396323487
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
[important_3] => 1
[asc_3] => 536
[asc_4] => 135381
[asc_5] => 137526
[distance] => 363.200411653723
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137522
[distance] => 165.694665912141
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137517
[distance] => 179.281373273919
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137515
[distance] => 161.628797780771
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137512
[distance] => 198.264302567061
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137508
[distance] => 274.207161129736
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
[important_3] => 1
[asc_3] => 536
[asc_4] => 135379
[asc_5] => 137507
[distance] => 328.251703179660
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137510
[distance] => 197.146287667293
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137502
[distance] => 249.287884278443
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137380
[distance] => 173.532409662596
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137492
[distance] => 100.859640898573
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137477
[distance] => 164.800523671127
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137476
[distance] => 308.737843615531
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137475
[distance] => 204.408963364173
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137473
[distance] => 193.985354318502
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135368
[asc_5] => 137461
[distance] => 121.605631005294
)
[18] => Array
(
[id] => 497884026
[en] => Essen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137458
[distance] => 190.823737950245
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137451
[distance] => 76.662928411097
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137449
[distance] => 315.068634221546
)
[21] => Array
(
[id] => 497871764
[en] => Furth
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137442
[distance] => 171.797944337982
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137440
[distance] => 186.342689889788
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137431
[distance] => 105.654899894651
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137423
[distance] => 157.544347934435
)
[25] => Array
(
[id] => 497884072
[en] => Halle
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137421
[distance] => 202.417730959053
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135378
[asc_5] => 137420
[distance] => 329.246681637217
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137418
[distance] => 159.403115352750
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137417
[distance] => 197.101287452697
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137413
[distance] => 144.570114859442
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137411
[distance] => 167.227815639038
)
[31] => Array
(
[id] => 497884148
[en] => Herne
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137407
[distance] => 182.177748608830
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137394
[distance] => 254.441034066850
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137389
[distance] => 195.688010573394
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137388
[distance] => 75.870751784368
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137384
[distance] => 412.145785267514
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137377
[distance] => 213.062869038722
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
[important_3] => 1
[asc_3] => 536
[asc_4] => 135371
[asc_5] => 137348
[distance] => 224.930173045490
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137346
[distance] => 174.276720568876
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135369
[asc_5] => 137339
[distance] => 369.381462664277
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137336
[distance] => 145.716902717151
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135370
[asc_5] => 137333
[distance] => 226.678380044001
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
[important_3] => 1
[asc_3] => 536
[asc_4] => 135373
[asc_5] => 137328
[distance] => 107.234524784113
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137326
[distance] => 142.748563013426
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137309
[distance] => 217.274498150027
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137306
[distance] => 197.493051583772
)
[46] => Array
(
[id] => 497858364
[en] => Munich
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137305
[distance] => 322.238459557162
)
[47] => Array
(
[id] => 497884752
[en] => Munster
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137304
[distance] => 191.516036117951
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137296
[distance] => 199.220390095210
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137283
[distance] => 177.633539629127
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137279
[distance] => 199.442557214392
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137273
[distance] => 74.420113690803
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137270
[distance] => 290.581721233125
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137267
[distance] => 204.611532385530
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137259
[distance] => 128.345518024301
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137254
[distance] => 200.968404290428
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
[important_3] => 1
[asc_3] => 536
[asc_4] => 135380
[asc_5] => 137249
[distance] => 321.056696462125
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137241
[distance] => 265.494899817297
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137243
[distance] => 187.611388653919
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137240
[distance] => 165.506731576217
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137237
[distance] => 239.408955162684
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
[important_3] => 1
[asc_3] => 536
[asc_4] => 135376
[asc_5] => 137226
[distance] => 425.370726856783
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
[important_3] => 1
[asc_3] => 536
[asc_4] => 135372
[asc_5] => 137188
[distance] => 232.077552035840
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137195
[distance] => 174.030274808322
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137178
[distance] => 206.201918061359
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
[important_3] => 1
[asc_3] => 536
[asc_4] => 135383
[asc_5] => 137163
[distance] => 252.555882854158
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
[important_3] => 1
[asc_3] => 536
[asc_4] => 135377
[asc_5] => 137137
[distance] => 103.185721664361
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135375
[asc_5] => 137131
[distance] => 221.021113434135
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
[important_3] => 1
[asc_3] => 536
[asc_4] => 135374
[asc_5] => 137128
[distance] => 169.454791381723
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
[important_3] => 1
[asc_3] => 536
[asc_4] => 135382
[asc_5] => 137127
[distance] => 101.263499815992
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه