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

SQL

-- Query to get original upload date from the image and oldimage tables
SELECT 
    CONCAT("# [[:File:", COALESCE(oi_name, page_title), "]]") as File, 
    COALESCE(MIN(oi_timestamp), MIN(img_timestamp)) as original_upload_date
FROM 
    page
LEFT JOIN 
    oldimage ON page.page_title = oi_name AND page.page_namespace = 6 AND oi_deleted = 0
LEFT JOIN 
    image ON page.page_title = img_name AND page_namespace = 6
JOIN 
    templatelinks ON tl_from = page_id
JOIN 
    actor_image ON img_actor = actor_id
JOIN 
    categorylinks ON cl_from = page_id
    AND cl_type = "file"
    AND cl_to = "GFDL-Bild"
WHERE 
    oi_name IS NOT NULL  -- This line ensures only files with old versions are included
GROUP BY 
    page_title, oi_name;

SQL

Checking query status...