Re: GROUP_CONCAT and COUNT

[Peter Brawley]

select group_concat(person) as people, N
from (
  select p.person, count(distinct pf.id_films) as N
  from t_people p 
  join st_peoplefilms pf using(id_person) 
  where p.sex=1 
  group by p.person
) sums;