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
Milimetric (WMF)
.
Toggle Highlighting
SQL
select convert(img_name using utf8mb4) img_name, img_size, img_width, img_height, -- Field not sqooped as it can contain more than 10Mb of data -- leading to job failure (commonswiki database only) -- convert(img_metadata using utf8mb4) img_metadata, img_bits, convert(img_media_type using utf8mb4) img_media_type, convert(img_major_mime using utf8mb4) img_major_mime, convert(img_minor_mime using utf8mb4) img_minor_mime, img_description_id, img_actor, convert(img_timestamp using utf8mb4) img_timestamp, convert(img_sha1 using utf8mb4) img_sha1 from image limit 1
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...