Search for uncategorized DALL-E images

SQL

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

declare @candidates table (img_name BINARY(255));

insert into @candidates (img_name)
  select img_name
  from image
  where
      -- No point scanning older than this
      img_timestamp > @start_date and

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

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

      -- "Standard" DALL-E image resolution
      img_width = 1024 and
      img_height = 1024
;

select img_name
from image
left join globalimagelinks on globalimagelinks.gil_page_title = image.img_name
where
	img_name in @candidates
having
	count(globalimagelinks.gil_page_title) = 0;
SQL

Checking query status...
