Query { SELECT t.*, lc.category_name AS category_name, GREATEST( IFNULL((SELECT max(c.date_added) FROM `flyspray_comments` c LEFT JOIN flyspray_comment_status_relation csr ON c.comment_id = csr.comment_id LEFT JOIN flyspray_comment_status cs ON csr.comment_status_id = cs.comment_status_id WHERE c.task_id = t.task_id AND cs.comment_status_intern = 0), 0), t.date_opened, t.date_closed, t.last_edited_time) AS max_date, p.project_title, p.project_is_active, lst.status_name AS status_name, lt.tasktype_name AS task_type, lr.resolution_name FROM `flyspray_tasks` t LEFT JOIN `flyspray_projects` p ON t.project_id = p.project_id LEFT JOIN `flyspray_list_tasktype` lt ON t.task_type = lt.tasktype_id LEFT JOIN `flyspray_list_status` lst ON t.item_status = lst.status_id LEFT JOIN `flyspray_list_resolution` lr ON t.resolution_reason = lr.resolution_id LEFT JOIN `flyspray_list_category` lc ON t.product_category = lc.category_id LEFT JOIN `flyspray_assigned` ass ON t.task_id = ass.task_id LEFT JOIN `flyspray_users` u ON ass.user_id = u.user_id LEFT JOIN `flyspray_notifications` fsn ON t.task_id = fsn.task_id WHERE fsn.user_id = ? AND t.mark_private = 0 AND p.project_is_active = 1 GROUP BY t.task_id ORDER BY max_date desc, t.task_id desc, t.task_id DESC} with params {16} Failed! (Out of resources when opening file '/tmp/#sql_262_64.MYI' (Errcode: 24))