Ací el block:
$result = db_query_range('SELECT node.nid, node_revisions.nid, node_revisions.uid, node_revisions.title,LEFT(node_revisions.teaser,126) as camp_tallat,users.uid, users.name,users.picture from (node LEFT JOIN node_revisions ON node.nid=node_revisions.nid) LEFT JOIN users ON users.uid=node.uid WHERE node.type=\'forum\' order by node.nid desc', 0,10);
?>