Disambiguations to be merged (cswiki)

SQL

USE wikidatawiki_p;
SELECT page1.page_title, /*GROUP_CONCAT(terms1.term_text),*/ links1.pl_title#, links3.pl_title, page2.page_title, GROUP_CONCAT(terms2.term_text)
	FROM page AS page1
	JOIN pagelinks AS links1
		ON links1.pl_from = page1.page_id AND links1.pl_title IN ("Q202444","Q12308941","Q11879590") AND links1.pl_from_namespace = 0 AND links1.pl_namespace = 0
	LEFT JOIN pagelinks AS links3
		ON links3.pl_from = page1.page_id AND links3.pl_title = "P1533" -- AND links3.pl_namespace = 120
	JOIN wb_terms AS terms1
		ON CONCAT("Q",terms1.term_entity_id) = page1.page_title
	JOIN wb_terms AS terms2
		ON GROUP_CONCAT(terms2.term_text) = GROUP_CONCAT(terms1.term_text)
#	JOIN pagelinks AS links2
#		ON links2.pl_title = "Q101352" AND links2.pl_namespace = 0 AND links2.pl_from_namespace = 0
#	JOIN page AS page2
#		ON page2.page_id = links2.pl_from
#	JOIN wb_terms AS terms2
#		ON CONCAT("Q",terms2.term_entity_id) = page2.page_title
WHERE links3.pl_from IS NULL
# WHERE terms1.term_text = terms2.term_text AND links3.pl_from IS NULL
GROUP BY page1.page_title # HAVING (COUNT(terms1.term_text) = 1 AND COUNT(terms2.term_text) = 1)
LIMIT 50;
SQL

Checking query status...
