1 Can't create/write to file '/tmp/#sql_be8_0.MYI' (Errcode: 28)
in:
[select distinct n.article_id, nt.news_article_name, nt.news_article_text, nt.news_article_shorttext, n.news_image, nt.news_image_text, n.news_date_published from news_articles n left join news_articles_text nt on n.article_id = nt.article_id and nt.language_id = '1' where n.news_status = '1' and n.news_date_published = '2011-09-16 00:00:00' order by n.sort_order]