Disambiguations to be merged (cswiki)

SQL

USE wikidatawiki_p;
# DESCRIBE wb_terms;
/*SELECT CONCAT("Q",epp1.epp_entity_id), links1.pl_title, terms1.term_text, CONCAT("Q",epp2.epp_entity_id), terms2.term_text
	FROM pagelinks AS links1
	JOIN wb_entity_per_page AS epp1
		ON epp1.epp_page_id = links1.pl_from
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_title = "P1533") AS links3
		ON links3.pl_from = epp1.epp_page_id
	JOIN wb_terms AS terms1
		ON terms1.term_entity_id = epp1.epp_entity_id
	CROSS JOIN wb_terms AS terms2
		ON terms2.term_text = terms1.term_text
#	JOIN wb_entity_per_page AS epp2
#		ON epp2.epp_page_id = terms2.term_entity_id
#	JOIN pagelinks AS links2
#		ON links2.pl_from = epp2.epp_page_id AND links2.pl_title = "Q101352"
WHERE links1.pl_title IN ("Q202444","Q12308941","Q11879590")# AND links2.pl_from IS NULL
GROUP BY epp1.epp_entity_id HAVING COUNT(DISTINCT terms1.term_text) = 1 #AND COUNT(DISTINCT terms2.term_text) = 1
LIMIT 100;

SELECT *
	FROM wb_entity_per_page AS epp1
	JOIN (SELECT * FROM pagelinks WHERE pl_title IN ("Q202444","Q12308941","Q11879590")) AS links1
		ON epp1.epp_page_id = links1.pl_from
	JOIN (SELECT * FROM wb_terms WHERE term_type = "label") AS terms1
		ON terms1.term_entity_id = epp1.epp_entity_id
	CROSS JOIN (SELECT * FROM wb_terms WHERE term_type = "label") AS terms2
		ON terms2.term_text = terms1.term_text
#	JOIN pagelinks AS links2
#		ON links2.pl_title = "Q101352"
# WHERE NOT EXISTS (
#   SELECT * FROM pagelinks AS links3 WHERE links3.pl_from = epp1.epp_page_id AND links3.pl_title = "P1533"
# )
GROUP BY epp1.epp_entity_id
LIMIT 100; */
SELECT *
FROM wb_terms AS terms1, wb_entity_per_page AS epp1, pagelinks AS links1, wb_terms AS terms2, wb_entity_per_page AS epp2, pagelinks AS links2
WHERE terms1.term_entity_id = epp1.epp_entity_id
AND epp1.epp_page_id = links1.pl_from
AND links1.pl_title IN ("Q202444","Q12308941","Q11879590")
AND terms1.term_text = terms2.term_text
AND terms2.term_entity_id = epp2.epp_entity_id
AND epp2.epp_page_id = links2.pl_from
AND links2.pl_title = "Q101352"
AND NOT epp1.epp_page_id IN (SELECT pl_from FROM pagelinks WHERE pl_title = "P1533") 
GROUP BY epp1.epp_entity_id HAVING COUNT(DISTINCT terms1.term_text) = 1
LIMIT 100;
SQL

Checking query status...
