Search for uncategorized DALL-E images

SQL

set statement max_statement_time = 60 for
select img_name, img_metadata
from page
inner join image on image.img_name = page.page_title
left join globalimagelinks on globalimagelinks.gil_page = page.page_id
where
	-- No point scanning older than this
	img_timestamp > "20240510" 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
group by img_name
having count(globalimagelinks.gil_page_title) = 0
SQL

Checking query status...
