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 (800) 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 (1233,353,881,1099,1357,873,1285,1457,1469,1261,1224,134,794,798,813,819,830,856,860,862,931,938,940,1122,389,316,1531,377,439,1062,1272,1676,891,902,534,415,1425,1508,915,936,347,1042,1534,136,515,454,946,704,300,332,1010,1216,852,559,355,1035,1046,1634,548,494,687,294,467,1083,1487,1641,871,923,489,1055,810,906,506,374,1014,1228,492,1480,840,875,877,942,483,274,1163,825,838,362,410,398,431,648,459,471,465,304,1008,1315,1324,836,921,933,512,528,526,523,360,1002,1016,1038,1048,1143,1150,1236,1643,124,126,133,842,889,929,950,553,323,1018,641,666,292,1065,1219,1377,1394,1630,858,885,887,917,520,278,276,1000,1338,808,904,958,539,693,656,683,1221,1373,1674,662,685,280,1200,434,645,1032,1370,1458,1529,1648,659,1489,653,680,676,672,669,691,1076,948,319,1071,419,428,282,1050,1172,1193,1226,1525,1537,1541,960,412,296,1029,1053,1299,1562,802,865,962,696,135,954,437,1078,893,944,1060,1119,1148,1246,1601,1669,925,952,956,503,518,550,1086,854,919,308,1624,125,127,129,131,897,562,386,1081,1333,1388,130,288,1131,895,425,325,700,1349,806,821,541,473,330,1169,1568,913,1555,546,338,383,1096,306,1211,815,321,1154,1296,1040,544,1355,1399,1413,1437,702,351,408,298,286,1108,1483,964,406,461,530,1124,336,792,832,1186,883,910,486,664,302,1020,1103,1207,1405,1463,1553,1564,804,908,341,394,334,328,1251,1068,1126,1204,899,367,128,469,314,312,823,556,651,643,1074,1093,1477,132,343,380,404,1304,310,371,1570,817,290,1146,1152,1270,1182,1473,828,1538,1558,456,1044,1347,796,349,1134,358,869,345,1231,844,402,689,463,1524,537,1166,1486,1579,1616,1652,422,1253,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
Singapore
