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 il.cl_from, il.il_to as painting_file, page_title as painting_category
from imagelinks as il
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
limit 100
SQL

Checking query status...
