error

** (SyntaxError) web/controllers/streamer_controller.ex:11: unexpected comma. Parentheses are required to solve ambiguity in nested calls.

example.ex

    query = from s in Streamer,
      join: sb in Subscriber,
      where: s.id == sb.streamer_id,
      select: s.name as name, s.id as id, count(sb.id) as subs,
      group: s.name, s.id,
      order: subs desc,
      limit: 100
      #preload: [:subscribers]
    streamers = Repo.all(query)

example.go

	rows, err := app.DB.Table("streamers").Select(
		"streamers.id as id, streamers.name as name, count(subscribers.id) as subs",
	).Joins(
		"left join subscribers on streamers.id = subscribers.streamer_id",
	).Group(
		"streamers.name, streamers.id",
	).Order("subs desc").Limit(100).Rows()