error:Query execution was interrupted
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,
blog.blog_name,
blog.path_name,
(
select
concat(' ', group_concat(bc.category_id SEPARATOR ' '), ' ')
from
blog_category bc
where
bc.category_id in (
select category_id from blog_article_category bac where bac.article_id = blog_article.article_id
)
) category_ids,
(
select
concat(' ', group_concat(bc.name SEPARATOR ' '), ' ')
from
blog_category bc
where
bc.category_id in (
select category_id from blog_article_category bac where bac.article_id = blog_article.article_id
)
) category_names,
shop_admin_user.user_name,
sys_domain.domain
FROM
blog_article
JOIN blog ON blog.blog_id = blog_article.blog_id
JOIN sys_domain ON blog.shop_code = sys_domain.shop_code
LEFT JOIN
shop_admin_user
ON
shop_admin_user.user_id = blog_article.user_id
WHERE
blog_article.delete_status = 0
AND blog.shop_code = '3'
AND blog_article.posting_date <= '2024-11-22 04:59'
ORDER BY
blog_article.posting_date DESC
LIMIT 0, 10 ;