MySQLi Error: Incorrect key file for table '/tmp/#sql_443_0.MYI'; try to repair it , SELECT m.*, u.id as u_id , u.account as u_account , u.auth_token as u_auth_token , u.auth_type as u_auth_type , u.role as u_role , u.confirmed as u_confirmed , u.email as u_email , u.first_name as u_first_name , u.last_name as u_last_name , u.nick as u_nick , u.intro as u_intro , u.country as u_country , u.address as u_address , u.image as u_image , u.gender as u_gender , u.birthday as u_birthday , u.phone as u_phone , u.cellphone as u_cellphone , u.created_on as u_created_on , u.updated_on as u_updated_on , u.lang as u_lang , u.score as u_score , u.invitation as u_invitation , u.subscribe as u_subscribe , c.id as c_id , c.name as c_name , c.lang as c_lang , c.ordernum as c_ordernum , c.description as c_description FROM stories m LEFT JOIN users u ON (m.created_by = u.id) LEFT JOIN category c ON (m.category = c.id) WHERE m.pending = false and m.abused = false and m.deleted_by is null ORDER BY RAND() LIMIT 10