Optimize run_stats_queries

[bwbroersma]

This can be removed:

• Internet.nl/interface/views/shared.py

  Lines 323 to 334 in cef300d

  	inner join
  	(
  	select
  	domain,
  	max(timestamp) as timestamp
  	from
  	checks_domaintestreport
  	group by
  	domain
  	) as rmax
  	on r.domain = rmax.domain
  	and r.timestamp = rmax.timestamp

• Internet.nl/interface/views/shared.py

  Lines 345 to 356 in cef300d

  	inner join
  	(
  	select
  	domain,
  	max(timestamp) as timestamp
  	from
  	checks_mailtestreport
  	group by
  	domain
  	) as rmax
  	on r.domain = rmax.domain
  	and r.timestamp = rmax.timestamp

• Internet.nl/interface/views/shared.py

  Lines 368 to 383 in cef300d

  	inner join
  	(
  	select
  	coalesce(ipv4_addr,
  	ipv6_addr) as source,
  	max(timestamp) as timestamp
  	from
  	checks_connectiontest
  	where
  	finished = true
  	group by
  	coalesce(ipv4_addr,
  	ipv6_addr)
  	) as rmax
  	on coalesce(r.ipv4_addr,
  	r.ipv6_addr) = rmax.source

This can be rewritten:

• Internet.nl/interface/views/shared.py

  Lines 395 to 410 in cef300d

  	inner join
  	(
  	select
  	coalesce(ipv4_addr,
  	ipv6_addr) as source,
  	max(timestamp) as timestamp
  	from
  	checks_connectiontest
  	where
  	finished = true
  	group by
  	coalesce(ipv4_addr,
  	ipv6_addr)
  	) as rmax
  	on coalesce(r.ipv4_addr,
  	r.ipv6_addr) = rmax.source