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 'V%\_D%'
and page.page_title not like '%\_%\_%'
and pl1.pl_title like 'D%\_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 'V%\_D%'
and page.page_title not like '%\_%\_%'
and pl1.pl_title like 'J%\_T%'
and pl1.pl_title not like '%\_%\_%'
and pl1.pl_namespace=0

order by page_title
limit 2500
SQL

Checking query status...
