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