SELECT b.* FROM t_listings AS b  WHERE b.iStatus = 1 and b.iPublish = 1 AND b.iIsCheck=2 AND b.apponly!=2 AND iCityID = '5' AND FIND_IN_SET('1361', b.sCategoryQuery) AND FIND_IN_SET('142', b.sRegionID) AND FIND_IN_SET('Thai', b.sKeyword)  ORDER BY b.is_closed ASC, b.iSortBy DESC,b.iUpdateTime DESC  LIMIT 0,8