simp SQL select
SELECT object_id, term_taxonomy_id FROM wp_term_relationships WHERE term_taxonomy_id = 9;