| private getUserPointsSelect ( ) : string | ||
| return | string | |
private function getUserPointsSelect()
{
$commentsCount = "(SELECT COUNT(c)";
$commentsCount .= " FROM Newscoop\\Entity\\Comment c, Newscoop\\Entity\\Comment\\Commenter cc";
$commentsCount .= " WHERE c.commenter = cc AND cc.user = u AND c.status = 0) as comments";
return "{$commentsCount}";
}