Query: dns_mx_record

with domain_records as (
  select
    *
  from
    net_dns_record
  where
    domain = $1
    and type = 'MX'
),
ns_ips as (
  select
    *
  from
    net_dns_record
  where
    domain in (
      select
        target
      from
        domain_records
    )
)
select
  domain_records.priority as "Priority",
  domain_records.target as "Domain",
  ns_ips.ip as "IP Address",
  ns_ips.ttl as "TTL"
from
  domain_records
  inner join ns_ips on domain_records.target = ns_ips.domain
where
  ns_ips.type = 'A'
  and domain_records.type = 'MX'
order by
  domain_records.priority;