[sql]SELECT * FROM `wp_posts` where `post_type`=’attachment'[/sql]

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