Disambiguations to be merged (cswiki)

SQL

USE wikidatawiki_p;
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
	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"
	LEFT JOIN pagelinks AS links3
		ON links3.pl_from = links1.pl_from AND links3.pl_title = "P1533"*/
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;
SQL

Checking query status...
