SELECT n.*, td.name FROM node AS n INNER JOIN term_node AS tn ON tn.nid = n.nid INNER JOIN
term_data AS td ON tn.tid = td.tid WHERE n.status = 1 AND td.name = 'test';