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; 

SELECT cl_to, COUNT(DISTINCT page_id)
FROM 	wikidatawiki_p.page_props AS wdprops, 
	wb_entity_per_page, 
	wb_items_per_site, 
	ocwiki_p.categorylinks, 
	ocwiki_p.page_props AS wpage_props, 
	ocwiki_p.page AS wpage
WHERE wdprops.pp_sortkey = 0
AND wdprops.pp_propname="wb-claims" 
AND wdprops.pp_page = epp_page_id
AND epp_entity_type = "item"
AND epp_entity_id = ips_item_id
AND ips_site_id = "ocwiki"  #ltwiki 	199,102      works for ocwiki 	104,940
AND wpage.page_title = ips_site_page
AND wpage.page_namespace = 0
AND wpage.page_id= cl_from
AND cl_type="page"
GROUP BY cl_to 
#HAVING COUNT(DISTINCT page_id)>10
ORDER BY COUNT(*) DESC LIMIT 50
SQL

Checking query status...
