Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Aca
.
Toggle Highlighting
SQL
USE shwiki_p; SELECT sh.page_title AS sh_title, sr.page_title AS sr_title, bs.page_title AS bs_title FROM page AS sh JOIN wikidatawiki_p.wb_items_per_site AS sh_wd ON sh_wd.site_id = 'shwiki' AND sh_wd.page_title = sh.page_title JOIN wikidatawiki_p.wb_items_per_site AS sr_wd ON sr_wd.site_id = 'srwiki' AND sr_wd.wb_item_id = sh_wd.wb_item_id JOIN srwiki_p.page AS sr ON sr.page_title = sr_wd.page_title JOIN wikidatawiki_p.wb_items_per_site AS bs_wd ON bs_wd.site_id = 'bswiki' AND bs_wd.wb_item_id = sh_wd.wb_item_id JOIN bswiki_p.page AS bs ON bs.page_title = bs_wd.page_title WHERE sr.page_title = bs.page_title AND sh.page_title != sr.page_title LIMIT 100;
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...