<?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;
?>
<?php
$output = '';
$result = db_query('select r.pnid, pn.title, pn.teaser, r.nid, nn.title, count(*) zenbat FROM node_relations r
LEFT JOIN node nn ON r.nid = nn.nid
LEFT JOIN node pn ON r.pnid = pn.nid
WHERE r.type = "Adiera" GROUP BY pn.nid HAVING zenbat = 1');
while($row = db_fetch_array($result)){
$output .= '<p>'.$row['teaser'].'</p>';
}
print $output;
?>
<?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;
?>
