error:Query execution was interrupted
sql:SELECT c.name, c.category_id, a.acnt, c.sort_order FROM blog_category c LEFT JOIN ( SELECT blog_article_category.category_id, count(blog_article_category.article_id) as acnt FROM blog_article LEFT JOIN blog_article_category ON blog_article_category.article_id = blog_article.article_id WHERE blog_article.delete_status = 0 AND blog_article.status = 1 AND blog_article.blog_id = '18' GROUP BY blog_article_category.category_id ) a ON a.category_id = c.category_id WHERE c.blog_id = '18' AND c.delete_status = 0 AND c.status = 1 UNION SELECT '未設定' as NAME, 0 as category_id, count(blog_article.article_id) as acnt, 0 as sort_order FROM blog_article LEFT JOIN blog_article_category ON blog_article_category.article_id = blog_article.article_id WHERE blog_article.delete_status = 0 AND blog_article.status = 1 AND blog_article.blog_id = '18' AND blog_article_category.category_id is null GROUP BY blog_article_category.category_id ORDER BY sort_order;