select post_id, meta_value from wp_posts p left join wp_postmeta m ON m.post_id = p.id where p.post_type = 'attachment' and m.meta_key  = '_wp_attached_file'Total Media: 7398<br>