Check if vfound_names_by_domain counts duplicate results twice

[wander]

If yes, either

• fix issue or
• write comment somewhere near the view

[schwittmann]

Implemented. Increased query execution time by 500%.

CREATE OR REPLACE VIEW vfound_names_by_domain AS

 SELECT count(*), domain_suffix FROM (SELECT DISTINCT r.result as result, p.domain_suffix as domain_suffix
   FROM bfresults r
   JOIN bfjobs j ON j.id = r.job
   JOIN bfsplits s ON s.id = j.split
   JOIN bfsubprojects p ON p.id = s.subproject
   ) as subq
  GROUP BY domain_suffix
  ORDER BY count DESC;