SELECT tn.nid, count(*) as ct
FROM um_term_node tn
inner join um_node n on (n.nid = tn.nid)
inner join um_term_data td on (tn.tid = td.tid)
where td.vid = 5 and n.type = 'audio'
group by tn.nid
having ct > 1 order by ct desc