SQL
x
select DISTINCT
CONCAT('# [[:تصنيف:', p1.page_title, ']]>') AS cat1
from page AS p1
where p1.page_namespace = 14
and
p1.page_title REGEXP "^أفلام_[^\|]+_عقد_\\d+$" # (2116 rows)
p1.page_title not REGEXP "^أفلام_[^\|]+_في_عقد_\\d+$" # (1272 rows)
and p1.page_id not in (select cl_from from categorylinks where cl_to = "تحويلات_تصنيفات_ويكيبيديا" )
;
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.