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

SQL

AخA
 
SELECT
    maincat.page_title AS maincat_title,
    img_img.img_name AS img_name,
    catlink1.cl_from AS file_id,
    img_img.img_timestamp,
    actor.actor_name AS uploader,
    oldimage_uploader.actor_name AS uploader_old
FROM
  page AS maincat
INNER JOIN categorylinks AS catlink0 ON catlink0.cl_from = maincat.page_id
INNER JOIN categorylinks AS catlink1 ON catlink1.cl_to = maincat.page_title
INNER JOIN page AS img_file ON img_file.page_id = catlink1.cl_from
INNER JOIN image AS img_img ON img_img.img_name = img_file.page_title
INNER JOIN actor ON actor.actor_id = img_img.img_actor
LEFT JOIN oldimage ON img_img.img_name = oldimage.oi_name
LEFT JOIN actor AS oldimage_uploader ON oldimage.oi_actor = oldimage_uploader.actor_id
WHERE
    catlink0.cl_to = "Images_from_Wiki_Loves_Monuments" AND
    catlink0.cl_type = "subcat" AND
  catlink1.cl_to = "Images_from_Wiki_Loves_Monuments_2010" AND
    catlink1.cl_type = "file"
LIMIT 3000000
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...