Sometimes we need to dump all post with featured images along with post title and image title. Here is mysql query which lists all posts with featured images. This may be useful for review purpose.
select p1.post_title, p2.post_title from wp_postmeta join wp_posts p1 on p1.ID = wp_postmeta.post_id join wp_posts p2 on p2.ID = wp_postmeta.meta_value where meta_key='_thumbnail_id'
