1 - Can't create/write to file '/var/tmp/#sql_1794_0.MAI' (Errcode: 28 "No space left on device")
select p.movies_image, pd.movies_name, movies_date_added, pd.movies_description, p.movies_date_available, TO_DAYS(p.movies_date_added) as movies_date_added, p.media_id, p.studios_id, p.movies_price, p.movies_tax_class_id, IF(s.status, s.specials_new_movies_price, NULL) as specials_new_movies_price, IF(s.status, s.specials_new_movies_price, p.movies_price) as final_price from movies_description pd, movies_tokens p left join studios m on p.studios_id = m.studios_id left join specials_tokens s on p.media_id = s.media_id, movies_to_categories p2c where p.studios_id != 3 and p.movies_status = '1' and p.media_id = p2c.media_id and pd.media_id = p2c.media_id and pd.language_id = '1' and ((p.movies_date_available = '0000-00-00 00:00:00') or (p.movies_date_available = 'NULL') or (TO_DAYS(p.movies_date_available) <= TO_DAYS(now()))) and p2c.categories_id = '12' order by p.movies_date_added desc limit 16, 16
