WikiProject Climate change articles not in jawiki

Fork of WikiProject Climate change articles not in jawiki by Cryptic

This query is marked as a draft This query has been published by ᱤᱧ ᱢᱟᱛᱟᱞ.

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

SQL

SELECT article.page_title, COUNT(all_langs.ll_from) 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 article.page_title ASC;

SQL

Checking query status...