SQL
AخA
SELECT CONCAT("[[:en:",page_title,"]]"), count(*), page_len
FROM langlinks
JOIN categorylinks ON ll_from = cl_from
AND cl_to='American_films'
JOIN page on ll_from = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND NOT EXISTS (SELECT *
FROM langlinks as t
WHERE t.ll_lang="ar"
and t.ll_from = langlinks.ll_from)
GROUP BY ll_from
ORDER BY count(*) DESC,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.
All SQL code is licensed under CC0 License.