Images by EXIF camera model

This query is marked as a draft This query has been published by Waldyrious.

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 IS 'Waldyrious'
LIMIT 1000;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...