Fork of
fix categories old
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
x
SELECT /* SLOW_OK */ page_title ,page_namespace FROM page JOIN categorylinks JOIN langlinks
WHERE lower(cl_to) = "yemen"
#"Yemen"
AND cl_from=page_id AND page_id =ll_from AND 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.