Images by EXIF camera model

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 ( -- Exclude prolific uploaders to avoid overloading the category with repetitive images
      'FakirNL',
      'Donald Trung',
      'Bärbel Miemietz',
      'TaurusEmerald',
      'The wub',
      'Tim Rademacher',
      'GeomapCastro',
      'Vinayaraj',
      'GeographBot',
      'Saint Germinais',
      'Shonagon',
      'Artaxerxes',
      'Artvill',
      'Back ache',
      'Ser Amantio di Nicolao',
      'RAJENDRANTM',
      'Iwaqarhashmi',
      'SunOfErat',
      'Andy Dufresne & Red',
      'Paul Hermans',
      'Lome2023',
      'Newbert12',
      'Hullian111-Flickr2Commons',
      'Miklogfeather',
      'DutchTreat',
      'Rosty',
      'Oxyman'      
    )
LIMIT 5000;
SQL

Checking query status...
