SQL
AخA
use cswiki_p;
select concat('Šablona:', replace(page_title, '_', ' ')) from page left join (select tl_namespace, tl_title, count(*) as pocet_vyskytu from templatelinks left join page on tl_from=page_id where concat(page_namespace, page_title) not like concat(tl_namespace, tl_title) and concat(page_namespace, page_title) not like concat(tl_namespace, tl_title, '/doc') group by tl_title) as tabulka_poctu on page_title=tl_title and page_namespace=tl_namespace where pocet_vyskytu < 2
and page_namespace like 10
and not page_title like '%/doc'
and not page_is_redirect like 1
and not page_title like 'Vyznamenat/%'
and not page_title like 'Obsahuje_KML/%'
and not page_title rlike 'Kalendář[A-ZŽŠČŘĎŤŇĚÁÉÍÓÚŮÝ].*'
and not page_title like '%KalendářZačínající%'
and not page_id in (select cl_from from categorylinks where cl_to like 'Šablony:Substituované');
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.
Query status: complete
Executed on Sat, 10 Jun 2017 09:57:33 UTC.