Untitled query #1591

SQL

use hewiki_p;
select concat('[[', localpage.page_title, ']]'), group_concat(distinct(concat('[[:he:קובץ:', 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
SQL

Checking query status...
