Untitled query #1276

SQL

use wikidatawiki_p; 
SELECT c.cl_to As cat, c.cnt As cnt, d.pp_value As QID 
FROM 
(
SELECT cl_to, COUNT(*) AS cnt 
FROM ocwiki_p.categorylinks as cl, 
ocwiki_p.page_props As wpage_props 
WHERE cl_from = wpage_props.pp_page 
AND wpage_props.pp_propname = "wikibase_item" 
AND wpage_props.pp_page = cl.cl_from 
AND cl_type = "page" 
AND wpage_props.pp_page IN ( SELECT pp.pp_page FROM ocwiki_p.page_props as pp WHERE pp.pp_propname = "hiddencat" ) as hiddencat 
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 = "ocwiki" 
AND pp_page = epp_page_id 
AND pp_propname = "wb-claims" 
AND pp_sortkey = 0 
AND epp_entity_id = ips_item_id 
AND epp_entity_type = "item" 
AND page_id = pp_page) 
GROUP BY cl_to 
HAVING COUNT(*)>10 
ORDER BY COUNT(*) DESC
) as c 
LEFT JOIN 
(
SELECT page_title, pp_value 
FROM ocwiki_p.page, ocwiki_p.page_props 
WHERE page_namespace = 14 
AND pp_page = page_id 
AND pp_propname = "wikibase_item" 
) as d ON c.cl_to = d.page_title
SQL

Checking query status...
