MySQL error!

Can't create/write to file '/tmp/#sql_4efc_4.MYD' (Errcode: 9)(Errno=1)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 9 AND YEAR(post_issue_date)=2005 AND MONTH(post_issue_date)=09 AND DAYOFMONTH(post_issue_date)=07 AND ( post_status IN ('published') ) AND post_issue_date <= '2005-11-04 15:42:13' ORDER BY post_issue_date DESC