Untitled query #61264

SQL

# all links from painting cat to any other page
#INNER join (select page_id, page_title from page where page_namespace = 14 AND lower(page_title) like "%painting%") as painting_cat
#	ON painting_cat.page_id = pl.pl_from
select i.img_name as painting_file, cl.cl_to, cl.*
from image as i
inner join page as p on p.page_title = i.img_name
right join categorylinks as cl on cl.cl_from = p.page_id
left join page as pp on p.page_title = cl.cl_to
where i.img_name = "Twodrawingsintheskytwopaintingsunderneathubahnstationdonaumarina.JPG"
limit 100
SQL

Checking query status...
