USE plwiki_p;

SELECT CONCAT('# [[:Kategoria:',cl_to,'|Kategoria:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to

FROM page, categorylinks

WHERE page_id = cl_from

AND page_namespace = 0

AND cl_to NOT LIKE 'Polacy_odznaczeni_francuskim_Krzyżem_Wojennym'

AND cl_to NOT LIKE 'Majorzy_II_Rzeczypospolitej'

AND cl_to NOT LIKE 'Szemborowo'

AND NOT EXISTS

(SELECT * FROM page AS p1

WHERE cl_to = p1.page_title

AND p1.page_namespace = 14)

GROUP BY cl_to

ORDER BY count_cl_to DESC, cl_to ASC;