AI Image Detector 2000

SQL

select
  img_name as 'Name',
  CONCAT(img_width, 'x', img_height) as 'Resolution',
  img_timestamp as 'Time',
  img_metadata as 'Metadata'
from image
inner join page on page.page_title = image.img_name
left join geo_tags on geo_tags.gt_page_id = page.page_id
where
  -- "Files" namespace
  page.page_namespace = 6 and

  -- Not a redirect
  page.page_is_redirect = 0 and

  -- No point scanning older than this
  img_timestamp > "20240101" and

  -- Formats
  (
    -- DALL-E
    (
      img_width = 1024 and
      img_height = 1024 and
      img_metadata not like '%XResolution%' and
      img_metadata not like '%Software%' and
      img_metadata not like '%gd-jpeg%' and
      img_metadata not like '%Lavc%'
    ) or
    
    -- stable-diffusion-webui
    (
      img_metadata like "%Steps: %" and
      img_metadata like "%Seed: %"
    )
  ) and

  -- We don't want SVGs or whatever
  (
    img_name like '%.png' or
    img_name like '%.jpg' or
    img_name like '%.jpeg' or
    img_name like '%.webp'
  ) and


  -- No geotagging
  geo_tags.gt_lat is null and
  geo_tags.gt_lon is null and

  -- Some false positives
  img_name not like '%asteroid_shape_model%' and

  -- AI images rarely have these templates
  not exists (
    select *
    from templatelinks
    left join linktarget on linktarget.lt_id = templatelinks.tl_target_id
    where
      templatelinks.tl_from = page.page_id and (
        linktarget.lt_title like 'PD-USGov%' or
        linktarget.lt_title like 'PD-IDGov%' or
        linktarget.lt_title in (
          'PD-simple',
          'Wikiportrait2',
          'Trademark',
          'Trademarked',
          'Apache',
          'VenezuelaGov'
        )
      )
  ) and
  
  -- Not in these categories
  not exists (
    select *
    from categorylinks
    where
      cl_from = page.page_id and (
        cl_to like 'NGC_%' or
        cl_to in (
          'Unidentified_logos'
        )
      )
  )
SQL

Checking query status...
