How to make an activities stream mixing posts and comments?

I believe you’re looking for SQL UNION.

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. WP_Query with “post_title LIKE ‘something%'”?
  37. Wp get all the sub pages of the parent using wp query
  38. Usage of the new “posts_clauses” filter in WordPress 3.1?
  39. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  40. How to uniquely identify queries?
  41. Is it possible to select against a post’s parent’s fields with WP_Query?
  42. Multipart/formatted MySQL query problem
  43. Get posts by meta data OR title
  44. Use WP_Query with a custom SQL query
  45. Duplicate Queries
  46. SQL Statement generated by WP_Query not producing expected results
  47. What is an efficient way to query based on post_meta?
  48. How to count post type that has a particular term?
  49. Foreach-generated custom tax queries, each with an ajax “Load more” button
  50. WP_Query Performance Issues with meta_query
  51. Should close $wpdb via $wpdb->close()
  52. Query Set Order By Author
  53. Retrieve or Query Pages by ID
  54. Advanced WP Query hogs the SQL server
  55. Get the Plugin Which Triggered a MySql Query in WordPress?
  56. Mysql query LIKE not working
  57. WP User Query get all authors with last name starting with specific letter
  58. How to orderby meta_value_num with dollar ($) sign
  59. Query: offset post list, unless it’s a specific category
  60. Complex WP SQL Query
  61. Sorting events by descending date, and ascending time if multiple events on a date
  62. Filtering posts from different categories into different section by doing WP_Query only once
  63. How to duplicate 5 posts out of WP_Query results?
  64. WP_Query with ‘rand’, but equal number of posts from the taxonomy terms given
  65. I can’t figure out what’s wrong with this statement. $wpdb->query update
  66. Sort WordPress Posts Meta value by Week not Day
  67. 2 wordpress loops showing 1 post from same post type – how to avoid showing the same post?
  68. How can I override one post and make it display content for another post?
  69. Ajax future single post query doesn’t work when NOT logged in
  70. Conditional sorting with variable using WP Query
  71. Why Query is returning empty array?
  72. Get multiple users with meta value in one query and populate WP_User class
  73. Custom Query – Based on user input
  74. meta_value timestamp older than now
  75. How to filter query loop block with a search string from the query parameters
  76. WP_Query: apply an SQL function to meta fileld value
  77. Why my query does not run with prepare
  78. How to avoid filling up an array each time I run a WP_query?
  79. WordPress SQL JOIN query
  80. Post incorrectly excluded when using “category__in”?
  81. Query multiple post types, but different order for each
  82. What is the equivalent WP_Query of a SQL Query?
  83. Query against multiple locations within single custom post type post
  84. How to get_comments() ordered by date and parent?
  85. How to make a search query if not found in post table then search in postmeta table?
  86. In which file to use $wpdb and its functions for database operations and queries in wordpress?
  87. Adding Category in WP_Query Not Working
  88. Merge two queries and remove duplicate
  89. how to show more than 1 post into three columns query
  90. Fetch only categorized posts
  91. Custom pagination (Title, date and teaser)
  92. Pagination in custom query in a category page
  93. Fire query on ajax post url page
  94. When should you use WP_Query vs query_posts() vs get_posts()?
  95. Wpdb generates too many queries
  96. Showing posts from 4 categories along with all latest posts
  97. Pagination in WP query with transient API
  98. A Depth Like Parameter For “get_posts”
  99. Advanced Search – Is this possible?
  100. How to make OR condition in WP_Query

Leave a Comment