Untitled query #4312

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",epp_entity_id), IFNULL(GROUP_CONCAT(further_links.pl_title SEPARATOR ', '),'')
	FROM (SELECT * FROM pagelinks WHERE pl_title = "Q17362920" AND pl_from_namespace = 0) AS dupes
	JOIN wb_entity_per_page
		ON epp_page_id = dupes.pl_from
	LEFT JOIN wb_items_per_site
		ON ips_item_id = epp_entity_id
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0) AS further_links
		ON further_links.pl_from = dupes.pl_from AND further_links.pl_title <> "Q17362920"
WHERE ips_item_id IS NULL
GROUP BY dupes.pl_from
ORDER BY COUNT(further_links.pl_title) DESC, dupes.pl_from;
SQL

Checking query status...
