Untitled query #32189

SQL

xselect page_id, page_title, pl1.pl_title, pl2.pl_title, pl3.pl_title
from page
	inner join pagelinks pl1
		on  page_id = pl1.pl_from
	inner join pagelinks pl2
		on  page_id = pl2.pl_from
	inner join pagelinks pl3
		on  page_id = pl3.pl_from
where
page.page_namespace=0
and page.page_is_redirect=0
and page.page_title like 'A%\_K%'
and page.page_title not like '%\_%\_%'
and pl1.pl_title like 'M%\_C%'
and pl1.pl_title not like '%\_%\_%'
and pl1.pl_namespace=0
and pl2.pl_title like 'N%\_B%'
and pl2.pl_title not like '%\_%\_%'
and pl2.pl_namespace=0
and pl3.pl_title like 'J%\_T%'
and pl3.pl_title not like '%\_%\_%'
and pl3.pl_namespace=0
limit 1000
SQL

Checking query status...
