Disambiguations to be merged (cswiki)

SQL

USE wikidatawiki_p;
SELECT page1.page_title, /* terms1.term_text, */ links1.pl_title, page2.page_title #, 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 page AS page2
		ON page2.page_namespace = 0
	JOIN pagelinks AS links2
		ON links2.pl_from = page2.page_id AND links2.pl_title = "Q101352" -- AND links2.pl_namespace = 0
/*	JOIN wb_terms AS terms1
		ON CONCAT("Q",terms1.term_entity_id) = page1.page_title
	JOIN wb_terms AS terms2
		ON CONCAT("Q",terms2.term_entity_id) = page2.page_title
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...
