If you run this query
如果运行此查询
select GROUP_CONCAT(p1.id) _fid, GROUP_CONCAT(p2.id) _mid, count(1)from new_person as pb inner join new_person as p1 ON pb.father_id = p1.id inner join new_person as p2 ON pb.mother_id = p2.idwhere (p1.last_name <> 'N.N.' and p1.last_name <> '') or (p2.last_name <> 'N.N.' and p2.last_name <> '')group by p1.first_name , p1.last_name , p2.first_name , p2.last_namehaving count(1) > 1;select GR
