WordPress SQL query by taxonomy

wordpress-query-by-taxonomy.sql

SELECT wp_posts.* 
FROM 
	wp_posts INNER JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
	INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
	INNER JOIN wp_terms on (wp_term_taxonomy.term_id = wp_terms.term_id)
WHERE 1=1
	AND wp_term_taxonomy.taxonomy = 'taxonomy-slug'
	AND wp_terms.slug = 'term-slug'
	AND wp_posts.post_type IN ( 'post', 'page', 'cpt' )
	AND wp_posts.post_status in ( 'publish', 'future', 'draft' )
ORDER BY wp_posts.post_date DESC