Untitled query #11083

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 creator, page file
join categorylinks as p1 on p1.cl_from = creator.page_id 
join categorylinks as p2 on p2.cl_from =    file.page_id and p1.cl_to = p2.cl_to
JOIN categorylinks AS c1 ON c1.cl_from = file.page_id AND c1.cl_to = 'Photographs_of_paintings_by_User:Sailko_without_Creator_template'
WHERE file.page_namespace = 6 and creator.page_namespace = 100
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...