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

SQL

use cswiki_p;
select page_namespace, page_title from page p join (select * from templatelinks where tl_title like 'Commonscat' and tl_namespace like 10) t on p.page_id=t.tl_from where tl_from not in (select distinct il_from from imagelinks) 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...