structure

jpgpath

## just a small sample of the structure
## the toplevel (relatively) is 2012/
## inside is {008..057} (and two more, 06 and 07 which lack a leading zero)
## and each numbered directory includes thousands of jpegs
## this example is perfectly representative of the entire structure
## there are no deeper directories
|-- 2012
    |-- 032                                      
    |   |-- 9d9cd5432a791c0ef10e6a7067003ee7.jpeg
    |   |-- 9d9dd483cfd7e31aff0e6a706700e4bd.jpeg
    |   |-- 9d9ec648dfb89b18fd0e6a70670057d8.jpeg
    |   |-- 9d9ed6ae476b3914f80e6a70670003fa.jpeg
    |   |-- 9d9f11d65bdfd307090f6a706700db54.jpeg
    |   |-- 9d9ff72b6a169415f90e6a7067005f10.jpeg
    |   |-- 9da02799805fb415f90e6a7067001bab.jpeg
    |   |-- 9da098771112370ff20e6a706700ce49.jpeg
    |   |-- 9da0baba2236431b000f6a7067003881.jpeg
    |   |-- 9da1dcfe554de205070f6a7067009fa6.jpeg

## the following are examples of the two _massive_ strings in which these filenames may occur

(333188,100011,'_wp_attached_file','2012/05/3e8dff333019f219fd0e6a70670001d2.jpeg'),333189,100015,'_wp_attached_file','2012/05/c8885a0a3004f119fd0e6a706700db19.jpeg'),(333190,100016,'_wp_attached_file','20120568b88047301ff219fd0e6a7067001177.jpeg'),(333191,100020,'_wp_attached_file','2012/05/c1030e61300af219fd0e6a70670022a3.jpeg'),333192,100031,'_wp_attached_file','2012/05/a82b72892fb8f019fd0e6a7067006d4e.jpeg'),(333193,100033,'_wp_attached_file','2012058e200ce82ff7f119fd0e6a7067005192.jpeg'),(333194,100036,'_wp_attached_file','2012/05/7a99323e2fbef019fd0e6a706700670e.jpeg'),333195,100037,'_wp_attached_file','009/0cd56aeb2fadf019fd0e6a706700c6a2.jpeg'),(333196,100046,'_wp_attached_file','201205img4eba1a81e9dcf.jpeg'),(333197,100047,'_wp_attached_file','2012/05/faba5ccd3050f319fd0e6a7067007076.jpeg'),333198,100050,'_wp_attached_file','2012/05/74565c903046f319fd0e6a7067009e8f.jpeg'),(333199,100059,'_wp_attached_file','201205eab7f9c7306ef319fd0e6a70670006a7.jpeg'),(333200,100060,'_wp_attached_file','2012/05/9303c6153076f419fd0e6a7067009a23.jpeg'),333201,100062,'_wp_attached_file','2012/05/bbdacad11de8e519fd0e6a706700e360.jpeg'),(333202,100071,'_wp_attached_file','01118ffb42f3096f419fd0e6a706700f4c6.jpeg'),(333203,100072,'_wp_attached_file','2012/05/d53517ab3028f219fd0e6a70670043f8.jpeg'),333204,100074,'_wp_attached_file','2012/05/6e2e39fd2feff119fd0e6a7067007e0d.jpeg')


INSERT INTO `wp_posts` VALUES (369457,0,'2012-05-01 02:11:00','2012-05-01 02:11:01','','France Tennis French Open','','inherit','open','open','','bbc8843feb2e830bee0e6a706700bebc.jpeg','','','2012-05-31 02:11:00','2012-05-31 02:11:00','',81038,'http://www.officialwire.com/wp-contentuploads/2012/05/bbc8843feb2e830bee0e6a706700bebc.jpeg',0,'attachment','image/jpeg',0),(369458,3073,'2012-05-01 02:11:00','2012-05-01 02:11:01','','France ennis rench Open','','inherit','open','open','','809d08ebeb2c830bee0e6a7067001fb9.jpeg','','','2012-05-31 02:11:00','2012-05-31 02:11:00','',0,'http://www.officialwire.comwp-contentuploads/2012/05/809d08ebeb2c830bee0e6a7067001fb9.jpeg',0,'attachment','image/jpeg',0),(369459,0,'2012-05-01 02:11:00','2012-05-01 02:11:01','','France Tennis rench pen','','inherit','open','open','','fde3b688eb29830bee0e6a706700628d.jpeg','','','2012-05-31 02:11:00','2012-05-31 02:11:00','',0,'http://www.officialwire.com/wp-contentuploads2012/05/fde3b688eb29830bee0e6a706700628d.jpeg',0,'attachment','image/jpeg',0),(369460,3073,'2012-05-01 02:11:00','2012-05-01 02:11:01','','France Tennis French Open'