Untitled query #1276

SQL

use wikidatawiki_p;
# SHOW TABLES;
SELECT COUNT(*) as ?ct
from wb_items_per_site, wb_terms,  page_props as qid
WHERE ips_site_id = "cebwiki"
AND ips_item_id = term_entity_id AND term_entity_type = "item"
AND term_full_entity_id = qid.pp_value 
AND qid.pp_propname = 'wikibase_item'

# ,  page_props as sl
# AND sl.pp_page = qid.pp_page
# AND sl.pp_propname = "wb-sitelinks" and sl.pp_value= "1"
LIMIT 10
;
# SELECT * FROM wb_terms WHERE term_full_entity_id = "Q4657626" LIMIT 10;
# SELECT * FROM wb_items_per_site WHERE ips_item_id = 4657626 LIMIT 10;
# SELECT * FROM page WHERE page_id = 4449555 LIMIT 10;
# SELECT * FROM page_props WHERE pp_page = 	4449555 LIMIT 10;
SQL

Checking query status...
