Wikidata items linking to disambiguations

SQL

USE wikidatawiki_p;
SELECT items.page_title, GROUP_CONCAT(disambigs.page_title SEPARATOR ', ') AS linked_disambigs
	FROM (SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND pl_from_namespace = 0 AND pl_namespace = 0) AS disambig_ids
	JOIN page AS disambigs
		ON disambigs.page_id = disambig_ids.pl_from
	JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0) AS item_links
		ON item_links.pl_title = disambigs.page_title
	#LEFT JOIN (SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND pl_namespace = 0) AS disambig_links
	#	ON disambig_links.pl_from = item_links.pl_from
	JOIN (SELECT * FROM page WHERE page_is_redirect = 1) AS items
		ON items.page_id = item_links.pl_from
#WHERE disambig_links.pl_title IS NULL
GROUP BY items.page_id
ORDER BY COUNT(*) DESC, items.epp_page_id;
SQL

Checking query status...
