Adiera bakarreko sarrerak

<?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;

?>