How to make an activities stream mixing posts and comments?

Related Posts:

1. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
2. How to correctly pass values to wpdb->prepare()?
3. Any way to use FETCH_KEY_PAIR with $wpdb?
4. Pagination with custom SQL query
5. Return only Count from a wp_query request?
6. SQL query equivalent to WP User Query
7. how to retrieve specific product attribute value in an sql query?
8. Select from wp_post and multiple meta_value from wp_postmeta
9. $wpdb select date range of posts
10. List of the years with posts presented
11. Optional Meta Query
12. Custom Query num_rows returns wrong amount
13. Editing the default wordpress search
14. Iterating through $wpdb query without using get_results for large query results
15. WP Query related posts by tags
16. Order by summing multiple values
17. Include data from custom table in WP_Query
18. How to pass orderby params to $wpdb->prepare()?
19. Is it possible to query from external database? [duplicate]
20. Make a SQL query with wpdb in WordPress
21. WordPress query posts with multiple post_meta data
22. List of ways to access WordPress database?
23. Query where ANDing slug values not working
24. How to SQL query posts IDs by categories AND authors?
25. Disable (or limit) queries when certain content (or data) is not needed (or showed)
26. Passing a SQL query to the WP Query
27. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
28. Slow wp_posts and wp_postmeta query using Advance Custom Fields
29. What argument does my function need to echo get_results() query results
30. Include post_status check within $wpdb query
31. wpdb get_results() returns only 2 rows
32. wpdb LIKE request shows all database data
33. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
34. How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
35. how to use transient method?
36. How to avoid filling up an array each time I run a WP_query?
37. Randomly select one of last 3 posts
38. Unable to paginate a custom page query
39. Include one page/post into query which is already returning posts
40. I am officially missing something about transient posts
41. Insert images into wordpress post with a query
42. Why doesn’t my WP Meta Query return any results?
43. How do I query for posts by custom meta and those that have been stickied?
44. WordPress SQL JOIN query
45. WP_Query meta compare must include ALL array values
46. Start Query from 2nd Post without offset
47. get_var is neither a string, integer, or array …?
48. Use have_posts() with array of post results retrieved by $wpdb->get_results
49. how to translate countries output from wp database?
50. What’s wrong with this wpdb query?
51. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
52. Prioritising and Ordering Posts By Category Name Using A Custom Loop
53. meta_query where the meta value is not the post title
54. Post incorrectly excluded when using “category__in”?
55. Query multiple post types, but different order for each
56. Multi-layered WP_Query
57. `offset` WP_Query argument dont work via `pre_get_posts`
58. Filter products on category AND tag
59. Display posts ONLY from the current logged in user and current week/year/month Elementor posts
60. SQL query injection with fifu image
61. duplicated posts when using pagination
62. Pagination of custom page with custom fields query
63. Query pages created by deleted users
64. WP_Query() not working as expected
65. Save queried result into database
66. Customising the default wordpress search functionality
67. WP Query – grouping posts by same meta key, adding together values from another key
68. setting offset to category number in archive page
69. Woocommerce Get Orders By Meta Value
70. pre_user_query vs pre_get_posts
71. Exclude post from wp_query based on custom field boolean
72. How to do WP_User_Query for Nested Array value Inside Nested Array field
73. Delete oldest wordpress post (SQL query)
74. Get posts that match defined arrays of tags
75. What is the equivalent WP_Query of a SQL Query?
76. Move some posts to end of sort order, even if there is a sort in the wp_Query already
77. Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
78. Meta query orderby meta_value_num sorting by role first
79. How to get meta key list efficiently?
80. How to get user avatar via WPDB
81. Order posts by tags count?
82. Query against multiple locations within single custom post type post
83. Why pagination is not working with tax_query param?
84. Translating WP query into to SQL query
85. Query Posts | Combining multiple form inputs into query arguments to generate one filter result
86. Strange results from WP_Query
87. Is there a way to control both Order By and Order query parameters from one input field
88. How to get_comments() ordered by date and parent?
89. I need query_posts() to order results first by a meta value and then by post ID
90. WP_Query & Duplicate entries
91. How to query 5 users in random who have published more than 10 posts
92. How to query users by post count no less than 10
93. WP Query. Ordering posts by another post types meta
94. Add to search posts query array with post IDS which will appear first
95. Filtering posts for unique titles, only the most recent
96. return child post if available otherwise parent post
97. Search has query that will return no results
98. Is my code correct?
99. How to make a search query if not found in post table then search in postmeta table?
100. How to search CPTs in draft using get_page_by_title()