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

SQL

AخA
 
use hewiki_p;
select count(*) from page
where page_namespace = 0
and exists
(select * from templatelinks
where tl_from = page_id
and exists
(select * from page as p1
where tl_title = page_title
and page_namespace = 10
and exists
(select * from categorylinks
where page_id = cl_from
and cl_to = "תבניות_עם_ניהול_פרמטרים")
and exists
(select * from page
 where page_title = concat('שגיאות_פרמטריות_בתבנית_', p1.page_title))))
#711 templates, 914245 transclusions, 311211 pages, 198796 articles
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...