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#, page_title as painting_category
from image as i
#INNER JOIN (select page_id, page_title from page where page_namespace = 14 AND lower(page_title) like "%painting%" limit 2) as painting_cat
#	on painting_cat.page_id = il.il_from
where i.img_name = "Twodrawingsintheskytwopaintingsunderneathubahnstationdonaumarina.JPG"
limit 100
SQL

Checking query status...
