SQL
x
SELECT CONCAT (
"[[:en:",
page_title,
"]]||",
count(*)
)
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 = "National_sports_teams_of_Oman")
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.