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 '%Exl%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Exl %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Plan%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Plan %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Micro%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Micro %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%US%' Or CONCAT(' ',soft_archives.keywords,' ') like '%US %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%edition%' Or CONCAT(' ',soft_archives.keywords,' ') like '%edition %') ) limit 0,1;