USE trwiki_p;

​

select concat("tr.wikipedia.org/wiki?curid=",pd.page_id), count(*) as ec, image.*

from image join imagelinks on il_to = img_name

join page pd on page_title = img_name

​

where pd.page_namespace = 6 and pd.page_id not in (select cl_from from categorylinks where cl_to rlike "t.m adil"

                                             )

 and il_from_namespace = 0

 group by pd.page_id having ec>5

​

order by ec desc 

​

;