Wikidata items with ltwiki sitelink but no statements - Quarry

This query is marked as a draft This query has been published by Magnus Manske.

SQL

use wikidatawiki_p;
select ips_item_id,(SELECT count(*) FROM pagelinks WHERE pl_from=epp_page_id AND pl_namespace=120) AS cnt FROM wb_items_per_site,wb_entity_per_page WHERE epp_entity_id=ips_item_id and epp_entity_type='item' and ips_site_id='ltwiki' group by ips_item_id having cnt=0

AخA
 
use wikidatawiki_p;select ips_item_id,(SELECT count(*) FROM pagelinks WHERE pl_from=epp_page_id AND pl_namespace=120) AS cnt FROM wb_items_per_site,wb_entity_per_page WHERE epp_entity_id=ips_item_id and epp_entity_type='item' and ips_site_id='ltwiki' group by ips_item_id having cnt=0

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...