Stuff

SELECT  DISTINCT ntn.nidFROM  noat_term_node ntn INNER JOIN (    SELECT      nid    FROM      noat_term_node    WHERE      tid = 25  ) sub ON sub.nid = ntn.nid INNER JOIN (    SELECT      nid    FROM      noat_term_node    WHERE      tid = 7  ) sub2 ON sub2.nid = ntn.nid;