use cswiki_p;

select pl_title, count(*) from pagelinks where pl_from_namespace%2 like 0 and pl_from_namespace not like 2 and pl_from not like 661530 and pl_namespace like 10 and pl_title like 'Data_státu/%' and pl_title not in (select page_title from page where page_namespace like 10) and pl_title not like 'Data_státu/%/pískoviště' group by pl_title order by count(*) desc;