Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Doctrine_Query::create()
- ->select('m.id, COUNT(m.id) cnt, m.dest_x, m.dest_y')
- ->from('Mission m')
- ->leftJoin('m.Player p)
- ->where('p.group_id = ?', $groupid)
- ->addWhere('cnt < ANY (SELECT count(m2.id) cnt2 FROM Mission m2 LEFTJOIN m2.Player p2 WHERE p2.group_id <> ?), $groupid)
- ->groupBy('m.dest_x, m.dest_y')
Add Comment
Please, Sign In to add comment