pages linking to links contained on a page :)

SQL

USE enwiki_p;/*
SELECT distinct pl2.pl_title, pl1.pl_title
FROM pagelinks pl1
join page p1 on pl1.pl_title = p1.page_title and pl1.pl_from = 2129508
join pagelinks pl2 on pl2.pl_title = p1.page_title
where pl2.pl_title like "%/_рад%" ESCAPE "/" and pl2.pl_title not like "%рада)"*/
select p2.page_title, p1.page_title
from page p1
join pagelinks on pl_title = p1.page_title AND p1.page_namespace = 0 AND pl_from_namespace = 0
join page p2 on pl_from = p2.page_id and p2.page_namespace = 0
where pl_title in (select pl1.pl_title FROM enwiki_p.pagelinks pl1 where pl1.pl_from = 43401631)
ORDER BY p1.page_title#pl1.pl_title;

SQL

Checking query status...