Incorrect key file for table '/var/lib/mysqltmp/#sql_1349_0.MYI'; try to repair it
SELECT D.*, C.avatar FROM SC_discussions D LEFT JOIN SC_customers C on D.customerID = C.Login WHERE productID=1039 ORDER BY DID DESC LIMIT 0, 2