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