Untitled query #71509

SQL

SELECT 
	lp.page_namespace 	AS 'linksource_ns',
	lp.page_title 		AS 'linksource',
	p.page_namespace	AS 'page_namespace',
	i.il_to				AS 'page_title',
	c.cl_to				AS 'category'
FROM imagelinks i
	LEFT JOIN page p			ON p.page_title = i.il_to
	LEFT JOIN page lp			ON lp.page_id 	= i.il_from
	LEFT JOIN categorylinks c	ON c.cl_from 	= p.page_id
WHERE
	c.cl_to IN (
		-- Get all content categories of User:Rauenstein
		SELECT p.page_title
		FROM categorylinks c 
		LEFT JOIN page p ON c.cl_from = p.page_id
		WHERE
			c.cl_to = 'Files_by_User_ivanbranco_by_content'
	)
	AND il_from IN (
		-- Get all page ids of the "Files used on Openstreetmap" galleries
		SELECT page_id
        FROM page
        WHERE
			LEFT(page_title, 15) = 'Files_used_on_O'
            AND page_namespace = 4
	)
;
SQL

Checking query status...
