<?php
$output = '';
$result = db_query('SELECT r.pnid, pnr.teaser, pn.title, r.nid, nn.title FROM node_relations r
LEFT JOIN node nn ON r.nid = nn.nid
LEFT JOIN node_revisions pnr ON nn.nid = pnr.nid
LEFT JOIN node pn ON r.pnid = pn.nid
LEFT JOIN term_node tn ON pn.nid = tn.nid
WHERE r.type = "Esamolde" AND tn.tid = 7');
while($row = db_fetch_array($result)){
$output .= '<p>'.$row['teaser'].'</p>';
}
print $output;
?>
