Fetching latest node for particular vocabulary Single node per term

    SELECT nid
    FROM node n
    INNER JOIN (
    SELECT max( tn.nid ) AS nids
    FROM term_node tn
    INNER JOIN term_data td
    WHERE td.tid = tn.tid
    AND td.vid =1
    GROUP BY tn.tid
    ) t ON n.nid = t.nids
    ORDER BY n.created
    5
    Average: 5 (1 vote)