I have a site that needs two different tabs:

1. all author written content (Posts, comments, CTP)
2. all author followed content (categories, taxonomies, other users content)

For the first all I could come up with was using unoion on wp_comments and wp_posts filtered by author sorted by date

Have no idea how to do the 2nd one...

Would love some advice