Untitled query #1332

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

SQL

use wikidatawiki_p; 

SELECT CONCAT("Q",ips_item_id) as item
FROM wb_entity_per_page 
WHERE epp_page_id NOT IN (SELECT pl_from FROM wikidatawiki_p.page JOIN wikidatawiki_p.pagelinks 
        ON page_id=pl_from 
        WHERE pl_namespace = 120) 
# ORDER BY COUNT(ips_site_id) DESC 
LIMIT 1

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.

SQL

Checking query status...