This query is marked as a draft This query has been published by Mr. Ibrahem.

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.

Checking query status...