🏆 Top Story: query/ - Fox News Update

SQL

select sum(articles), count(actor_name), median
from (
  select actor_name, count(rev_page) as articles, median(articles) over () as median
  from revision_userindex
  join page on page_id = rev_page
  join actor on actor_id = rev_actor
  where rev_parent_id = 0
  and page_is_redirect = 0
  and page_namespace = 0
  and page_id not in (select cl_from from categorylinks where cl_target_id in (select lt_id from linktarget where lt_namespace = 14 and lt_title in ("All_disambiguation_pages", "Monitored_short_pages"))
  )
  and rev_actor in (select actor_id from actor_revision where actor_name in (
    select distinct replace(lt_title,"_"," ") from linktarget join pagelinks on lt_id=pl_target_id where pl_from=83257831 and lt_namespace in (2,3)
    and lt_title not like '%/%' and lt_title not in ("SCherukuwada_(WMF)", "GalliumBot", "SDZeroBot", "SDeckelmann-WMF")))
  group by actor_name
) t
SQL

Checking query status...
