extracting article images published in 2024

SQL

SELECT DISTINCT
    CONCAT(
        'https://commons.wikimedia.org/wiki/File:',
        img_name
    ) AS image_url,
    img_name AS image_file,
    globalimagelinks.gil_page_title AS article
FROM 
    page Pa
JOIN 
    imagelinks ON il_from = Pa.page_id
JOIN 
    image ON img_name = il_to 
    AND img_name != "Blank.png"
JOIN 
    globalimagelinks ON globalimagelinks.gil_to = img_name
WHERE 
    img_timestamp >= '2024-01-01 00:00:00' 
    AND img_timestamp < '2025-01-01 00:00:00'
    AND img_name NOT LIKE '%.svg'
    AND img_name NOT LIKE '%.pdf'
    AND il_to IS NOT NULL
LIMIT 8000;

SQL

Checking query status...