Fork of
Možná nadbytečné rozcestníky
by Dvorapa
This query is marked as a draft
This query has been published
by Jan Kovář BK.
SQL
AخA
use cswiki_p;select distinct concat('Šablona:', replace(page_title, '_', ' ')) from page left join templatelinks on page_title=tl_title and page_namespace=tl_namespace where tl_title is not NULL and page_namespace like 10 and page_is_redirect like 1 and not (page_title like '%-%' and page_id in (select rd_from from redirect where rd_title like '%–%'));
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.