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