SQL
x
select
CONCAT('تصنيف:', page_title) AS t,
CONCAT( 'تصنيف:',
SUBSTRING_INDEX(page_title, '_في_', -1),
'_في_',
SUBSTRING_INDEX(page_title, '_في_', 1)
) AS u
FROM
page
where
page_namespace = 14
and page_id not in (select tl_from
from templatelinks, linktarget
where lt_namespace = 10 and tl_target_id = lt_id
and lt_title = "تحويل_تصنيف")
AND (
#page_title REGEXP "^الألفية_(\\d+_ق_م|\\d+)_في_([^0-9]*)$"
#881
#page_title REGEXP "^القرن_(\\d+_ق_م|\\d+)_في_([^0-9]*)$"
#4182
page_title REGEXP "^عقد_(\\d+_ق_م|\\d+)_في_([^0-9]*)$"
# 11386
#page_title REGEXP "^(\\d+_ق_م|\\d+)_في_([^0-9]*)$"
# 41451
)
and page_title NOT REGEXP "^(\\d+_ق_م|\\d+)_في_الأفلام$"
and page_title NOT REGEXP "^.*?_في_.*?_في_.*?$"
limit 100
offset 0
;
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.