title: Wordpress mysql query for featured image also
body: <p>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.</p>
  
  <blockquote>
    <p>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</p>
  </blockquote>