SELECT object_id, term_taxonomy_id, name, slug
FROM wp_term_relationships
WHERE term_taxonomy_id IN (
	SELECT term_id, name, slug
	FROM wp_terms
	WHERE term_id IN (
		SELECT term_taxonomy_id
		FROM wp_term_taxonomy
		WHERE taxonomy = 'post_tag'
	)
)