short rental apartments for rent

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