Untitled query #32189

SQL

select page_id, page_title, pl1.pl_title, 'mc' as ss
from page
	inner join pagelinks pl1
		on  page_id = pl1.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

union all

select page_id, page_title, pl1.pl_title, 'nb' as ss
from page
	inner join pagelinks pl1
		on  page_id = pl1.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 'N%\_B%'
and pl1.pl_title not like '%\_%\_%'
and pl1.pl_namespace=0

union all

select page_id, page_title, pl1.pl_title, 'jt' as ss
from page
	inner join pagelinks pl1
		on  page_id = pl1.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 'J%\_T%'
and pl1.pl_title not like '%\_%\_%'
and pl1.pl_namespace=0

limit 500
SQL

Checking query status...
