SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE (FIND_IN_SET('158',related_pro_cat) AND FIND_IN_SET('47',related_pro_cat) OR related_pro_cat IN(158,47)) AND article_id !=365 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((related_pro_cat = 158 OR FIND_IN_SET('158',related_pro_cat))) AND article_id !=288 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((CONCAT(",", related_pro_cat, ",") REGEXP ",(161),")) AND article_id !=652 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((CONCAT(",", related_pro_cat, ",") REGEXP ",(161),")) AND article_id !=296 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((CONCAT(",", related_pro_cat, ",") REGEXP ",(161),")) AND article_id !=292 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
