Wikidata items linking to disambiguations

SQL

USE wikidatawiki_p;
SELECT item_links.pl_from AS item, disambigs.page_title /* GROUP_CONCAT(disambigs.page_title SEPARATOR ', ')*/ AS disambig
	FROM (SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND pl_from_namespace = 0 AND pl_namespace = 0) AS disambig_links
	JOIN (SELECT * FROM page WHERE page_is_redirect = 0) AS disambigs
		ON disambigs.page_id = disambig_links.pl_from
	JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0) AS item_links
		ON item_links.pl_title = disambigs.page_title
#	JOIN wb_entity_per_page AS items
#		ON items.epp_entity_id = item_links.pl_from
#GROUP BY items.page_title
#ORDER BY COUNT(DISTINCT disambigs.page_title) DESC, items.page_id
LIMIT 100;
SQL

Checking query status...
