Incorrect key file for table '/var/mysql/tmp/#sql_3c73_2.MYI'; try to repair it -- SELECT S.show_id, S.instance_id, S.playtime, S.artist, S.title, S.album, S.rlabel, DATE_FORMAT(S.playtime, '%l:%i %p') AS human_time, DATE_FORMAT(S.playtime, '%W') AS human_day, DATE_FORMAT(S.playtime, '%c/%e/%Y') AS human_date FROM songs S, show_instance I, schedule H, DJ D WHERE 1=1 AND S.instance_id=I.id AND I.show_id=H.id AND H.djid=D.DJID AND playtime >= '2006-03-25 00:00:00' AND playtime <= '2014-09-18 00:00:00' AND S.title != ':::SETBREAK:::' ORDER BY S.playtime DESC LIMIT 30 OFFSET 300870