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
.
Tries to detect AI-generated images by DALL-E or stable-diffusion-webui
Toggle Highlighting
SQL
select img_name as 'Name', CONCAT(img_width, 'x', img_height) as 'Resolution', img_timestamp as 'Time', img_metadata as 'Metadata' from image inner join page on page.page_title = image.img_name left join geo_tags on geo_tags.gt_page_id = page.page_id where -- "Files" namespace page.page_namespace = 6 and -- Not a redirect page.page_is_redirect = 0 and -- No point scanning older than this img_timestamp > "20240101" and -- Formats ( -- DALL-E ( img_width = 1024 and img_height = 1024 and img_metadata not like '%XResolution%' and img_metadata not like '%Software%' and img_metadata not like '%gd-jpeg%' ) or -- stable-diffusion-webui ( img_metadata like "%Steps: %" and img_metadata like "%Seed: %" ) ) and -- We don't want SVGs or whatever ( img_name like '%.png' or img_name like '%.jpg' or img_name like '%.jpeg' or img_name like '%.webp' ) and -- No geotagging geo_tags.gt_lat is null and geo_tags.gt_lon is null and -- Some false positives img_name not like '%asteroid_shape_model%' and -- AI images rarely have these templates not exists ( select * from templatelinks left join linktarget on linktarget.lt_id = templatelinks.tl_target_id where templatelinks.tl_from = page.page_id and ( linktarget.lt_title like 'PD-USGov%' or linktarget.lt_title in ( 'PD-simple', 'Wikiportrait2', 'Trademark', 'Trademarked', 'Apache', 'VenezuelaGov' ) ) ) and -- Not in these categories not exists ( select * from categorylinks where cl_from = page.page_id and cl_to in ('Unidentified_logos') )
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...