mysql 多列统计出现次数

• 实际开发中遇到

select count(*) from (select distinct planid,unitid,ideaid,imageid from atsimage0) as tb1;

• GROUP_CONCAT: 多列合并函数

USE FD_Chuangyi;
SELECT tb2.ideaid,tb2.content,tb2.total,tb3.rsn, tb3.userid FROM 
(SELECT tb1.ideaid AS ideaid,tb1.content AS content, COUNT(*)  AS total FROM 
(SELECT ideafeedback.userid, ideafeedback.ideaid, ideacase.content, ideafeedback.rsn FROM ideafeedback, ideacase WHERE ideafeedback.`ideaid` = ideacase.`ideaid`) AS tb1
GROUP BY tb1.ideaid) AS tb2,(SELECT ideaid, GROUP_CONCAT(rsn) AS rsn, GROUP_CONCAT(userid)  AS userid FROM ideafeedback GROUP BY ideaid) AS tb3
WHERE tb2.ideaid = tb3.ideaid;