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,
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 = '42'
AND date_format(blog_article.posting_date,'%Y-%m-%d-%H-%i') <= '2024-11-27-04-59'
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 ;