Files_using_deprecated_object_photo_template with_Wikidata_item

SQL

USE commonswiki_p;
SELECT concat("File:",p3.page_title) as pagename
FROM page p3
#INNER JOIN categorylinks c2 on p3.page_id = c2.cl_from AND c2.cl_to = "Artworks_with_Wikidata_item"
#INNER JOIN categorylinks c3 on p3.page_id = c3.cl_from AND c3.cl_to = "Files_using_deprecated_object_photo_template"
INNER JOIN categorylinks c2 on p3.page_id = c2.cl_from AND c2.cl_to = "Artworks_missing_main_subject_for_3D_work"
#INNER JOIN categorylinks c3 on p3.page_id = c3.cl_from AND c3.cl_to = "Pages_using_Category_definition:_Object_template"
WHERE p3.page_namespace = 6

SQL

Checking query status...