SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((CONCAT(",", related_pro_cat, ",") REGEXP ",(162),")) AND article_id !=293 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 ",(162),")) AND article_id !=295 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 ",(162),")) AND article_id !=294 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 = 47 OR FIND_IN_SET('47',related_pro_cat))) AND article_id !=257 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 ((find_in_set('49', cast(related_pro_cat as char)) > 0 OR find_in_set('158', cast(related_pro_cat as char)) > 0)) AND article_id !=262 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
