Wikimedia Bugzilla is closed!

Cloned from bug #57697, comment #10:

| MariaDB [commonswiki_p]> SELECT * FROM image WHERE img_sha1 = 'qtexhtbcwt0tnkuxb2wf3xs7d7j761u' LIMIT 0, 1000;
| +-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| | img_name                    | img_size | img_width | img_height | img_metadata                             | img_bits | img_media_type | img_major_mime | img_minor_mime | img_description                                      | img_user | img_user_text | img_timestamp  | img_sha1                        |
| +-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| | !!!!古市公威像0103.JPG      |   492465 |      1536 |       1024 | a:1:{s:22:"MEDIAWIKI_EXIF_VERSION";i:2;} |        8 | BITMAP         | image          | jpeg           | Ich machte dieses Foto von mir in 2006.{{GFDL-self}} |    81053 | Tokyo Watcher | 20070305091405 | qtexhtbcwt0tnkuxb2wf3xs7d7j761u |
| +-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| 1 row in set (0.00 sec)

| MariaDB [commonswiki_p]> SELECT * FROM oldimage WHERE oi_sha1 = '0mpoldytyxspxrdbf44r1kc7m8vtbq67' LIMIT 0, 1000;
| Empty set (0.00 sec)

| MariaDB [commonswiki_p]> SELECT * FROM filearchive WHERE fa_sha1 = '0mpoldytyxspxrdbf44r1kc7m8vtbq67' LIMIT 0, 1000;
| +-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| | fa_id | fa_name               | fa_archive_name | fa_storage_group | fa_storage_key | fa_deleted_user | fa_deleted_timestamp | fa_deleted_reason | fa_size | fa_width | fa_height | fa_metadata | fa_bits | fa_media_type | fa_major_mime | fa_minor_mime | fa_description                                                                                                                                                      | fa_user | fa_user_text | fa_timestamp   | fa_deleted | fa_sha1                          |
| +-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| |     8 | Perreo-logo-black.jpg | NULL            | deleted          |           NULL |             123 | 20060616034833       | logo              |   26447 |      400 |       194 | 0           |       8 | BITMAP        | image         | jpeg          | {{Information
| |Description= Logo for PerreoRadio.com
| |Source= http://www.PerreoRadio.com
| |Date= 6/12/2006
| |Author= PerreoRadio.com
| |Permission=
| |other_versions=
| }} |   47161 | Ameno13      | 20060612221349 |          0 | 0mpoldytyxspxrdbf44r1kc7m8vtbq67 |
| +-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| 1 row in set (4.94 sec)

| MariaDB [commonswiki_p]>