Untitled query #1276

SQL

use wikidatawiki_p;
SELECT "nositelinks" as sit, COUNT(*) as ct 
FROM page, page_props 
WHERE page_namespace = 0 
AND page_is_redirect = 0 
AND page_id = pp_page 
AND pp_propname="wb-sitelinks" 
AND pp_sortkey = 0;

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;

SELECT "nositelinks" as sit, COUNT(*) as ct 
FROM page_props As pp1, page_props As pp2, page
WHERE page_namespace = 0 
AND page_is_redirect = 0
AND pp1.page_id = pp_page
AND 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;
SQL

Checking query status...
