Untitled query #61263

SQL

select 
	substring(md5(i.img_name), 1,1) as part1,
	substring(md5(i.img_name), 1,2) as part2,
    i.img_width,
    i.img_height,
    i.img_size,
    cl.cl_to,
    cl2.*,
    p.*
from page as p
inner join categorylinks as cl on cl.cl_from = p.page_id
inner join image as i on i.img_name = p.page_title
left join (select cl_from, cl_to FROM categorylinks) as cl2 on cl2.cl_from = cl.cl_to
where cl.cl_to="Ischl_paintings_by_Ferdinand_Georg_Waldmüller"
and i.img_width >= 512 and i.img_height >=512 and img_size < 100000000
limit 100
SQL

Checking query status...
