resale chalet mountain view sokhna

====== select * from Mls where EnItem like '%resale chalet mountain view sokhna%' group by CompanyCode ORDER BY UpdateStamp DESC =============

====== select *, MATCH (EnItem) AGAINST ('resale chalet mountain view sokhna' IN BOOLEAN MODE) AS Relevance from Mls where MATCH (EnItem) AGAINST ('resale chalet mountain view sokhna' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 0,20 =============