Drupal Audio Nodes with Multiple
public text v1 · immutableSELECT tn.nid, td.vid, 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, td.vid
having ct > 1 order by ct desc