Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Palemeditation
.
Toggle Highlighting
SQL
set statement max_statement_time = 60 for select img_name, img_metadata from image inner join page on page.page_title = image.img_name 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
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
.
Checking query status...