All pastes #738555 Raw Edit

Jemand

public sql v1 · immutable
·published 2007-10-16 13:31 UTC
rendered paste body
SELECT n.*, td.name FROM node AS n INNER JOIN term_node AS tn ON tn.nid = n.nid INNER JOINterm_data AS td ON tn.tid = td.tid WHERE n.status = 1 AND td.name = 'test';