Untitled query #46181

SQL

use arwiki_p;
SELECT DISTINCT p1.page_title , p1.page_namespace
FROM page p1
WHERE p1.page_namespace = 0
and p1.page_is_redirect = 0
#fgh
  and (
p1.page_title rlike "^.*_\\(فيلم_.*$"
or p1.page_title rlike "^.*_\\(فيلم$"
or p1.page_title rlike "^\\(فيلم$"
or p1.page_title rlike "^\\(فيلم_.*$"
   )
and p1.page_id not in ( select pa_page_id
from page_assessments , page_assessments_projects
where pa_project_id = pap_project_id
and pap_project_title = "سينما"
and pa_page_id = p1.page_id 
                         )
                         limit 10
SQL

Checking query status...
