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

SQL

use cswiki_p;
select tl_from from (select * from templatelinks where tl_title like 'Commonscat' and tl_namespace like 10) t left join (select distinct * from imagelinks group by il_from) i on t.tl_from=i.il_from where i.il_to is NULL limit 10;
#select page_namespace, page_title from (select * from page where not page_is_redirect and page_id in (select tl_from from templatelinks where tl_title like 'Commonscat' and tl_namespace like 10)) as pp left join imagelinks on pp.page_id=il_from where il_to is NULL limit 10;

SQL

Checking query status...