~ - Quarry

SQL

use cswiki_p;
select concat('Šablona:', replace(page_title, '_', ' ')), pocet_vyskytu from page left join (select tl_namespace, tl_title, count(*) as pocet_vyskytu from templatelinks left join page on tl_from=page_id and tl_from_namespace=page_namespace where page_title not like tl_title and concat(page_title, '/doc') not like tl_title group by tl_title) as tabulka_poctu on page_title=tl_title and page_namespace=tl_namespace where pocet_vyskytu < 4/*pro 1 a více výskytů upravit podle https://quarry.wmflabs.org/query/17945*/
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é');
SQL

Checking query status...
