Untitled query #2807

SQL

use hewiki_p;
select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title as 'פירושון' from pagelinks inner join page as p1 inner join page as p2
inner join redirect
on pl_namespace = 0
and p1.page_id = pl_from
and p1.page_namespace = 0
and pl_title = p2.page_title
and p2.page_id = rd_from
and rd_namespace = 0
and rd_title in
(select page_title
from page join categorylinks
on page_namespace = 0
and page_id = cl_from
and cl_to = 'פירושונים')
and exists
(select * from categorylinks
 where p1.page_id = cl_from
 and cl_title = "פירושונים")
SQL

Checking query status...
