SELECT a.post_title, a.post_content 
FROM wp_posts a
inner join wp_term_relationships b
	on	a.id=b.object_id
inner join wp_terms t
	on	b.term_taxonomy_id=t.term_taxonomy_id 
INNER JOIN wp_term_taxonomy AS tt 
	ON t.term_id = tt.term_id
where (tt.taxonomy='location' and t.name='Феодосия')

SELECT a.post_title, a.post_content 
FROM wp_posts a
inner join wp_term_relationships b
	on	a.id=b.object_id
inner join wp_terms t
	on	b.term_taxonomy_id=t.term_taxonomy_id 
INNER JOIN wp_term_taxonomy AS tt 
	ON t.term_id = tt.term_id
where	(tt.taxonomy='location' and t.name='Феодосия')
or	(tt.taxonomy='listingtype' and t.slug in('walk','aboard','fly','drive'))

group by a.post_title, a.post_content
having count(distinct tt.taxonomy)=2