Wordpress: SQL Query Post By Category

wp_sel_posts_by_cat.sql

SELECT * FROM wp_posts
  LEFT JOIN wp_term_relationships ON(wp_posts.ID = wp_term_relationships.object_id)
  LEFT JOIN wp_term_taxonomy ON(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
  LEFT JOIN wp_terms ON(wp_terms.term_id = wp_term_taxonomy.term_id)
  WHERE wp_terms.name = 'CATEGORY_NAME'
  AND wp_term_taxonomy.taxonomy = 'category'
  AND wp_posts.post_status = 'publish'
  AND wp_posts.post_type = 'post'