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 ips_site_id as sit, COUNT(*) as ct 
FROM page_props, wb_items_per_site, wb_entity_per_page 
WHERE pp_sortkey = 0 AND pp_propname="wb-claims" 
AND pp_page = epp_page_id AND ips_item_id = epp_entity_id 
AND epp_entity_type = "item" GROUP BY ips_site_id )
UNION 
(SELECT "nositelinks" as sit, COUNT(*) as ct
FROM page_props As pp1, page_props As pp2 
WHERE pp1.pp_propname="wb-claims"
AND pp2.pp_propname="wb-sitelinks"
AND pp1.pp_sortkey = 0
AND pp2.pp_sortkey = 0
AND pp1.pp_page = pp2.pp_page )
ORDER BY COUNT(*) DESC
SQL

Checking query status...
