I'm looking for a 1 to many recursive relationship in the Stack Exchange Database. I'm querying it here https://data.stackexchange.com/math/queries. I don't see any 1 to many recursive relationships. The closest I've found is the relationship between posts and the parent of posts (both columns in the Posts table). I suppose that's still a 1:M recursive relationship, but it only goes 1 level deep, because there are no posts that are parents of one post, but children of a different post.
Can anyone point me to a 1 to many recursive relationship in this database?
Thanks, ET
