error:Out of resources when opening file '/tmp/#sql_11e7_81.MYD' (Errcode: 24 - Too many open files)
sql:SELECT blog_article.article_id, blog_article.blog_id, blog_article.user_id, blog_article.title, blog_article.body, blog_article.comment_type, blog_article.ping_default_send, blog_article.ping_original_send, blog_article.status, blog_article.delete_status, blog_article.posting_date, blog_article.ins_date, blog_article.upd_date, blog_article.disp_on_product, blog_article.twitter_pub, concat(' ', group_concat(blog_category.category_id separator ' '), ' ') category_ids, concat(' ', group_concat(blog_category.name separator ' '), ' ') category_names, shop_admin_user.user_name FROM blog_article LEFT OUTER JOIN blog_article_category ON blog_article_category.article_id = blog_article.article_id LEFT OUTER JOIN blog_category ON blog_category.category_id = blog_article_category.category_id LEFT OUTER JOIN shop_admin_user ON shop_admin_user.user_id = blog_article.user_id WHERE blog_article.delete_status = 0 AND blog_article.status = 1 AND blog_article.blog_id = '39' AND date_format(blog_article.posting_date,'%Y-%m-%d-%H-%i') <= '2018-10-19-07-41' GROUP BY blog_article.blog_id, blog_article.user_id, blog_article.title, -- blog_article.body, blog_article.comment_type, blog_article.ping_default_send, blog_article.ping_original_send, blog_article.status, blog_article.delete_status, blog_article.posting_date, blog_article.ins_date, blog_article.upd_date, blog_article.disp_on_product, blog_article.twitter_pub, shop_admin_user.user_name ORDER BY blog_article.posting_date DESC LIMIT 0, 5 ;