Array
(
[0] => Array
(
[id] => 158295
[en] => Anshan
)
[1] => Array
(
[id] => 154552
[en] => Anyang
)
[2] => Array
(
[id] => 156352
[en] => Baoding
)
[3] => Array
(
[id] => 157680
[en] => Baotou
)
[4] => Array
(
[id] => 156984
[en] => Beijing
)
[5] => Array
(
[id] => 158462
[en] => Benxi
)
[6] => Array
(
[id] => 164586
[en] => Changchun
)
[7] => Array
(
[id] => 188456
[en] => Changsha
)
[8] => Array
(
[id] => 189137
[en] => Changzhou
)
[9] => Array
(
[id] => 188847
[en] => Chengdu
)
[10] => Array
(
[id] => 188678
[en] => Chongqing
)
[11] => Array
(
[id] => 156379
[en] => Dalian
)
[12] => Array
(
[id] => 157107
[en] => Datong
)
[13] => Array
(
[id] => 187441
[en] => Foshan
)
[14] => Array
(
[id] => 159489
[en] => Fushun
)
[15] => Array
(
[id] => 188071
[en] => Fuzhou
)
[16] => Array
(
[id] => 187465
[en] => Guangzhou
)
[17] => Array
(
[id] => 188166
[en] => Guiyang
)
[18] => Array
(
[id] => 154904
[en] => Handan
)
[19] => Array
(
[id] => 188766
[en] => Hangzhou
)
[20] => Array
(
[id] => 165854
[en] => Harbin
)
[21] => Array
(
[id] => 189179
[en] => Hefei
)
[22] => Array
(
[id] => 143963
[en] => Hegang
)
[23] => Array
(
[id] => 188224
[en] => Hengyang
)
[24] => Array
(
[id] => 157948
[en] => Hohhot
)
[25] => Array
(
[id] => 498083467
[en] => Hong Kong
)
[26] => Array
(
[id] => 190223
[en] => Huaibei
)
[27] => Array
(
[id] => 189741
[en] => Huainan
)
[28] => Array
(
[id] => 164567
[en] => Jilin
)
[29] => Array
(
[id] => 154966
[en] => Jinan
)
[30] => Array
(
[id] => 187237
[en] => Jiulong
)
[31] => Array
(
[id] => 187837
[en] => Kunming
)
[32] => Array
(
[id] => 156702
[en] => Langfang
)
[33] => Array
(
[id] => 154525
[en] => Lanzhou
)
[34] => Array
(
[id] => 158427
[en] => Liaoyang
)
[35] => Array
(
[id] => 187673
[en] => Liuzhou
)
[36] => Array
(
[id] => 190530
[en] => Luoyang
)
[37] => Array
(
[id] => 188515
[en] => Nanchang
)
[38] => Array
(
[id] => 189323
[en] => Nanjing
)
[39] => Array
(
[id] => 187379
[en] => Nanning
)
[40] => Array
(
[id] => 188721
[en] => Ningbo
)
[41] => Array
(
[id] => 190146
[en] => Pingdingshan
)
[42] => Array
(
[id] => 154238
[en] => Puyang
)
[43] => Array
(
[id] => 154542
[en] => Qingdao
)
[44] => Array
(
[id] => 156985
[en] => Qinhuangdao
)
[45] => Array
(
[id] => 143864
[en] => Qiqihar
)
[46] => Array
(
[id] => 187541
[en] => Rongcheng
)
[47] => Array
(
[id] => 188947
[en] => Shanghai
)
[48] => Array
(
[id] => 187511
[en] => Shantou
)
[49] => Array
(
[id] => 159390
[en] => Shenyang
)
[50] => Array
(
[id] => 187292
[en] => Shenzhen
)
[51] => Array
(
[id] => 155853
[en] => Shijiazhuang
)
[52] => Array
(
[id] => 188970
[en] => Suzhou
)
[53] => Array
(
[id] => 154629
[en] => Taian
)
[54] => Array
(
[id] => 155670
[en] => Taiyuan
)
[55] => Array
(
[id] => 156769
[en] => Tangshan
)
[56] => Array
(
[id] => 156478
[en] => Tianjin
)
[57] => Array
(
[id] => 164492
[en] => Urumqi
)
[58] => Array
(
[id] => 188440
[en] => Wenzhou
)
[59] => Array
(
[id] => 188832
[en] => Wuhan
)
[60] => Array
(
[id] => 189058
[en] => Wuxi
)
[61] => Array
(
[id] => 190344
[en] => Xian
)
[62] => Array
(
[id] => 187222
[en] => Xianggangdao
)
[63] => Array
(
[id] => 190389
[en] => Xianyang
)
[64] => Array
(
[id] => 154925
[en] => Xining
)
[65] => Array
(
[id] => 153988
[en] => Xinxiang
)
[66] => Array
(
[id] => 189388
[en] => Xinyang
)
[67] => Array
(
[id] => 190345
[en] => Xuzhou
)
[68] => Array
(
[id] => 155466
[en] => Yantai
)
[69] => Array
(
[id] => 157959
[en] => Zhangjiakou
)
[70] => Array
(
[id] => 190574
[en] => Zhengzhou
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=498101836 and other_city_id in (158295,154552,156352,157680,156984,158462,164586,188456,189137,188847,188678,156379,157107,187441,159489,188071,187465,188166,154904,188766,165854,189179,143963,188224,157948,498083467,190223,189741,164567,154966,187237,187837,156702,154525,158427,187673,190530,188515,189323,187379,188721,190146,154238,154542,156985,143864,187541,188947,187511,159390,187292,155853,188970,154629,155670,156769,156478,164492,188440,188832,189058,190344,187222,190389,154925,153988,189388,190345,155466,157959,190574)Array
(
[0] => Array
(
[id] => 187441
[distance] => 33.68
)
)