categorii omonime separate cross-wiki

SQL

select p1.page_title, pp1.pp_value, pp2.pp_value
from eswiki_p.page p1, , page_props pp
	LEFT JOIN eswiki_p.langlinks ll1
    	ON ll1.ll_from = p1.page_id
JOIN (SELECT * FROM eswiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
		ON props.pp_page = p1.page_id
join enwiki_p.page p2 on p1.page_title = p2.page_title
and (p1.page_is_redirect = 0 AND p1.page_namespace = 14 and p2.page_namespace = 14)
where
#...and REPLACE(p2.page_title,'_', ' ') not in ll_title
/*and pp_value is not NULL
AND*/ ll1.ll_title IS NULL

SQL

Checking query status...