get post attachment

SELECT YEAR( post_date ) AS year, MONTH( post_date ) AS month, ID
FROM wp_posts
WHERE post_type = 'attachment'
ORDER BY post_date DESC