Fork of
Untitled query #33527
by WhitePhosphorus
This query is marked as a draft
This query has been published
by WhitePhosphorus.
SQL
AخA
USE wikidatawiki_p;
USE enwiki_p;
SELECT * FROM (SELECT page_id, page_title FROM enwiki_p.page JOIN enwiki_p.page_props ON page_id = pp_page WHERE pp_propname = "disambiguation" AND LENGTH(page_title) = 3 AND page_namespace = 0 AND page_is_redirect = 0) AS ta
JOIN wikidatawiki_p.wb_items_per_site AS tb ON page_title = ips_site_page
#JOIN wikidatawiki_p.wb_items_per_site ON page_title = ips_site_page
#WHERE NOT CONTAINS(CONCAT("&", CONCAT_WS("&", tc.ips_site_id), "&"), "&zhwiki&")
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.