Untitled query #76109

SQL

select
    CONCAT(replace(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]*)$" or
        #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
;
SQL

Checking query status...
