MySQL error!

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

Your query:
SELECT DISTINCT evo_comments.* FROM ((evo_comments INNER JOIN evo_posts ON comment_post_ID = ID) INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories othercats ON postcat_cat_ID = othercats.cat_ID WHERE othercats.cat_blog_ID = 9 AND comment_type IN ('comment') AND ( post_status IN ('published') ) ORDER BY comment_date DESC LIMIT 20