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

SQL

x
 
use fawiki_p;
select concat('* [[ویکیپدیا:', page_title, ']]') as page_title
from page
left join
(
  select tl_title
  from templatelinks
  join page
  on tl_from = page_id
  where tl_namespace = 4
  and page_title = 'نظرخواهی_برای_حذف'
  and page_namespace = 4
) C
on C.tl_title = page_title
left join
(
  select pl_title
  from pagelinks
  join page
  on pl_from = page_id
  where pl_namespace = 4
  and page_title like 'نظرخواهی_برای_حذف/بایگانی%'
  and page_namespace = 4
) A
on A.pl_title = page_title
where page_title like 'نظرخواهی_برای_حذف/%'
and page_title not like 'نظرخواهی_برای_حذف/بایگانی/%'
and page_title <> 'ویکیپدیا:نظرخواهی_برای_حذف/نظرخواهیهای_فراموششده'
and page_title <> 'نظرخواهی_برای_حذف/بایگانی'
and page_namespace = 4
and page_is_redirect = 0
and C.tl_title is null
and A.pl_title is null
order by page_latest desc
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...