Untitled query #61262

SQL

#SELECT cl.cl_from
#FROM category AS c
#FROM categorylinks AS cl
#INNER JOIN page AS p ON p.page_title = g.gil_to
#INNER JOIN categorylinks as c ON c.cl_from = p.page_id
#WHERE p.page_is_redirect = 0
#where c.cat_title="Ischl_paintings_by_Ferdinand_Georg_Waldmüller" #cat_id=153674454
#where cl.cl_to="Ischl_paintings_by_Ferdinand_Georg_Waldmüller"
#limit 10

select il.*, p.page_title, i.*
from imagelinks as il
inner join page as p on p.page_id = il.il_from
inner join categorylinks as cl on cl.cl_from = p.page_id
inner join image as i on i.img_name = p.page_title
where cl.cl_to="Ischl_paintings_by_Ferdinand_Georg_Waldmüller"
and i.img_width >= 512 and i.img_height >=512
limit 100
SQL

Checking query status...
