Fork of pages linking to links contained on a page :) by XXN
This query is marked as a draft This query has been published by XXN.

SQL

AخA
 
USE shwiki_p;
select page_title, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(page_title, '_(razvrstavanje)', ''), "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț")
from page
where page_title in (select pl_title FROM shwiki_p.pagelinks pl1 where pl1.pl_from = 4597219) 
AND page_is_redirect = 0 AND page_namespace = 0
AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(page_title, '_(razvrstavanje)', ''), "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț")
        in (select page_title
            /*
#and REPLACE(page_title, '_(razvrstavanje)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
and REPLACE(page_title, '_(olika_betydelser)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(pagklaro)', '') in (select REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(olika_betydelser)', '') in (select REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
            */
#from enwiki_p.page p
#join enwiki_p.categorylinks c2 on p.page_id=c2.cl_from
from rowiki_p.page p
join rowiki_p.categorylinks c2 on p.page_id=c2.cl_from
#where c2.cl_to = "Disambiguation_pages" 
where c2.cl_to = "Dezambiguizare" 
            AND page_is_redirect = 0 AND page_namespace = 0 )#*/
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="en")
ORDER BY page_title
#limit 400
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...