SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE (FIND_IN_SET('12',related_pro_cat) AND FIND_IN_SET('34',related_pro_cat) AND FIND_IN_SET('110',related_pro_cat) OR related_pro_cat IN(12,34,110)) AND article_id !=1578 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
