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 = '1' AND FIND_IN_SET('1142', b.sCategoryQuery) AND FIND_IN_SET('28', b.sRegionID) AND FIND_IN_SET('The Place', b.sKeyword) ORDER BY b.is_closed ASC, b.iSortBy DESC,b.iUpdateTime DESC LIMIT 0,8