Untitled query #41301

SQL

select page_id, page_title, count(*), count(distinct initials)
from
(
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'bc' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.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  
limit 65000
) vs
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'zg' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Zach_Galifianakis'
and pl1.pl_namespace=0
limit 65000
) zg
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'gs' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
  and pl1.pl_title = 'Gregory_Smith'
and pl1.pl_namespace=0
limit 65000
) gs  
union all
  select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'mc' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Michael_Caine'
and pl1.pl_namespace=0
limit 65000
) mc
union all
  select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'sn' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Sam_Neill'
and pl1.pl_namespace=0
limit 65000
) sn
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'es' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from
       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Eric_Stoltz'
and pl1.pl_namespace=0
limit 65000
) ss
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'en' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Edward_Norton_filmography'
and pl1.pl_namespace=0
limit 65000
) en
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'jl' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from
       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Jude_Law'
and pl1.pl_namespace=0
  
limit 65000
) jl
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title, 'dc' as initials
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from       
where
page.page_namespace=0
and page.page_is_redirect=0
and pl1.pl_title = 'Dan_Castellaneta'
and pl1.pl_namespace=0
limit 65000
) dg
        
  
  
) u
group by page_id, page_title
having count(*)>1

order by count(distinct initials) desc
SQL

Checking query status...
