[zilla]> DESCRIBE photo;
+--------------+---------------------+------+-----+---------------------+----------------+
| Field        | Type                | Null | Key | Default             | Extra          |
+--------------+---------------------+------+-----+---------------------+----------------+
| id           | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| aid          | int(10) unsigned    | NO   | MUL | 0                   |                |
| uid          | int(10) unsigned    | NO   | MUL | 0                   |                |
| xchan        | char(255)           | NO   | MUL |                     |                |
| resource_id  | char(255)           | NO   | MUL |                     |                |
| created      | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| edited       | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| title        | char(255)           | NO   |     |                     |                |
| description  | text                | NO   |     | NULL                |                |
| album        | char(255)           | NO   | MUL |                     |                |
| filename     | char(255)           | NO   |     |                     |                |
| mimetype     | char(128)           | NO   | MUL | image/jpeg          |                |
| height       | smallint(6)         | NO   |     | 0                   |                |
| width        | smallint(6)         | NO   |     | 0                   |                |
| filesize     | int(10) unsigned    | NO   | MUL | 0                   |                |
| content      | mediumblob          | NO   |     | NULL                |                |
| imgscale     | tinyint(3) unsigned | NO   | MUL | 0                   |                |
| photo_usage  | smallint(6)         | NO   | MUL | 0                   |                |
| profile      | tinyint(1)          | NO   | MUL | 0                   |                |
| is_nsfw      | tinyint(1)          | NO   | MUL | 0                   |                |
| os_storage   | tinyint(1)          | NO   | MUL | 0                   |                |
| os_path      | mediumtext          | NO   |     | NULL                |                |
| display_path | mediumtext          | NO   |     | NULL                |                |
| photo_flags  | int(10) unsigned    | NO   | MUL | 0                   |                |
| allow_cid    | mediumtext          | NO   |     | NULL                |                |
| allow_gid    | mediumtext          | NO   |     | NULL                |                |
| deny_cid     | mediumtext          | NO   |     | NULL                |                |
| deny_gid     | mediumtext          | NO   |     | NULL                |                |
| expires      | datetime            | NO   | MUL | 0001-01-01 00:00:00 |                |
+--------------+---------------------+------+-----+---------------------+----------------+
29 rows in set (0.001 sec)


[zilla]> SELECT COUNT(id) FROM photo;
+-----------+
| COUNT(id) |
+-----------+
|    127068 |
+-----------+


[zilla]> SELECT COUNT(id) FROM photo WHERE os_storage=1;
+-----------+
| COUNT(id) |
+-----------+
|      1439 |
+-----------+
1 row in set (0.035 sec)


