Wikipedie:Údržbové seznamy/Jednou použité šablony/postup

Z Wikipedie, otevřené encyklopedie

Tento seznam je možné aktualizovat výsledkem následujícího SQL dotazu:

use cswiki_p;
select page_namespace, 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/%' and not page_title rlike 'Kalendář[A-ZŽŠČŘĎŤŇĚÁÉÍÓÚŮÝ].*' order by page_title;

Ten lze provést např. vzdáleně pomocí Quarry, PAWS nebo nástroje na Toolforge, lokálně pomocí Dumpu nebo třeba využitím Pywikibota, kód pro něj by mohl vypadat např. takto:

$ python3 pwb.py listpages -put:"Wikipedie:Údržbové seznamy/Jednou použité šablony/seznam" -overwrite -format:"# [[{page.loc_title}]]" -summary:"Robot: aktualizace" -mysqlquery:"select page_namespace, 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/%' and not page_title rlike 'Kalendář[A-ZŽŠČŘĎŤŇĚÁÉÍÓÚŮÝ].*' order by page_title;"