select concat('[[', localpage.page_title, ']]'), group_concat(distinct(concat('[[:en:File:', il_to,

   '|', il_to, ']]')) SEPARATOR ' '), group_concat(distinct(encl.cl_to) SEPARATOR ' ')

from categorylinks noimage

inner join page localpage on localpage.page_id=noimage.cl_from

inner join langlinks on localpage.page_id=ll_from

inner join enwiki_p.page enpage on enpage.page_title=replace(ll_title,' ', '_') and

     enpage.page_namespace=0

inner join enwiki_p.imagelinks on il_from=enpage.page_id

left join enwiki_p.page enimg on enimg.page_title = il_to and enimg.page_namespace=6

left join enwiki_p.categorylinks encl on encl.cl_from=enimg.page_id and encl.cl_to not like

        'Files_with_no%'

where localpage.page_namespace=0

and noimage.cl_to='ערכים_בלי_תמונה' /* no image category */

and ll_lang='en'

and not exists

(select count(*) from enwiki_p.imagelinks imgusage

 where imgusage.il_to=imagelinks.il_to

 group by il_to having count(*) > 10)

group by localpage.page_title

​