بوت:صيانة ، إزالة قالب الحماية

Fork of بوت:صيانة ، إزالة قالب الحماية by لوقا

This query is marked as a draft This query has been published by وهراني.

SQL

select page.page_title,page.page_namespace from templatelinks
inner join page on templatelinks.tl_from = page.page_id
inner join linktarget on templatelinks.tl_target_id = linktarget.lt_id
where lt_namespace = 10 and lt_title in (
 			"محمية",
            "protected",
            "حماية_خاصة",
            "حماية_نزاع",
            "pp-semi-template",
            "pp-semi-vandalism",
            "pp-dispute",
            "قفل",
            "pp-semi-protected",
            "pp-move-indef",
            "pp-protected",
            "حماية_كلية",
            "حماية_حرب",
            "حماية_جزئية",
            "pp-semi",
            "حماية كاملة",
            "حماية",
            "صفحة_محمية",
            "semi-protection",
            "pp-semi-indef",
            "شبه_محمي",
            "حماية_تخريب",
  			"محمية/تحويلة"
) and tl_from_namespace in(0)
and page_id not in (select pr_page from page_restrictions )

SQL

Checking query status...