We have Users who have many Posts. Posts have many Tags through an associated table we've called Taggings.
We want to get a unique list of all the tags that a given user's Posts have been associated with. So we have to find a user, get all of their post IDs, use those IDs to select the relevant taggings, and finally return a distinct list of related tags.
SELECT DISTINCT "tags".name
FROM taggings