Fork of
Possible AI uploads
by Omphalographer
This query is marked as a draft
This query has been published
by Kasyap.
SQL
AخA
SELECT
img_timestamp,
CONCAT('https://commons.wikimedia.org/wiki/File:', image.img_name) AS file
FROM image
WHERE (
(img_width IN (3105, 2048, 1120, 1080, 1024, 800, 768, 720, 490) AND img_height = img_width)
OR (img_height = 1792 AND img_width = 1024) -- DallE tall
OR (img_height = 1024 AND img_width = 1792) -- DallE wide
)
AND img_media_type = 'BITMAP'
AND img_name NOT LIKE '%geograph.org.uk%' -- common false positive
AND img_name NOT LIKE '%satellite_imagery%jpg' -- another one
ORDER BY img_timestamp DESC
LIMIT 250
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.