link types of duplicate links

link_types_of_duplicate_links.sql

select link_group_id, link_type_description, count(*)
from calaccess_processed_candidate_committees a
join (
    select cand_filer_id, committee_filer_id, count(*)
    from calaccess_processed_candidate_committees
    group by 1, 2
    having count(*) > 1
) as dupes
on a.cand_filer_id = dupes.cand_filer_id
and a.committee_filer_id = dupes.committee_filer_id
group by 1, 2
order by count(*) desc;