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

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 '%/doc'
and not page_title like 'Vyznamenat/%';
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...