SELECT COUNT(article_id) as count_total FROM article_ms
WHERE 1=1
AND article_pub_date <= '2024-09-08 00:00:00'
AND article_status = 3
AND (
article_slug LIKE '%heroplus%' OR
article_topics LIKE '%heroplus%' OR
article_title LIKE '%heroplus%' OR
article_summary LIKE '%heroplus%' OR
article_prods LIKE '%heroplus%'
)
AND FIND_IN_SET('180', article_country_type)
AND article_language_type = '1'
Join OnecareFamily Loyalty Programme And Get Pampered
Love getting free gifts, beauty, and health tips? If you say YES, look no further! We are beyond excited to introduce OnecareFamily - an exclusive loyalty programme that will pamper YOU with amazing rewards and an inspiring glow-up journey unlike any others.