Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
WikiProject Climate change articles not in jawiki
by
Cryptic
This query is marked as a draft
This query has been published
by
Clayoquot
.
Main-namespace pages whose talk pages are in [[Category:WikiProject Climate change articles]] that don't have an interwiki link to ja, along with the number of interwiki links they *do* have. For [[WP:RAQ#Articles that are missing in another language]] circa 16 July 2024
Toggle Highlighting
SQL
SELECT article.page_title, COUNT(*) AS 'number of interwikis' FROM categorylinks JOIN page AS talk ON talk.page_namespace = 1 AND talk.page_id = cl_from JOIN page AS article ON article.page_namespace = 0 AND article.page_title = talk.page_title LEFT JOIN langlinks AS ja ON ja.ll_from = article.page_id AND ll_lang = 'ja' LEFT JOIN langlinks AS all_langs ON all_langs.ll_from = article.page_id WHERE cl_to = 'WikiProject_Climate_change_articles' AND ja.ll_title IS NULL GROUP BY article.page_id ORDER BY 'number of interwikis';
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...