SELECT distinct a.article_id as article_id, a.article_year as article_year, a.article_item as article_item,
a.article_pdf as article_pdf, a.article_pages as article_pages,
a.article_title as article_title, a.article_abstract as article_abstract
FROM articles a, authors_to_article b
WHERE b.author_id='677' and a.article_id=b.article_id and a.article_print='Y'
ORDER BY article_year DESC, article_item DESC, CAST(SUBSTRING_INDEX(article_pages, '-', 1) AS signed)Can't create/write to file '/var/tmp/#sql_6b8_0.MAI' (Errcode: 28 "No space left on device")