WikiProject Climate change articles not in jawiki

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;

AخA
 
SELECT article.page_title, COUNT(all_langs.ll_from) AS 'number of interwikis'FROM categorylinksJOIN page AS talk ON talk.page_namespace = 1 AND talk.page_id = cl_fromJOIN page AS article ON article.page_namespace = 0 AND article.page_title = talk.page_titleLEFT 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_idWHERE cl_to = 'WikiProject_Climate_change_articles'  AND ja.ll_title IS NULLGROUP BY article.page_idORDER BY article.page_title ASC;

SQL

Checking query status...