Možné údržbové seznamy nebo stránky WP k opravě

Fork of Templates with Doc template and no subpage by Martin Urbanec

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

SQL

use cswiki_p;
select * from page left join templatelinks on page_title=tl_title and page_namespace=tl_namespace where tl_title is NULL/*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 like 'Kalendář%'/*později smazat*/
and not page_id in (select cl_from from categorylinks where cl_to like 'Šablony:Substituované');

SQL

Checking query status...