Wikidata items linking to disambiguations

SQL

USE wikidatawiki_p;
SELECT CONCAT("[[",items.page_title,"]]") AS item,
	CONCAT("[[",GROUP_CONCAT(disambigs.page_title ORDER BY disambigs.page_id SEPARATOR "]], [["),"]]") AS linked_disambigs
	FROM (SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND pl_namespace = 0 AND pl_from_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 AND item_links.pl_namespace = disambigs.page_namespace
	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 = 0) 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.page_id;
SQL

Checking query status...
