SQL
x
SELECT CONCAT("Category:",page_title) AS titl FROM page
WHERE page_title like "%Yemen%"
AND page_namespace = 14
AND page_id not IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" )
GROUP BY page_title limit 600;
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.