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 '%CertGear%' Or CONCAT(' ',soft_archives.keywords,' ') like '%CertGear %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%SCJP%' Or CONCAT(' ',soft_archives.keywords,' ') like '%SCJP %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Certification%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Certification %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%CX%' Or CONCAT(' ',soft_archives.keywords,' ') like '%CX %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%310%' Or CONCAT(' ',soft_archives.keywords,' ') like '%310 %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%035%' Or CONCAT(' ',soft_archives.keywords,' ') like '%035 %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Practice%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Practice %') ) limit 0,1;