warriormill

SELECT *  FROM `wp_posts` where `post_type`='attachment'

This query gives you access to the information available in the media library, handy when witting media plug-ins.