Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
use wikidatawiki_p; 
#iswiki 	   52,675 ok
#ocwiki 	  104,940 ok
#ltwiki 	  199,102 ok
#nowiki 	  522,767 ok
#ptwiki 	1,085,121 ok <1'
#frwiki 	1,977,105 ok 1'  (700 with 50+ cats)
#svwiki 	2,267,557 ok 1'  (68 with 50+cats)
#enwiki 	6,329,683 
SELECT cl_to As category, COUNT(*) As NumberOfItemsWithoutStatement
#, COUNT(DISTINCT page_title) As NumberOfItemsWithoutStatement	
FROM 
	enwiki_p.categorylinks, 
	enwiki_p.page_props As wpage_props
WHERE cl_from = wpage_props.pp_page
#AND page_namespace=0
AND wpage_props.pp_propname = "wikibase_item" 
AND wpage_props.pp_page = cl_from
AND cl_type = "page"
AND wpage_props.pp_value IN (
SELECT page_title 
  FROM 
	page, 
	page_props, 
	wb_entity_per_page, 
	wb_items_per_site
  WHERE ips_site_id = "enwiki"
AND pp_page = epp_page_id
AND pp_propname = "wb-claims" 
AND pp_sortkey = 0  #same as pp_value: might be set for only about half of these items, others may lack wb-claims.
AND epp_entity_id = ips_item_id
AND epp_entity_type = "item"
AND page_id = pp_page)
GROUP BY cl_to 
HAVING COUNT(*)>50
SQL

Checking query status...
