Untitled query #1332

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 enwiki_p.categorylinks as cl, enwiki_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_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
      AND pp_value = "0"
     AND epp_entity_id = ips_item_id AND epp_entity_type = "item" 
     AND page_id = pp_page) GROUP BY cl_to HAVING COUNT(*)> 99 
 ORDER BY COUNT(*) DESC) as c LEFT JOIN ( SELECT page_title, pp_value FROM enwiki_p.page, enwiki_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...
