SQL
AخA
SELECT /* SLOW_OK */ page_title , page_namespace FROM page JOIN categorylinks# JOIN langlinks
WHERE cl_to = "%s" AND cl_from = page_id #AND page_id =ll_from AND ll_lang = "ar"
AND cl_to not IN (
SELECT p.page_title FROM page p
WHERE p.page_namespace = 14
AND p.page_id IN (
SELECT ll_from
FROM langlinks
WHERE ll_lang = "ar"
))
GROUP BY 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.