with cc_queue as (
  select 1 as id, 10 as max_call_count, 1 as priority
  union all
  select 2 as id, 5 as max_call_count, 1 as priority
), cc_outbound_resource as (
  select 1 as id, 5 as max_call_count
  union all
  select 2 as id, 2 as max_call_count
  union all
  select 3 as id, 2 as max_call_count
), cc_queue_routing as (
  select 1 as id, '^1' as pattern, 1 as priority, 1 as queue_id
  union all
  select 2 as id, '^12' as pattern, 2 as priority, 1 as queue_id
  union all
  select 3 as id, '^2' as pattern, 3 as priority, 1 as queue_id
  union all
  select 4 as id, '^1' as pattern, 1 as priority, 2 as queue_id
  union all
  select 5 as id, '^12' as pattern, 2 as priority, 2 as queue_id
  union all
  select 6 as id, '^7' as pattern, 2 as priority, 1 as queue_id
  union all
  select 7 as id, '^7' as pattern, 2 as priority, 2 as queue_id
), cc_resource_in_routing as (
  select 1 as id, 1 as routing_id, 1 as resource_id, 1 as priority
  union all
  select 2 as id, 2 as routing_id, 1 as resource_id, 2 as priority
  union all
  select 3 as id, 2 as routing_id, 2 as resource_id, 3 as priority
  union all
  select 4 as id, 3 as routing_id, 2 as resource_id, 3 as priority
  union all
  select 5 as id, 4 as routing_id, 1 as resource_id, 1 as priority
  union all
  select 6 as id, 5 as routing_id, 1 as resource_id, 1 as priority
  union all
  select 7 as id, 6 as routing_id, 3 as resource_id, 1 as priority
  union all
  select 8 as id, 7 as routing_id, 3 as resource_id, 1 as priority
), cc_member as (
  select 1 as id, 1 as queue_id, 1 as priority
  union all
  select 2 as id, 1 as queue_id, 2 as priority
  union all
  select 3 as id, 1 as queue_id, 2 as priority
  union all
  select 4 as id, 1 as queue_id, 2 as priority
  union all
  select 5 as id, 1 as queue_id, 2 as priority
  union all
  select 6 as id, 1 as queue_id, 2 as priority
  union all
  select 7 as id, 1 as queue_id, 2 as priority
  union all
  select 8 as id, 2 as queue_id, 2 as priority
  union all
  select 9 as id, 2 as queue_id, 1 as priority
  union all
  select 10 as id, 2 as queue_id, 1 as priority
  union all
  select 11 as id, 1 as queue_id, 3 as priority
), cc_member_communications as (
    select 1 as id, 1 as member_id, '1111' as number, 2 as priority
    union all
    select 2 as id, 1 as member_id, '1212' as number, 1 as priority
    union all
    select 3 as id, 2 as member_id, '1003' as number, 1 as priority
    union all
    select 4 as id, 3 as member_id, '1004' as number, 1 as priority
    union all
    select 5 as id, 3 as member_id, '1005' as number, 2 as priority
    union all
    select 6 as id, 4 as member_id, '1006' as number, 2 as priority
    union all
    select 7 as id, 5 as member_id, '1007' as number, 2 as priority
    union all
    select 8 as id, 6 as member_id, '1008' as number, 2 as priority
    union all
    select 9 as id, 7 as member_id, '1009' as number, 2 as priority
    union all
    select 13 as id, 11 as member_id, '7200' as number, 3 as priority
--     q2
    union all
    select 10 as id, 8 as member_id, '2009' as number, 2 as priority
    union all
    select 11 as id, 9 as member_id, '1210' as number, 2 as priority
    union all
    select 12 as id, 10 as member_id, '7201' as number, 2 as priority
  )
select m.cc_id as cc_id,
       q.id    as queue_id,
       m.id,
       m.number,
       row_number() over (order by q.priority desc ) as rn,
       null as resource_id
from cc_queue q
   , lateral (select q.max_call_count) as qq(need_calls)
       inner join lateral (
  select c.cc_id as cc_id,
         m.id,
         c.number
  from cc_member m
         inner join lateral (
    select id as cc_id,
           queue_id,
           number
    from cc_member_communications c
    where c.member_id = m.id
      and c.number ~ '.*' -- ? как правильно соединить ресурсы, чтобы учесть макс. количество cc_outbound_resource

    order by priority desc
    limit 1
    ) as c on true

  where m.queue_id = q.id
  order by m.priority desc
  limit qq.need_calls
  ) m on true
order by q.priority desc;