WordPress Featured Image

SQL

SELECT p.ID,p.post_title,p.post_name,p.post_excerpt,p2.guid FROM wp_posts p
LEFT JOIN wp_postmeta pm ON (pm.post_id = p.id AND pm.meta_value IS NOT NULL AND pm.meta_key = "_thumbnail_id")
LEFT JOIN wp_posts p2 ON (p2.ID = pm.meta_value)
WHERE p.post_status='publish' AND p.post_type='post' 
ORDER BY p.post_date DESC LIMIT 5