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'
				

8 results found