What I need is right here:
mysql> select ID, post_title, post_name, post_parent from wp_2_posts where post_type='attachment'; +-----+-------------------------+-------------------------+-------------+ | ID | post_title | post_name | post_parent | +-----+-------------------------+-------------------------+-------------+ | 40 | AUTC_orangelogo_150 | autc_orangelogo_150 | 0 | | 66 | UAF Rotary | rotary | 0 | | 82 | bob_pawlowski | bob_pawlowski | 0 | | 83 | zhaohui_yang | zhaohui_yang | 0 | | 89 | Duane Davis | duane_davis | 86 | | 98 | FinesProjectUpdate_0929 | finesprojectupdate_0929 | 99 | | 135 | INE_TRC_94_27 | ine_trc_94_27 | 133 | | 144 | INE_TRC_94_26 | ine_trc_94_26 | 136 | +-----+-------------------------+-------------------------+-------------+ 8 rows in set (0.03 sec) mysql> select * from wp_2_postmeta where post_id = 144; +---------+---------+-------------------------+---------------------------+ | meta_id | post_id | meta_key | meta_value | +---------+---------+-------------------------+---------------------------+ | 151 | 144 | _wp_attached_file | 2011/01/INE_TRC_94_26.pdf | | 152 | 144 | _wp_attachment_metadata | a:0:{} | +---------+---------+-------------------------+---------------------------+ 2 rows in set (0.00 sec) mysql> select post_content, post_title, post_excerpt from wp_2_posts where ID = 144; +--------------+---------------+--------------+ | post_content | post_title | post_excerpt | +--------------+---------------+--------------+ | description | INE_TRC_94_26 | caption | +--------------+---------------+--------------+ 1 row in set (0.00 sec)