统计重复的手机号吗
select * from (select count(mobile) as c, mobile from member where length(mobile) >= 11 group by mobile) as m where m.c > 1;
SELECT * FROM Picture p WHERE p.audit = true AND p.share = true AND p.image is not null AND audio is not null GROUP BY IFNULL(p.pictureGroup.id,p.session)
SELECT * FROM Picture p WHERE p.audit = true AND p.share = true AND p.id <= :id GROUP BY IFNULL(p.pictureGroup.id,p.session)
