Wikidata - pages not on enwiki but in at least 25 others

SQL

SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, Name, Description, number_of_wikis as 'Number of articles'
FROM (
	SELECT ips_item_id, COUNT(ips_site_id) as number_of_wikis
	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 '%:%'
	GROUP BY ips_item_id
	HAVING number_of_wikis > 25) items
LEFT JOIN (
    SELECT 
        wbit_item_id, 
        COALESCE(MAX(CASE WHEN wbtl_type_id = 1 THEN wbx_text END), 'UNKNOWN') as Name, 
  		COALESCE(MAX(CASE WHEN wbtl_type_id = 2 THEN wbx_text END), 'UNKNOWN') as Description
    FROM wbt_item_terms
    LEFT JOIN wbt_term_in_lang ON wbt_term_in_lang.wbtl_id = wbt_item_terms.wbit_term_in_lang_id
    LEFT JOIN wbt_text_in_lang ON wbt_text_in_lang.wbxl_id = wbt_term_in_lang.wbtl_text_in_lang_id AND wbt_text_in_lang.wbxl_language = 'en'
    LEFT JOIN wbt_text ON wbt_text.wbx_id = wbt_text_in_lang.wbxl_text_id
) details ON wbit_item_id = ips_item_id
ORDER BY number_of_wikis DESC
SQL

Checking query status...
