Medailisté, vítězové, možné problémy

SQL

use cswiki_p;
/*select concat('Kategorie:', replace(cl_to, '_', ' ')) from categorylinks where cl_to rlike '[Šš]ablon' and not cl_to like '%avigační%' and not cl_to like '%ásti%' and not cl_to like '%:_%' and not cl_to like '%_–_%' and not cl_to like '%_-_%' group by cl_to order by count(cl_from) desc;*/

/*select (select distinct cl_to from categorylinks where cl_from in (select page_id from page where page_namespace like 10 and (page_title like "Infobox_%" or page_title like "Taxobox"))).column - (select distinct cl_to from categorylinks where cl_from not in (select page_id from page where page_namespace like 10 and (page_title like "Infobox_%" or page_title like "Taxobox"))).column;*/

SELECT DISTINCT result1.cl_to
FROM (select distinct cl_to from categorylinks where cl_from in (select page_id from page where (page_namespace like 10 and (page_title like "Infobox_%" or page_title like "Taxobox") or page_namespace like 14))) as result1 LEFT JOIN (select distinct cl_to from categorylinks where cl_from not in (select page_id from page where (page_namespace like 10 and (page_title like "Infobox_%" or page_title like "Taxobox") or page_namespace like 14))) as result2 ON result1.cl_to = result2.cl_to
WHERE result2.cl_to IS NULL and result1.cl_to not like "Infoboxy_%" and result1.cl_to not like "%_infoboxy"
SQL

Checking query status...
