Wikidata items only link to zhwikiquote - Quarry

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

SQL

USE wikidatawiki_p;
select a.ips_item_id, a.ips_site_page from
(select * from wb_items_per_site as a where ips_site_id = "zhwikiquote") a
left join 
(select * from wb_items_per_site as a where ips_site_id != "zhwikiquote") b
on a.ips_item_id = b.ips_item_id
WHERE b.ips_item_id IS NULL;

​x
 
USE wikidatawiki_p;select a.ips_item_id, a.ips_site_page from(select * from wb_items_per_site as a where ips_site_id = "zhwikiquote") aleft join (select * from wb_items_per_site as a where ips_site_id != "zhwikiquote") bon a.ips_item_id = b.ips_item_idWHERE b.ips_item_id IS NULL;​

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...