Untitled query #41015

SQL

select page_id, page_title, count(*)
from
(
select *
from
(
select page.page_id, page.page_title, pl1.pl_title
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 like 'V%\_S%'
and pl1.pl_namespace=0
  and page.page_title not like '%school'
limit 500
) vs
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title
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 like 'M%\_H%'
and pl1.pl_namespace=0
limit 500
) mh
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title
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 like 'S%\_S%'
and pl1.pl_namespace=0
limit 500
) ss
union all
select *
from
(
select page.page_id, page.page_title, pl1.pl_title
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 like 'R%\_K%'
and pl1.pl_namespace=0
limit 500
) rk
    
  
) u
group by page_id, page_title
having count(*)>1
order by count(*) desc
SQL

Checking query status...
