select * from Mls where RecycleBin=0 and Active=1 and (EnItem like '%town house meadows park%' or ArItem like '%town house meadows park%') group by CompanyCode ORDER BY Google DESC,UpdateStamp DESC
Table 'Mls' is marked as crashed and should be repaired