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;