Untitled query #76427

SQL

    select
        CONCAT(replace(page_title, '_', ' ')) AS t
    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   "^([^0-9]*)\\s*_حسب_\\s*([^0-9]*)_في_\\s*(القرن_|عقد_|)\\s*(\\d+_ق_م|\\d+_ق\\.م|\\d+)$"
    )
    AND page_title NOT REGEXP "^(\\d+_ق_م|\\d+_ق\\.م|\\d+)\\s*_في_الأفلام$"
    AND page_title NOT REGEXP "^.*?_في_.*?_في_.*?$"

    limit 500
    offset 0
    ;
SQL

Checking query status...
