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.