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 = '20'
GROUP BY
blog_article_category.category_id
) a
ON
a.category_id = c.category_id
WHERE
c.blog_id = '20' 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 = '20'
AND blog_article_category.category_id is null
GROUP BY
blog_article_category.category_id
ORDER BY sort_order;