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 '%Allume%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Allume %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Systems%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Systems %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%Inc.%' Or CONCAT(' ',soft_archives.keywords,' ') like '%Inc. %') And (CONCAT(soft_archives.title,' ',soft_archives.description,' ',soft_archives.writer,' ',soft_archives.source) like '%formerly%' Or CONCAT(' ',soft_archives.keywords,' ') like '%formerly %') ) limit 0,1;