Fruits and Flowers

product_num: 4

category: 2

(1) SELECT city_code, city, area_code FROM cities WHERE active=1 AND country_code='9' AND sort_city < 9 AND city_code IN (278,279,280,290,293,303,305,306,307,308,309,330,331,332,473,660,2587,70,289,796,797,936,938,937,1202,1203,1204,1205,1206,1207,2038,2553,636,2060,320,2573,2547,2548,2549,2572,2574,587,857,856,855,854,858,859,860,861,862,901,751,815,816,817,818,819,820,821,822,823,679,588,1169,1170,1171,1172,1173,321,419,217,399,400,2092,659,294,295,296,297,298,299,300,310,311,1234,453,454,1084,1212,1237,1469,1940,2990,2989,2991,2988,2985,2986,2987,2984,398,403,1480,814,764,412,904,952,951,3006,3007,3008,895,420,650,653,1005,2095,2961,2962,76,2568,2566,2710,285,281,286,282,220,754,827,828,830,831,1006,2007,2048,2068,900,902,746,758,957,958,316,317,925,924,923,360,361,362,363,640,641,642,643,1165,1166,2067,647,826,586,283,2569,2570,2571,2567,2565,803,646,802,804,609,2943,768,808,2575,322,3028,405,407,2552,649,648,644,662,661,304,637,319,3058,3054,3059,3055,3053,3057,3056,753,755,762,749,2897,291,406,3076,759,3021,3020,752,965,929,2032,966,2033,963,930,287,3084,3085,3086,3087,3088,3089,318,323,324,1153,1154,277,409,408,896,680,2044,1250,2973,899,2974,897,1478,954,2975,2976,898,275,276,327,2928,1080,325,2923,1157,326,1155,2918,2046,1156,2917,566,656,654,775,777,655,791,792,794,760,3093,3094,3095,3096,3097,3098,3105,218) ORDER BY sort_city, city
(2) SELECT city_code, city, area_code FROM cities WHERE active=1 AND country_code='9' AND city_code IN (278,279,280,290,293,303,305,306,307,308,309,330,331,332,473,660,2587,70,289,796,797,936,938,937,1202,1203,1204,1205,1206,1207,2038,2553,636,2060,320,2573,2547,2548,2549,2572,2574,587,857,856,855,854,858,859,860,861,862,901,751,815,816,817,818,819,820,821,822,823,679,588,1169,1170,1171,1172,1173,321,419,217,399,400,2092,659,294,295,296,297,298,299,300,310,311,1234,453,454,1084,1212,1237,1469,1940,2990,2989,2991,2988,2985,2986,2987,2984,398,403,1480,814,764,412,904,952,951,3006,3007,3008,895,420,650,653,1005,2095,2961,2962,76,2568,2566,2710,285,281,286,282,220,754,827,828,830,831,1006,2007,2048,2068,900,902,746,758,957,958,316,317,925,924,923,360,361,362,363,640,641,642,643,1165,1166,2067,647,826,586,283,2569,2570,2571,2567,2565,803,646,802,804,609,2943,768,808,2575,322,3028,405,407,2552,649,648,644,662,661,304,637,319,3058,3054,3059,3055,3053,3057,3056,753,755,762,749,2897,291,406,3076,759,3021,3020,752,965,929,2032,966,2033,963,930,287,3084,3085,3086,3087,3088,3089,318,323,324,1153,1154,277,409,408,896,680,2044,1250,2973,899,2974,897,1478,954,2975,2976,898,275,276,327,2928,1080,325,2923,1157,326,1155,2918,2046,1156,2917,566,656,654,775,777,655,791,792,794,760,3093,3094,3095,3096,3097,3098,3105,218) ORDER BY city