SELECT users.id, users.email, count(events.id) FROM users LEFT JOIN events on events.user_id = users.id WHERE users.active = true GROUP BY users.id, users.email ORDER BY users.email;