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 LIKE '%.jpg' OR 
        img_name LIKE '%.png' OR 
        img_name LIKE '%.jpeg' OR 
        img_name LIKE '%.svg'
    )
    AND il_to IS NOT NULL
    AND globalimagelinks.gil_wiki = 'en.wikipedia.org'
LIMIT 200;
SQL

Checking query status...
