Untitled query #10733

This query is marked as a draft This query has been published by Jarekt.

SQL

SELECT concat("File:",file.page_title) as filename , concat("Creator:",creator.page_title) as creatorname
FROM page as file
JOIN categorylinks AS c1 ON c1.cl_from = file.page_id AND c1.cl_to = 'Photographs_of_paintings_by_User:Sailko_without_Creator_template'
JOIN categorylinks AS c3 ON c3.cl_from = file.page_id  
JOIN categorylinks AS c4 ON c4.cl_to   = c3.cl_to
join page as creator     on c4.cl_from = creator.page_id and creator.page_namespace = 100
WHERE file.page_namespace = 6
limit 10

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...