Search for uncategorized DALL-E images

SQL

set max_statement_time = 60;
set @start_date = "20240510";

select image.img_name, page.page_id
from image
left join page on page.page_title = image.img_name
where
	img_name in (
      select i2.img_name
      from image i2
      where
          -- No point scanning older than this
          i2.img_timestamp > @start_date and

          -- Usually DALL-E images don't have metadata
          i2.img_metadata = '{"data":{"MEDIAWIKI_EXIF_VERSION":2}}' and

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

          -- "Standard" DALL-E image resolution
          i2.img_width = 1024 and
          i2.img_height = 1024
    )
SQL

Checking query status...
