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