items for categories/templates, without sitelinks, with deleted links

SQL

USE wikidatawiki;
SELECT CONCAT("# [[Q",epp1.epp_entity_id,"]]") AS item, GROUP_CONCAT(DISTINCT CONCAT("[[",further_links.pl_title,"]]") SEPARATOR ', ') AS links_to
	FROM (SELECT * FROM pagelinks WHERE pl_title = "Q4167836" AND pl_from_namespace = 0) AS dupes#Q11266439
	JOIN wb_entity_per_page AS epp1
		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"*/
    join revision on rev_page = dupes.pl_from
WHERE ips_item_id IS NULL and rev_comment like "%clientsitelink-remove%"
GROUP BY dupes.pl_from
#having COUNT(DISTINCT backlinks.pl_from) = 0
#ORDER BY COUNT(DISTINCT backlinks.pl_from) DESC, dupes.pl_from;

SQL

Checking query status...