MySQL error!

Can't create/write to file '/tmp/#sql_4efc_10.MYI' (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 = 12 AND YEAR(post_issue_date)=1997 AND MONTH(post_issue_date)=06 AND ( post_status IN ('published') ) AND post_issue_date <= '2005-11-02 17:28:45' ORDER BY post_issue_date DESC