Search for uncategorized DALL-E images

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

SQL

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

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

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...