In conjunction of national holidays, the last pickup will be on September 13. Orders placed after this date will be processed on September 18. Thank you for choosing Onecare!
SELECT COUNT(article_id) as count_total FROM article_ms WHERE 1=1 AND article_pub_date <= '2024-09-17 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'