Table '.\qeasoft5_cs\soft_archives' is marked as crashed and should be repaired - Execute Query False! Select count(*) as dd From soft_archives where arcrank > -1 And ( (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%AVI%' Or CONCAT(' ',soft_archives.keywords,' ') like '%AVI %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%WMV%' Or CONCAT(' ',soft_archives.keywords,' ') like '%WMV %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%MPEG%' Or CONCAT(' ',soft_archives.keywords,' ') like '%MPEG %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%MOVSWF%' Or CONCAT(' ',soft_archives.keywords,' ') like '%MOVSWF %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%FLV%' Or CONCAT(' ',soft_archives.keywords,' ') like '%FLV %') ) limit 0,1;