SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((related_pro_cat = 196 OR FIND_IN_SET('196',related_pro_cat))) AND article_id !=1123 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 = 199 OR FIND_IN_SET('199',related_pro_cat))) AND article_id !=1122 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 = 196 OR FIND_IN_SET('196',related_pro_cat))) AND article_id !=1121 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 = 196 OR FIND_IN_SET('196',related_pro_cat))) AND article_id !=1125 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 = 205 OR FIND_IN_SET('205',related_pro_cat))) AND article_id !=1127 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8