Untitled query #1296

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 nok
#nowiki 	522,767 

SELECT cl_to As category, ips_site_id
, COUNT(*) As NumberOfUncategorizedItems
#, COUNT(DISTINCT page_title)	
FROM 
	wikidatawiki_p.page_props AS wdprops, 
	page, 
	wb_entity_per_page, 
	wb_items_per_site, 
	ocwiki_p.categorylinks, 
	ocwiki_p.page_props As wpage_props
WHERE wdprops.pp_sortkey = 0
AND wdprops.pp_propname="wb-claims" 
AND page_id = wdprops.pp_page
AND page_namespace=0
AND wdprops.pp_page = epp_page_id
AND epp_entity_id = ips_item_id
AND epp_entity_type = "item"
AND ips_site_id = "ocwiki"
AND wpage_props.pp_value = page_title
AND wpage_props.pp_propname = "wikibase_item" 
AND wpage_props.pp_page = cl_from
AND cl_type = "page"
GROUP BY cl_to 
HAVING COUNT(*)>5
SQL

Checking query status...
