بوابات مكررة في التصانيف

SQL

use arwiki_p;
select p1.page_title, pl_title
from page p1
inner join pagelinks
on pl_from = p1.page_id
inner join page p2
on p2.page_title = pl_title
inner join redirect
on rd_from = p2.page_id
where pl_from_namespace = 14
and pl_namespace = 100
and p1.page_namespace = 14
and p1.page_is_redirect = 0
and p2.page_namespace = 100
and pl_title in (select page_title from page where page_title = pl_title and page_is_redirect = 1 and page_namespace = 100)
and rd_title in (select page_title from page where page_title = rd_title and page_is_redirect = 0 and page_namespace = 100);

SQL

Checking query status...