Get posts from category with custom query

It looks like this is the new part of this query causing the problem, is that right?

(SELECT term_taxonomy_id
FROM wp_BOMEGAterm_relationships
WHERE object_id = p.ID) AS categories

If so the error message is clear: a sub-select in this query should only return one row. If it returns more than one row it doesn’t know how to mash all those many rows into the one row of the rest of the query.

So you need to find a way to join all the rows of this subquery together into one row, and the SQL command GROUP_CONCAT will do that

You want to make the subquery something like:

(SELECT GROUP_CONCAT(term_taxonomy_id)
FROM wp_BOMEGAterm_relationships
WHERE object_id = p.ID) AS categories

If there were more than one term_taxonomy_id’s to be returned, they’ll then be returned in a single row comma delimited, like:

10,50,100

So you’ll need to figure out what you want to do with those.

Related Posts:

  1. Multipart/formatted MySQL query problem
  2. wpdb COALESCE won’t work
  3. Valid SQL query return empty
  4. mysql query – how to escape apostrophe?
  5. Updating with $qpdb->query() always returns 0 rows affected
  6. How to return count of custom post type posts with a specific custom field value via $wpdb?
  7. WordPress Mysql query and Duplicate
  8. Help with Related Posts Function
  9. Mysql query and odd results
  10. Return only Count from a wp_query request?
  11. Differences between wpdb->get_results() and wpdb->query()
  12. simple sql query on wp_postmeta very slow
  13. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  14. wpdb get posts by taxonomy SQL
  15. How many WordPress SQL Queries per page?
  16. Custom $wpdb Query for Custom Post Type by Category
  17. Can’t pass table to $wpdb->prepare
  18. $wpdb->get_var not returning a result
  19. Are database queries created using WordPress filters protected from SQL injection?
  20. Most effective use of DB querys
  21. Grouping related postmeta data via SQL query
  22. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  23. Mysql / WordPress killing my server with 80k users [closed]
  24. Slow meta_query with about 4 milion record on wp_postmeta
  25. wpdb::prepare() isn’t working
  26. mySQL query. ORDER BY meta_key
  27. $wpdb doesn’t appear to work on page inside of a plugin
  28. Strange string in console from wpdb query
  29. Update slug (URL) of pending posts via phpMyAdmin
  30. My SQL function to change user_name
  31. What’s wrong with my $wpdb prepare?
  32. Why is variable not working on custom sql query using wpdb?
  33. MySQL variable in query
  34. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  35. Alter a specific query on WordPress
  36. Advanced SELECT query with condtional statements
  37. how would I create a custom query to get all users, and a related post based on a postmeta field?
  38. Help with MySQL to $WPDB query
  39. SQL query to select posts from multiple categories
  40. How do I see the mysql query generated by get_posts( $args )?
  41. Alter query with posts_clauses to retrieve NULL values last
  42. wpdb->term_taxonomy count posts from both published and private posts?
  43. wpdb print all post meta
  44. Plugin will sort users by usermeta
  45. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  46. MySql Query very slow
  47. Searching With Apostrophe
  48. wpdb query problem to access previous 3 days posts
  49. WordPress Query wp-terms SLOW
  50. How to write: $wpdb->update having WHERE NOT value pair in the array
  51. I can’t figure out what’s wrong with this statement. $wpdb->query update
  52. Custom WordPress Table wpdb
  53. Custom SQL Query passing array to WHERE p.id
  54. Best practice to limit results in get_row()?
  55. Placing a widget with $wpdb query
  56. Custom Query returns array, but I can’t see it’s elements
  57. how to insert missing tags into the posts through mySQL?
  58. Query Column of Specific ID from Database Table
  59. Optimize slow SQL query for multiple meta values
  60. prepare function sql safe method
  61. WordPress Insert not working with ajax
  62. How do I query for posts by custom meta and those that have been stickied?
  63. wpdb update multiple row?
  64. Formatting a date/time returned from a custom $wpdb query
  65. Improve performance of slow query
  66. How to delete all images from code in all post_content
  67. How do I get specific readable results from this query and array results
  68. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  69. Delete oldest wordpress post (SQL query)
  70. Displaying data from custom table
  71. Get 2 meta values from meta key column
  72. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  73. SQL query to delete users with multiple meta keys and comments
  74. WordPress Database Query works in phpMyAdmin but not in the code
  75. OR condition not working
  76. implementing my wp_query using $wpdb class
  77. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  78. Fastest and most efficient SQL query to check if UID exists
  79. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  80. How to make MySQL search queries with quotes
  81. Use $wpdb->get_results with filter based on array
  82. Display result from custom post meta query
  83. Wpdb empty result only if language is Russian
  84. Run an update query in a function
  85. How to fix this insert? Don’t work for me!
  86. Function returning queried meta value based on current post ID
  87. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  88. Update vs Insert logic but the last key is always inserted?
  89. Custom MySQL Query for Post and Post Meta
  90. There is way to improve this query? wordpress get post data and some meta data
  91. $wpdb: how to use a query as a base for another query?
  92. Wpdb generates too many queries
  93. Custom Query for searching through custom fields
  94. sql for querying post and their category
  95. Access Tables with number prefix
  96. How to reference same column name but different table in custom db query
  97. Retrieving custom field array value through db query
  98. How to get one result using wpdb class?
  99. Delete query won’t run
  100. update $wpdb one query