Query to fetch custom taxonomy along with post title

I have more than 20000 posts and want to filter post based on taxonomy and name which should display the
post title ,taxonomy, name,id using MYSQL query.