select substring_index(subject_set,',',1) subject_id1, count(id) cnt
from comment_detail
where substring_index(substring_index(subject_set,',',2),',',-1) = 1002
group by subject_id1
order by subject_id1