<?php
$output = '';
$result = db_query('SELECT r.pnid, pn.title, pn.teaser, nnd.name, nnd.vid, r.nid, nn.title, pnd.name, pnd.vid FROM node_relations r
LEFT JOIN node nn ON r.nid = nn.nid
LEFT JOIN node pn ON r.pnid = pn.nid
LEFT JOIN term_node nnt ON nn.nid = nnt.nid
LEFT JOIN term_data nnd ON nnt.tid = nnd.tid AND nnd.vid = 1
LEFT JOIN term_node pnt ON pn.nid = pnt.nid
LEFT JOIN term_data pnd ON pnt.tid = pnd.tid AND pnd.vid = 1
WHERE r.type = "Sinonimo" AND ISNULL(nnt.tid) = 0 AND ISNULL(pnt.tid) = 0 AND nnd.vid = 1 AND pnd.vid = 1 AND nnt.tid != pnt.tid');
while($row = db_fetch_array($result)){
$output .= '<p>'.$row['teaser'].'</p>';
}
print $output;
?>
