SQL
x
SELECT CONCAT (
"[[:en:",
page_title,
"]]||",
count(*),
"||",
page_len,
"||[[:en:",
cl_to,
"]]"
)
FROM langlinks
INNER JOIN page ON ll_from = page_id
INNER JOIN categorylinks ON page_id = cl_from
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
)
AND (cl_to = "Morocco_men's_international_footballers")
GROUP BY ll_from
ORDER BY count(*) DESC,
page_title;
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.