Hello, I'm trying to display some stats from my blog engine. I want
the number of posts per author, so I tried :
->select('a.name, COUNT(c.id) as num_billets')
->from('Content c')
->leftJoin('c.Author a')
->where('c.state_id = ?', 3)
->groupBy('a.name')
->execute();
But this gives me the error "The root class of the query (alias c)
must have at least one field selected."
Any ideas ?
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
