Something

SELECT * FROM node n INNER JOIN term_node tn ON tn.nid = n.nid AND tn.vid=1WHERE tn.tid <> 1;