Chess game articles with the most incoming links

A list of articles in [[Category:Chess game]] sorted from most to least popular based on the number of incoming links.

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_Chess'
  AND ja.ll_title IS NULL
GROUP BY article.page_id
ORDER BY article.page_title ASC;

SQL

Checking query status...