dezambig - Quarry

SQL

USE rowiki_p;
SELECT page_title AS page, page_len AS len from page
#	FROM (SELECT * FROM page WHERE page_namespace = 0 AND page_len < 1000 AND page_is_redirect = 0) AS pag
#JOIN wikidatawiki_p.pagelinks ON page_id = pl_from
    #(SELECT * FROM wikidatawiki_p.pagelinks WHERE pl_title = "Q4167410"
#      AND pl_from_namespace = 0 AND pl_namespace = 0) AS pagelinks
where page_namespace = 0 AND page_len < 700 AND page_is_redirect = 0
and page.page_id
in (SELECT pp_page FROM page_props pp2 JOIN page p2 ON pp2.pp_page = p2.page_id WHERE pp_propname = 'disambiguation')
ORDER BY page_title;
/*
SELECT * 
	FROM (SELECT * FROM wikidatawiki_p.page WHERE page_title = 'Q38')
    JOIN (SELECT * FROM wikidatawiki_p.page_props)
    	ON page_id = pp_page
LIMIT 20;
*/
SQL

Checking query status...
