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