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 = '7' AND FIND_IN_SET('1065', b.sCategoryQuery) AND FIND_IN_SET('185', b.sRegionID) AND FIND_IN_SET('Hilton', b.sKeyword)  ORDER BY b.is_closed ASC, b.iSortBy DESC,b.iUpdateTime DESC  LIMIT 0,8