SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (852) AND (
wp_term_relationships.term_taxonomy_id IN (40,91,48,49,51,52,53,86)
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID in (select pm.post_id from wp_postmeta pm where pm.meta_key ='post_city_id' and FIND_IN_SET( 4, pm.meta_value )) AND (wp_posts.ID in (923,454,915,347,1228,840,871,492,825,875,877,559,362,410,1634,891,902,936,512,415,459,1002,1048,1143,1236,929,431,471,1272,389,1000,1163,136,836,931,958,515,889,904,933,950,704,539,1008,1032,1200,1534,398,1150,1394,506,434,645,1224,1648,810,377,1370,1458,960,534,419,428,483,1062,1172,1193,1226,1525,1531,906,353,687,300,1029,1487,1562,794,798,800,802,813,819,830,856,860,862,938,940,659,1216,1285,653,672,1246,1676,503,494,1119,1261,858,308,1233,135,881,921,1669,518,548,1357,325,1083,1099,895,946,374,304,1014,1055,1643,873,528,489,467,1457,1469,1641,821,838,541,465,1122,1480,1529,546,360,319,1324,1425,1555,887,942,439,1219,134,553,1016,1038,1508,526,523,641,332,316,1338,648,321,1315,520,544,1630,294,292,1042,1010,1035,1046,1065,925,355,274,351,298,1108,948,666,1377,885,917,406,656,286,461,1050,1053,1071,1373,1568,1674,808,954,962,696,282,276,1018,893,530,412,683,278,323,1601,693,296,1078,1148,854,952,956,437,662,685,280,1086,897,919,944,1060,1541,124,126,133,842,550,1221,125,127,129,131,386,691,1076,1333,1624,130,562,425,680,676,669,288,1068,1388,1564,1251,1349,1131,1299,1489,1537,700,865,815,1169,473,806,913,310,330,383,306,338,1081,1096,1154,1296,1040,1355,1399,1413,1211,1437,1483,456,1044,964,408,336,1579,1616,792,702,1124,832,651,664,334,1186,1405,1463,1020,1103,1207,1553,883,910,486,302,804,823,908,556,341,394,328,1126,1204,899,367,128,469,312,1570,314,1146,1152,404,643,1074,1093,1477,132,343,380,1304,828,290,1347,1134,1473,817,371,358,463,1182,1270,1524,1558,844,349,345,402,869,1231,1486,1538,796,537,689,1253,1652,1166,422,1291,927,1116,1257,1518,1175,1263,879,1026,1267,1572,1265,1023,1248,1259,396,392,475,1241,532,480,400,497,501,1238,478,1255,1090,1141)) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 3
The core business of Yamaha Music (Asia) Private Limited is in the retail & wholesale of musical instruments and the operation of music schools. Read more…