> SELECT os_path FROM photo WHERE album='Art';
+-----------------------------------------------------------------------------------------------------------------------------------+
| os_path                                                                                                                           |
+-----------------------------------------------------------------------------------------------------------------------------------+
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/39275c952af7850f7bbc35739f323db78f42c6455c9cd92f7d81a43c4bbfbbf9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/39275c952af7850f7bbc35739f323db78f42c6455c9cd92f7d81a43c4bbfbbf9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/ee1c20491e8f0973b2404e9b2e7662a64c3adf11d734f9748e5dd179829d3ff9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/39275c952af7850f7bbc35739f323db78f42c6455c9cd92f7d81a43c4bbfbbf9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/ee1c20491e8f0973b2404e9b2e7662a64c3adf11d734f9748e5dd179829d3ff9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/39275c952af7850f7bbc35739f323db78f42c6455c9cd92f7d81a43c4bbfbbf9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/ee1c20491e8f0973b2404e9b2e7662a64c3adf11d734f9748e5dd179829d3ff9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/ee1c20491e8f0973b2404e9b2e7662a64c3adf11d734f9748e5dd179829d3ff9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/4969f88aa6852f94605db1a0e28927fd45d9fa03ae4a1427bc1072d9e11df778 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d4804d796a2c42ddbe9da99172f838c2a11083b2fd7c3f0a40aaee9d851ca474 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1da8c42e2758ffc19ac066a9682a285a675ba296324252d67a0a98d9d73555b8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/4969f88aa6852f94605db1a0e28927fd45d9fa03ae4a1427bc1072d9e11df778 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a2f8b8e83861b1f9382cee6481c2638666d9391ec8cd4917d1d0ac26930ae77f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d4804d796a2c42ddbe9da99172f838c2a11083b2fd7c3f0a40aaee9d851ca474 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1da8c42e2758ffc19ac066a9682a285a675ba296324252d67a0a98d9d73555b8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a2f8b8e83861b1f9382cee6481c2638666d9391ec8cd4917d1d0ac26930ae77f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/4969f88aa6852f94605db1a0e28927fd45d9fa03ae4a1427bc1072d9e11df778 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/4969f88aa6852f94605db1a0e28927fd45d9fa03ae4a1427bc1072d9e11df778 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a2f8b8e83861b1f9382cee6481c2638666d9391ec8cd4917d1d0ac26930ae77f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d4804d796a2c42ddbe9da99172f838c2a11083b2fd7c3f0a40aaee9d851ca474 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1da8c42e2758ffc19ac066a9682a285a675ba296324252d67a0a98d9d73555b8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d4804d796a2c42ddbe9da99172f838c2a11083b2fd7c3f0a40aaee9d851ca474 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1da8c42e2758ffc19ac066a9682a285a675ba296324252d67a0a98d9d73555b8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d346df6e1546cb5b7da7f8c35f4e6e872524d037c59be73b368539dea44fea6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/71296dd15427990a9fd447e783567f412bbab50ead7a97a20743992778125bc9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a8812ecac804d090bedae15ce374068bae069541428e86ad83663790a7f6d78b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a2f8b8e83861b1f9382cee6481c2638666d9391ec8cd4917d1d0ac26930ae77f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/71296dd15427990a9fd447e783567f412bbab50ead7a97a20743992778125bc9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d346df6e1546cb5b7da7f8c35f4e6e872524d037c59be73b368539dea44fea6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a8812ecac804d090bedae15ce374068bae069541428e86ad83663790a7f6d78b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/71296dd15427990a9fd447e783567f412bbab50ead7a97a20743992778125bc9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d346df6e1546cb5b7da7f8c35f4e6e872524d037c59be73b368539dea44fea6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a8812ecac804d090bedae15ce374068bae069541428e86ad83663790a7f6d78b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/21417e3f12507ed4fc125d0dabdea514c10612cfcf680f94d2ad7412a26d61c1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d346df6e1546cb5b7da7f8c35f4e6e872524d037c59be73b368539dea44fea6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/21417e3f12507ed4fc125d0dabdea514c10612cfcf680f94d2ad7412a26d61c1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/21417e3f12507ed4fc125d0dabdea514c10612cfcf680f94d2ad7412a26d61c1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/84a9186282dde84448db7d5889f15a723cac81854b39c60e0675c12a48aebd31 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/84a9186282dde84448db7d5889f15a723cac81854b39c60e0675c12a48aebd31 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/71296dd15427990a9fd447e783567f412bbab50ead7a97a20743992778125bc9 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a8812ecac804d090bedae15ce374068bae069541428e86ad83663790a7f6d78b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b7531d1f7de421964d29806d663a63de4a9d0fdf04c06e9d16a96cb5399792b1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/21417e3f12507ed4fc125d0dabdea514c10612cfcf680f94d2ad7412a26d61c1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/84a9186282dde84448db7d5889f15a723cac81854b39c60e0675c12a48aebd31 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b7531d1f7de421964d29806d663a63de4a9d0fdf04c06e9d16a96cb5399792b1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/84a9186282dde84448db7d5889f15a723cac81854b39c60e0675c12a48aebd31 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b7531d1f7de421964d29806d663a63de4a9d0fdf04c06e9d16a96cb5399792b1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f6424a00dc3b5b61a7da2758de43a1351d67cb25794d33ab8189cce989ade6b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b7531d1f7de421964d29806d663a63de4a9d0fdf04c06e9d16a96cb5399792b1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/41cd09fa495512dcf23a2c1eb3be1a2e294d12d2eeeb12eff603931f4b477d50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f4e143558a22c401cf80a79f13b830468e4be6388c433968ce2205de395b635 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f6424a00dc3b5b61a7da2758de43a1351d67cb25794d33ab8189cce989ade6b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/e5e0c24a9e08f7f821cb3954d32241454974c5c86d2f368f21e1a33307c152e2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/41cd09fa495512dcf23a2c1eb3be1a2e294d12d2eeeb12eff603931f4b477d50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f6424a00dc3b5b61a7da2758de43a1351d67cb25794d33ab8189cce989ade6b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f4e143558a22c401cf80a79f13b830468e4be6388c433968ce2205de395b635 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f6424a00dc3b5b61a7da2758de43a1351d67cb25794d33ab8189cce989ade6b |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/41cd09fa495512dcf23a2c1eb3be1a2e294d12d2eeeb12eff603931f4b477d50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/41cd09fa495512dcf23a2c1eb3be1a2e294d12d2eeeb12eff603931f4b477d50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/e5e0c24a9e08f7f821cb3954d32241454974c5c86d2f368f21e1a33307c152e2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/aa426506f84a84e0c34129be1051b91254b4caaab14d170262a0a4658fa7b71e |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1e27b6c722ff5fd23844d5b41cdc9fc002cbc706c45c0343127a77a156f6f84d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f4e143558a22c401cf80a79f13b830468e4be6388c433968ce2205de395b635 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/e5e0c24a9e08f7f821cb3954d32241454974c5c86d2f368f21e1a33307c152e2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1e27b6c722ff5fd23844d5b41cdc9fc002cbc706c45c0343127a77a156f6f84d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/e5e0c24a9e08f7f821cb3954d32241454974c5c86d2f368f21e1a33307c152e2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9f4e143558a22c401cf80a79f13b830468e4be6388c433968ce2205de395b635 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/325e07345bae8f8b2bda8e3d19cfcad1e907cc0d5f6bb2576a55c8d809ba67fc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/acd586cda4efdc03084317b6381391511fdef5c647310f5493a94fca88388de3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/acd586cda4efdc03084317b6381391511fdef5c647310f5493a94fca88388de3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1e27b6c722ff5fd23844d5b41cdc9fc002cbc706c45c0343127a77a156f6f84d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/325e07345bae8f8b2bda8e3d19cfcad1e907cc0d5f6bb2576a55c8d809ba67fc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/1e27b6c722ff5fd23844d5b41cdc9fc002cbc706c45c0343127a77a156f6f84d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/325e07345bae8f8b2bda8e3d19cfcad1e907cc0d5f6bb2576a55c8d809ba67fc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/325e07345bae8f8b2bda8e3d19cfcad1e907cc0d5f6bb2576a55c8d809ba67fc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/656ac11693bcc80a127400c0b00994f1f5dbfe3fe5323bb1754b487aec5d73f1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/acd586cda4efdc03084317b6381391511fdef5c647310f5493a94fca88388de3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/acd586cda4efdc03084317b6381391511fdef5c647310f5493a94fca88388de3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/aa426506f84a84e0c34129be1051b91254b4caaab14d170262a0a4658fa7b71e |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b52bdef0ca584d3587ba22bf84af7232ce794abdc26c798cdbdd56618a31da17 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/aa426506f84a84e0c34129be1051b91254b4caaab14d170262a0a4658fa7b71e |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/aa426506f84a84e0c34129be1051b91254b4caaab14d170262a0a4658fa7b71e |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b52bdef0ca584d3587ba22bf84af7232ce794abdc26c798cdbdd56618a31da17 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/656ac11693bcc80a127400c0b00994f1f5dbfe3fe5323bb1754b487aec5d73f1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b52bdef0ca584d3587ba22bf84af7232ce794abdc26c798cdbdd56618a31da17 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/656ac11693bcc80a127400c0b00994f1f5dbfe3fe5323bb1754b487aec5d73f1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b52bdef0ca584d3587ba22bf84af7232ce794abdc26c798cdbdd56618a31da17 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/656ac11693bcc80a127400c0b00994f1f5dbfe3fe5323bb1754b487aec5d73f1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5cddc3c3302711531c288e808caa03a84bd38294ac58365a7415aac330768b50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/05ce8ac8fc32317a3863ee08ac8b4230f3ca341d68d34731480f0002955dc2d2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/dcba4fddf71459756a9b75d36244ffdd9930ae0aba3893d33b004abc3c71a727 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5cddc3c3302711531c288e808caa03a84bd38294ac58365a7415aac330768b50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/05ce8ac8fc32317a3863ee08ac8b4230f3ca341d68d34731480f0002955dc2d2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/dcba4fddf71459756a9b75d36244ffdd9930ae0aba3893d33b004abc3c71a727 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5cddc3c3302711531c288e808caa03a84bd38294ac58365a7415aac330768b50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/dcba4fddf71459756a9b75d36244ffdd9930ae0aba3893d33b004abc3c71a727 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5cddc3c3302711531c288e808caa03a84bd38294ac58365a7415aac330768b50 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/dcba4fddf71459756a9b75d36244ffdd9930ae0aba3893d33b004abc3c71a727 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/05ce8ac8fc32317a3863ee08ac8b4230f3ca341d68d34731480f0002955dc2d2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/110f2786ea04173179fd30faffda1ac617abed650eb6d0d3306cff133476e097 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/05ce8ac8fc32317a3863ee08ac8b4230f3ca341d68d34731480f0002955dc2d2 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/110f2786ea04173179fd30faffda1ac617abed650eb6d0d3306cff133476e097 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/110f2786ea04173179fd30faffda1ac617abed650eb6d0d3306cff133476e097 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/110f2786ea04173179fd30faffda1ac617abed650eb6d0d3306cff133476e097 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/caa8c4e75b6203819dffca6bb3facabd026bcc5a815e29d5e44642b8e31e65b3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d973d9b33ef1bc49579963b0ace4e8b7b82d32f46d6cc984d587e8d287bfc09a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/caa8c4e75b6203819dffca6bb3facabd026bcc5a815e29d5e44642b8e31e65b3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/caa8c4e75b6203819dffca6bb3facabd026bcc5a815e29d5e44642b8e31e65b3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/caa8c4e75b6203819dffca6bb3facabd026bcc5a815e29d5e44642b8e31e65b3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7d9ea5d85af604e8cd653b46943e431e2a3da87ca351da009fb12ebbd659ce6f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1bb3101b0ff3dca3107f6b512532f0f3a4d66590244f19c3451ee71610b4f30 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d973d9b33ef1bc49579963b0ace4e8b7b82d32f46d6cc984d587e8d287bfc09a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1bb3101b0ff3dca3107f6b512532f0f3a4d66590244f19c3451ee71610b4f30 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/241c278c30b9849af201c3d52c1f159c758c51f6518929082adc5dfe2176e5d1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d973d9b33ef1bc49579963b0ace4e8b7b82d32f46d6cc984d587e8d287bfc09a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7d9ea5d85af604e8cd653b46943e431e2a3da87ca351da009fb12ebbd659ce6f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1bb3101b0ff3dca3107f6b512532f0f3a4d66590244f19c3451ee71610b4f30 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d973d9b33ef1bc49579963b0ace4e8b7b82d32f46d6cc984d587e8d287bfc09a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1bb3101b0ff3dca3107f6b512532f0f3a4d66590244f19c3451ee71610b4f30 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/241c278c30b9849af201c3d52c1f159c758c51f6518929082adc5dfe2176e5d1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7d9ea5d85af604e8cd653b46943e431e2a3da87ca351da009fb12ebbd659ce6f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/241c278c30b9849af201c3d52c1f159c758c51f6518929082adc5dfe2176e5d1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/8e892882dcd5c9cd8706d325512ca9897a67d2c9db9dcbe268254d44dfb57aa8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7d9ea5d85af604e8cd653b46943e431e2a3da87ca351da009fb12ebbd659ce6f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/241c278c30b9849af201c3d52c1f159c758c51f6518929082adc5dfe2176e5d1 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/056c260d7abca87c9b790f84a6c43573fd92bad75f77814e66f3acaa45352524 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a537c37b986c84a3972ff03aaea6721d3100b7fa038a50db63dc208d666b8495 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/8e892882dcd5c9cd8706d325512ca9897a67d2c9db9dcbe268254d44dfb57aa8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/786507f32e227a92826e0468193ef2b5690b9bc87e9002fcd538ec66b3382d3d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/8e892882dcd5c9cd8706d325512ca9897a67d2c9db9dcbe268254d44dfb57aa8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/8e892882dcd5c9cd8706d325512ca9897a67d2c9db9dcbe268254d44dfb57aa8 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/786507f32e227a92826e0468193ef2b5690b9bc87e9002fcd538ec66b3382d3d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/056c260d7abca87c9b790f84a6c43573fd92bad75f77814e66f3acaa45352524 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/786507f32e227a92826e0468193ef2b5690b9bc87e9002fcd538ec66b3382d3d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1c6143ba57460ea970d32a92ab4bfbf50f103aaa20c8c7da28c589b74632f62 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/056c260d7abca87c9b790f84a6c43573fd92bad75f77814e66f3acaa45352524 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a537c37b986c84a3972ff03aaea6721d3100b7fa038a50db63dc208d666b8495 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/786507f32e227a92826e0468193ef2b5690b9bc87e9002fcd538ec66b3382d3d |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/056c260d7abca87c9b790f84a6c43573fd92bad75f77814e66f3acaa45352524 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a537c37b986c84a3972ff03aaea6721d3100b7fa038a50db63dc208d666b8495 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1c6143ba57460ea970d32a92ab4bfbf50f103aaa20c8c7da28c589b74632f62 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/a537c37b986c84a3972ff03aaea6721d3100b7fa038a50db63dc208d666b8495 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7fe437db71bf3e31b35bf46a95279e35f6132e10ba3ecaeb99b9234c0254d8b4 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1c6143ba57460ea970d32a92ab4bfbf50f103aaa20c8c7da28c589b74632f62 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/b1c6143ba57460ea970d32a92ab4bfbf50f103aaa20c8c7da28c589b74632f62 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/2f1bfcd3d931294bac2e53e2f3ce236c51b8d9368b3a09cc27c3a1b6087b3044 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5df53fa5a52ac19ddacd97ce23070e6519726a8230345fab324ac78bde25b6c6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7fe437db71bf3e31b35bf46a95279e35f6132e10ba3ecaeb99b9234c0254d8b4 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9a82a9eb4980fbd18275fa843a2994129feee7e8e82359a761c3c6c4adffdefc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7fe437db71bf3e31b35bf46a95279e35f6132e10ba3ecaeb99b9234c0254d8b4 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9a82a9eb4980fbd18275fa843a2994129feee7e8e82359a761c3c6c4adffdefc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/2f1bfcd3d931294bac2e53e2f3ce236c51b8d9368b3a09cc27c3a1b6087b3044 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/7fe437db71bf3e31b35bf46a95279e35f6132e10ba3ecaeb99b9234c0254d8b4 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9a82a9eb4980fbd18275fa843a2994129feee7e8e82359a761c3c6c4adffdefc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/9a82a9eb4980fbd18275fa843a2994129feee7e8e82359a761c3c6c4adffdefc |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5df53fa5a52ac19ddacd97ce23070e6519726a8230345fab324ac78bde25b6c6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/2f1bfcd3d931294bac2e53e2f3ce236c51b8d9368b3a09cc27c3a1b6087b3044 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/2f1bfcd3d931294bac2e53e2f3ce236c51b8d9368b3a09cc27c3a1b6087b3044 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5df53fa5a52ac19ddacd97ce23070e6519726a8230345fab324ac78bde25b6c6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/5df53fa5a52ac19ddacd97ce23070e6519726a8230345fab324ac78bde25b6c6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0e29336cb58d32ef07a85dd5d3f4b6046de671bd84a37f8d922c3783169af47a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/fde70aeb1576b946d1ef340b81e992331ca58487067404897084ba69ddccfff6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0c0ab8767f6db7b02a644c2d3e03f60bfbf39f0d346a2cf35f97d778084a326f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/fde70aeb1576b946d1ef340b81e992331ca58487067404897084ba69ddccfff6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0c0ab8767f6db7b02a644c2d3e03f60bfbf39f0d346a2cf35f97d778084a326f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/fde70aeb1576b946d1ef340b81e992331ca58487067404897084ba69ddccfff6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/494c8c6bc3cf282a778c86ae2b4a7525c87432d065cac8022620816a4a6bce95 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/fde70aeb1576b946d1ef340b81e992331ca58487067404897084ba69ddccfff6 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0c0ab8767f6db7b02a644c2d3e03f60bfbf39f0d346a2cf35f97d778084a326f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0c0ab8767f6db7b02a644c2d3e03f60bfbf39f0d346a2cf35f97d778084a326f |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/494c8c6bc3cf282a778c86ae2b4a7525c87432d065cac8022620816a4a6bce95 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/494c8c6bc3cf282a778c86ae2b4a7525c87432d065cac8022620816a4a6bce95 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/494c8c6bc3cf282a778c86ae2b4a7525c87432d065cac8022620816a4a6bce95 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d9b1a9bc6ad7372f09160077a21990d0979c2813f42a30383cb6f6d265cadf40 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d9b1a9bc6ad7372f09160077a21990d0979c2813f42a30383cb6f6d265cadf40 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d9b1a9bc6ad7372f09160077a21990d0979c2813f42a30383cb6f6d265cadf40 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0e29336cb58d32ef07a85dd5d3f4b6046de671bd84a37f8d922c3783169af47a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d9b1a9bc6ad7372f09160077a21990d0979c2813f42a30383cb6f6d265cadf40 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0e29336cb58d32ef07a85dd5d3f4b6046de671bd84a37f8d922c3783169af47a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/0e29336cb58d32ef07a85dd5d3f4b6046de671bd84a37f8d922c3783169af47a |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d73bbeeaf29db98f0a17999b44ee2845a550b5f4dd59755dbdd788ce1399ac6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d73bbeeaf29db98f0a17999b44ee2845a550b5f4dd59755dbdd788ce1399ac6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d73bbeeaf29db98f0a17999b44ee2845a550b5f4dd59755dbdd788ce1399ac6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/d73bbeeaf29db98f0a17999b44ee2845a550b5f4dd59755dbdd788ce1399ac6c |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/75f3bfd91f1f349682c5001d30faca24ee3567dc630c72ab34a35e62b21a9ca3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/75f3bfd91f1f349682c5001d30faca24ee3567dc630c72ab34a35e62b21a9ca3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/75f3bfd91f1f349682c5001d30faca24ee3567dc630c72ab34a35e62b21a9ca3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/75f3bfd91f1f349682c5001d30faca24ee3567dc630c72ab34a35e62b21a9ca3 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/3d827c73c5978540e96dc51d58fe5963d7f32c30ace907b56df46d74a60c9614 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/3d827c73c5978540e96dc51d58fe5963d7f32c30ace907b56df46d74a60c9614 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/3d827c73c5978540e96dc51d58fe5963d7f32c30ace907b56df46d74a60c9614 |
| 7c5d5e778c09d59646c1c18f6847afbc1030d0c77fb1595cee56bfad123e02af/3d827c73c5978540e96dc51d58fe5963d7f32c30ace907b56df46d74a60c9614 |
+-----------------------------------------------------------------------------------------------------------------------------------+
192 rows in set (0.010 sec)


[zilla]> SELECT content FROM photo WHERE content!='' LIMIT 1 INTO outfile '/tmp/foo.jpg';

# identify /tmp/foo.jpg 
identify: Corrupt JPEG data: 36 extraneous bytes before marker 0x5c `/tmp/foo.jpg' @ warning/jpeg.c/JPEGWarningHandler/402.
identify: Unsupported marker type 0x5c `/tmp/foo.jpg' @ error/jpeg.c/JPEGErrorHandler/347.