[PHP] pobierz, plaintext 
<?php
$c->addSelectColumn(CommentPeer::COUNT);
		$c->addGroupByColumn(ArticlePeer::ID );
		$c->addAlias("nb_comments",CommentPeer::COUNT );
		$res = self::doSelectJoinAll($c, $con);
?>
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT COUNT(comments.ID), articles.ID, articles.CATEGORY_ID, articles.TITLE, articles.BODY, categories.ID, categories.NAME FROM comments, articles, categories WHERE articles.CATEGORY_ID=categories.ID GROUP BY articles.ID ORDER BY articles.ID ASC LIMIT 5
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
$c->addAsColumn('nb_comments', 'Count(' . ArticlePeer::ID . ')'); 
 
?>
[PHP] pobierz, plaintext