Out of resources when opening file '/tmp/#sql_639_101.MYD' (Errcode: 24)

SELECT SQL_CALC_FOUND_ROWS videos.*, video_categories.category_id as cat_id, IF(`titles_for_domains`.`title` != '',`titles_for_domains`.`title`, `videos`.`title_he1`) as domain_title
FROM videos INNER JOIN video_categories
ON (video_categories.video_id = videos.video_id AND video_categories.`domain_id`=
(SELECT `domain_id` FROM `domains` WHERE `domains`.`domain_name`='sexmovie.co.il')) LEFT JOIN `titles_for_domains`
ON(`videos`.`video_id` = `titles_for_domains`.`video_id` AND `titles_for_domains`.`domain_id`=
(SELECT `domain_id` FROM `domains` WHERE `domains`.`domain_name`='sexmovie.co.il')) WHERE videos.active = '1' AND videos.verified = '1' AND video_categories.category_id = '61' AND video_categories.`domain_id` = '1' AND videos.title_he1 != '' AND videos.video != '' GROUP BY video_categories.video_id ORDER BY `order` LIMIT 0, 128