Untitled query #53351

SQL

use fawiki_p;
select
  p1.page_title,
  a1.actor_name,
  r1.rev_timestamp,
  REPLACE(REPLACE(REPLACE(REPLACE(p1.page_title, 'نظرخواهی_برای_حذف/', ''),  '_(بار_دوم)', ''), '_(دومین_نامزدی)', ''), '_(دومین_نظرخواهی)', '') as target_article,
  a2.actor_name as article_creator
from page p1
join revision r1
  on r1.rev_page = p1.page_id
  and r1.rev_parent_id = 0
join actor as a1
  on r1.rev_actor = a1.actor_id
  and a1.actor_name in (
    'Pirhayati',
    'Salarabdolmohamadian'
  )
left join page p2
  on p2.page_title = REPLACE(REPLACE(REPLACE(REPLACE(p1.page_title, 'نظرخواهی_برای_حذف/', ''),  '_(بار_دوم)', ''), '_(دومین_نامزدی)', ''), '_(دومین_نظرخواهی)', '')
  and p2.page_namespace = 0
left join revision r2
  on r2.rev_page = p2.page_id
  and r2.rev_parent_id = 0
left join actor a2
  on r2.rev_actor = a2.actor_id
where
  p1.page_namespace = 4
  and p1.page_title like 'نظرخواهی_برای_حذف/%'
  and p1.page_title not like '%:%'
SQL

Checking query status...
