text: select
    string_agg(sub.company, ',') as companies
  from (
    select af.{{company_name}} as company,
      count(distinct c.sha) as commits
    from (
      select
        sha,
        dup_created_at,
        dup_actor_id as actor_id,
        author_id,
        committer_id,
        dup_actor_login,
        dup_author_login,
        dup_committer_login
      from
        gha_commits
      where
        dup_created_at >= '{{dtfrom}}'
        and dup_created_at < '{{dtto}}'
      ) c,
      gha_actors_affiliations af
    where
      c.{{actor}}_id = af.actor_id
      and af.dt_from <= c.dup_created_at
      and af.dt_to > c.dup_created_at
      and af.{{company_name}} != 'Independent'
      and af.{{company_name}} != ''
      and (lower(c.dup_{{actor}}_login) {{exclude_bots}})
    group by
      af.{{company_name}}
    order by
      commits desc,
      company asc
    limit {{lim}}
  ) sub
  ;
  