Guest User

Untitled

a guest
Jun 18th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. $qb = $this->createQueryBuilder('u');
  2. $qb->leftJoin('u.admin', 'admin')
  3. ->Select($qb->expr()->count('admin'))
  4. ->addSelect('admin.username')
  5. ->addGroupBy('admin.username');
  6.  
  7. array(1) { [0]=> array(2) { [1]=>
  8. int(1)
  9. ["username"]=>
  10. string(5) "admin" }}
  11.  
  12. $e = $this->getDoctrine()->getRepository(User::class);
  13. $qb = $e->createQueryBuilder('u')
  14. ->join('u.statictics', 's')
  15. ->select('COUNT(s.id) as sCnt')
  16. ->addSelect('u.username')
  17. ->addGroupBy('u.username')
  18. ;
Add Comment
Please, Sign In to add comment