SELECT COUNT(article_id) as count_total FROM article_ms WHERE 1=1 AND article_pub_date <= '2024-04-23 00:00:00' AND article_status = 3 AND ( article_slug LIKE '%candle%' OR article_topics LIKE '%candle%' OR article_title LIKE '%candle%' OR article_summary LIKE '%candle%' OR article_prods LIKE '%candle%' ) AND FIND_IN_SET('180', article_country_type) AND article_language_type = '1'