Evil bit of SQL to get the most recent posts from WordPress with media, the link to the media and the post ID.

gistfile1.sql

SELECT posts.post_title, posts.ID post_id, media.ID media_id
FROM $wpdb->posts media
JOIN $wpdb->posts posts
ON posts.post_content LIKE CONCAT('%', media.guid, '%')
WHERE media.post_type = 'attachment'
AND posts.post_type = 'post'
AND posts.post_status = 'publish'
GROUP BY posts.ID
ORDER BY media.post_date DESC
LIMIT 0, 9