nathelper
By janakj
Created 2006-03-09 23:46
SELECT DISTINCT(n.nid), n.title FROM {node} n INNER JOIN {term_node} tn0 ON n.nid = tn0.nid INNER JOIN {term_data} td0 ON tn0.tid = td0.tid INNER JOIN {vocabulary} v on (td0.vid = v.vid) WHERE v.name='SERi [1]' AND td0.name='parameter'
Links:
[1] http://www.iptel.org/glossary/term/244