SQL
AخA
USE enwiki_p;
SELECT cl_to, COUNT(cl_from)
FROM categorylinks
WHERE cl_from IN (
SELECT DISTINCT ll_from
FROM langlinks
WHERE ll_lang = "ar"
)
AND cl_to NOT IN (
SELECT DISTINCT page_title
FROM langlinks
LEFT JOIN page ON page_id = ll_from
WHERE ll_lang = "ar"
AND page_namespace = 14
)
AND cl_to LIKE'%stablishments_in_%'
GROUP BY cl_to
ORDER BY COUNT(cl_from) DESC LIMIT 1000;
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.