SELECT ID,p.post_date FROM wp_posts p,wp_term_relationships r,wp_term_taxonomy t,wp_terms m,wp_postmeta e WHERE p.post_status = 'publish' AND p.id=r.object_id AND p.id=e.post_id AND r.term_taxonomy_id=t.term_taxonomy_id AND t.term_id=m.term_id AND m.name='yokohama' GROUP BY p.ID ORDER BY p.post_date DESC

SELECT ID,p.post_date FROM wp_posts p,wp_term_relationships r,wp_term_taxonomy t,wp_terms m,wp_postmeta e WHERE p.post_status = 'publish' AND p.id=r.object_id AND p.id=e.post_id AND r.term_taxonomy_id=t.term_taxonomy_id AND t.term_id=m.term_id AND m.name='yokohama' GROUP BY p.ID ORDER BY p.post_date DESC LIMIT 0, 9

yokohama