WordPress mysql query for featured image also

So I have the following query which works but I also need the posts featured image, can you guys help me out to query for that too.

SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts, wp_term_relationships, wp_terms
WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_posts.post_status = ‘publish’
AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id GROUP BY wp_posts.ID ORDER BY
wp_posts.post_date DESC LIMIT 0,100

Read more here: WordPress mysql query for featured image also

Leave a Reply

Your email address will not be published. Required fields are marked *