Search for uncategorized DALL-E images

SQL

set statement max_statement_time = 60 for
select distinct page_title
from page
left join categorylinks on page.page_id = categorylinks.cl_from
inner join image on page.page_title = image.img_name
where
	-- No point scanning older than this
	image.img_timestamp > "20230101" and

	-- Uncategorized
	categorylinks.cl_to like "Uncategorized%" and

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

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

	-- "Standard" DALL-E image resolution
	image.img_width = 1024 and
    image.img_height = 1024
group by image.img_name
SQL

Checking query status...
