Untitled query #32109

SQL

select page_id, page_title, pl1.pl_title
from page
	inner join pagelinks pl1
    	on page.page_id = pl1.pl_from
where
(page.page_namespace=0
and page.page_is_redirect=0
)
and
(
  (
page.page_title like 'V%\_D%'
    and pl1.pl_title like 'D%\_C%'
and page.page_title not like '%\_%\_%'
and pl1.pl_title not like '%\_%\_%'
)

)

union all

select page_id, page_title, pl2.pl_title
from page
    inner join pagelinks pl2
    	on page.page_id = pl2.pl_from
where
(page.page_namespace=0
and page.page_is_redirect=0
)
and
(
  (
page.page_title like 'V%\_D%'
    and pl2.pl_title like 'J%\_T%'
and page.page_title not like '%\_%\_%'
    and pl2.pl_title not like '%\_%\_%'
)

)
order by page_title

limit 500
SQL

Checking query status...
