Wikidata items only linking to ar

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",ips1.ips_item_id) AS item, ips1.ips_site_page AS page, COUNT(backlinks.pl_from) AS backlinks
	FROM (SELECT * FROM wb_items_per_site WHERE ips_site_id = "arwiki") AS ips1
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0) AS backlinks
		ON backlinks.pl_title = CONCAT("Q",ips1.ips_item_id)
WHERE NOT EXISTS (
	SELECT ips2.ips_row_id FROM wb_items_per_site AS ips2
	WHERE ips2.ips_item_id = ips1.ips_item_id
	AND NOT ips2.ips_site_id = "arwiki"
)
GROUP BY ips1.ips_item_id
ORDER BY backlinks, ips1.ips_item_id;
SQL

Checking query status...
