unconnected ceb disamb

SQL

USE svwiki_p;
SELECT page_title
	FROM page
join categorylinks on page_id=cl_from/*
	LEFT JOIN langlinks
    	ON ll_from = page_id*/
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE cl_to = "Robotskapade_förgreningssidor"
and pp_value is not NULL
#AND ll_title IS NULL
AND page_is_redirect = 0 AND page_namespace = 0
and page_title in (select page_title
from plwiki_p.page p
	LEFT JOIN (SELECT * FROM plwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props1
		ON pp_page = p.page_id
join plwiki_p.categorylinks c2 on p.page_id=c2.cl_from
where c2.cl_to = "Strony_ujednoznaczniające" AND p.page_is_redirect = 0 AND p.page_namespace = 0
and pp_value is not NULL
and p.page_id not in (select m.ll_from from langlinks m where m.ll_lang="sv"))/*
group by ll_from*/
ORDER BY page_title;
SQL

Checking query status...
