Query: ec2_load_balancer_listeners_for_api_gatewayv2_api

with filtered_api as (
  select
    api_id,
    account_id,
    region
  from
    aws_api_gatewayv2_api
  where
    api_id = $1
  order by
    api_id
),
filtered_integration as (
  select
    integration_uri,
    account_id,
    region,
    api_id
  from
    aws_api_gatewayv2_integration as i
  where
    api_id = $1
    and account_id = (select account_id from filtered_api)
    and region = (select region from filtered_api)
  order by
    integration_uri
),
filtered_load_balancer_listener as (
  select
    arn,
    account_id,
    region
  from
    aws_ec2_load_balancer_listener
  where
  arn = (select integration_uri from filtered_integration)
  and account_id = (select account_id from filtered_integration)
  and region = (select region from filtered_integration)
  order by
    arn
)
select
  lb.arn as listener_arn
from
  filtered_integration i
  join filtered_load_balancer_listener lb on i.integration_uri = lb.arn
  join filtered_api a on a.api_id = i.api_id;