Incorrect key file for table './romaxus_new/productviewed.MYI'; try to repair it SQL query : SELECT count(*) from productviewed where productID=2981 and date="2012-05-23 00:00:00"