Wikidata - pages on simplewiki but not enwiki

SQL

SELECT CONCAT("Q",ips_item_id), simple_site_page, COUNT(ips_site_id) as number_of_wikis
FROM wb_items_per_site
JOIN (
	SELECT ips_item_id AS simple_item_id, ips_site_page AS simple_site_page
	FROM wb_items_per_site
    WHERE ips_item_id NOT IN (
		SELECT ips_item_id
		FROM wb_items_per_site
		WHERE ips_site_id = 'enwiki'
	)
    AND ips_site_page NOT LIKE '%:%'
	AND ips_site_id = 'simplewiki'
) simple ON ips_item_id = simple_item_id
GROUP BY ips_item_id
ORDER BY number_of_wikis DESC
HAVING number_of_wikis > 25

SQL

Checking query status...