de.wikibooks old+new+uploader image GFDL files by upload date in cat

SQL

-- Query to get original upload date from the image table
SELECT CONCAT("# [[:File:", page_title, "]]") as File, MIN(img_timestamp) as original_upload_date, actor_name
FROM templatelinks
JOIN page ON tl_from = page_id
JOIN image ON img_name = page_title AND page_namespace = 6
JOIN actor_image ON img_actor = actor_id
JOIN categorylinks ON cl_from = page_id
AND cl_type = "file"
AND cl_to = "GFDL-Bild"
GROUP BY page_title#, actor_name

UNION ALL

-- Query to get information from the oldimage table
SELECT CONCAT("# [[:File:", oi_name, "]]") as File, MIN(oi_timestamp) as original_upload_date#, actor_name
FROM oldimage
INNER JOIN page p ON p.page_title = oi_name AND p.page_namespace = 6
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = "GFDL-Bild" -- Non-free files
-- INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = "सभी_मुक्त_मीडिया" -- Free files
WHERE oi_deleted = 0
GROUP BY oi_name#, actor_name;
SQL

Checking query status...
