Query to fetch custom taxonomy along with post title

If we want to display taxonomy name along with post title in backend MYSQL query you can use this query :-

SELECT   p.ID,taxonomy,post_title,post_status,name
FROM    wp_posts p, wp_term_relationships rel, wp_terms t, wp_term_taxonomy 
te
where  
   p.ID = rel.object_id
  AND t.term_id=te.term_id
  AND t.term_id=rel.term_taxonomy_id
  AND taxonomy in ('taxonomy')
  AND Post_type="post"
  and name="name of taxonomy"