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