Untitled query #41319

SQL

select page_title, count(distinct initials) 
from
(

select *
from
(
select 'bc' as initials, page.page_id, page.page_title, pl2.pl_title
from page
	inner join pagelinks pl1
		on  page.page_id = pl1.pl_from           
    inner join pagelinks pl2
  		on  page.page_id = pl2.pl_from
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'List_of_Benedict_Cumberbatch_performances'
and pl1.pl_namespace=0  
and pl2.pl_namespace=0
  
limit 50000
) bc

union all

select *
from
(
select 'zg' as initials, page.page_id, page.page_title, pl2.pl_title
from page
	inner join pagelinks pl1
		on  page.page_id = pl1.pl_from           
    inner join pagelinks pl2
  		on  page.page_id = pl2.pl_from
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Zach_Galifianakis'
and pl1.pl_namespace=0  
and pl2.pl_namespace=0
  
limit 50000
) zg


) actors
group by page_title
SQL

Checking query status...
