Images by EXIF camera model

This query aims to identify images that were taken with a given camera model but were not added to the corresponding category.

SQL

SELECT
    actor.actor_name AS username, 
    page.page_title, 
    page.page_namespace
FROM 
    image 
LEFT JOIN 
    categorylinks 
ON 
    img_name = cl_from 
AND 
    cl_to = 'Taken_with_Google_Pixel_4a'
JOIN 
    page 
ON 
    page.page_title = img_name 
AND 
    page.page_namespace = 6  -- 6 is the namespace for files
JOIN 
    actor 
ON 
    image.img_actor = actor.actor_id
WHERE 
    img_metadata LIKE '%"Pixel 4a"%' 
    AND 
    cl_from IS NULL
    AND 
    actor.actor_name NOT IN ('FakirNL', 'Donald Trung', 'Bärbel Miemietz', 'TaurusEmerald', 'The wub', 'Tim Rademacher', 'GeomapCastro', 'Vinayaraj')  -- Usernames to exclude
LIMIT 1000;

SQL

Checking query status...