SELECT DISTINCT auth_user.*, COUNT(market_security.id) AS "adjudicates__count" FROM "auth_user"
  INNER JOIN "auth_user_groups" ON ("auth_user"."id" = "auth_user_groups"."user_id")
  INNER JOIN "auth_group" ON ("auth_user_groups"."group_id" = "auth_group"."id")
  LEFT OUTER JOIN "market_security" ON ("auth_user"."id" = "market_security"."judge_id")
  INNER JOIN "auth_user_groups" T5 ON ("auth_user"."id" = T5."user_id")
  INNER JOIN "auth_group" T6 ON (T5."group_id" = T6."id")
  WHERE ("auth_group"."name" = Judges  AND T6."name" = Judges )
  ORDER BY "adjudicates__count" ASC