0 AND n.nid=nc.nid
INNER JOIN (SELECT max(c.cid) as cid ,c.nid,count(c.cid) as cnt FROM {comments} c GROUP by c.nid ) cm
ON cm.nid=n.nid
INNER JOIN {comments} cc ON cc.cid=cm.cid
INNER JOIN {users} u ON u.uid=cc.uid
ORDER BY nc.last_comment_timestamp DESC"),0,$number);
$items=array();
while($comment=db_fetch_object($result)){
$tte='';
if(strlen(strip_tags($comment->comment))>$commentlenght) { $tte=$endcomment; };
$items[] = ''. l($comment->title, 'node/'.
$comment->nid, array('fragment' => 'comment-'. $comment->cid)).' ('.$comment->cnt.')' .'
'.strip_tags(drupal_substr($comment->comment, 0, $commentlenght)).$tte.'
'.format_date($comment->timestamp, 'small').'
от: '.theme('username',user_load($comment->uid)). '';
}
if(count($items)){
print theme('item_list',$items);
}
?>