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') and concat(page_namespace, page_title) not like '4Šablony/%' group by tl_namespace, tl_title) as tabulka_vyskytu on page_namespace=tl_namespace and page_title=tl_title where
page_namespace like 10
and not page_is_redirect
and pocet_vyskytu like 1
and not page_title like 'Vyznamenat/%'
and not page_title rlike 'Kalendář[A-ZŽŠČŘĎŤŇĚÁÉÍÓÚŮÝ].*';
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.