Custom $wpdb Query for Custom Post Type by Category

Don’t use $wpdb, use wp_query. Not only will your code be leaner and quicker, you’ll avoid issues like this. Unless you’re doing something with custom tables or seriously in-depth SQL, there’s no reason to do direct SQL calls on $wpdb.

So, to answer your question – rewrite it from the ground up using wp_query, see that everything you want to do is documented in the Codex, solve your problems without any hassle, and pat yourself on the back, a job well done.

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Can’t pass table to $wpdb->prepare
  6. $wpdb->get_var not returning a result
  7. Most effective use of DB querys
  8. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  9. wpdb::prepare() isn’t working
  10. $wpdb doesn’t appear to work on page inside of a plugin
  11. Strange string in console from wpdb query
  12. Using $wpdb->update but confused on the WHERE in and SET
  13. What’s wrong with my $wpdb prepare?
  14. Make one query for adding entries to database
  15. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  16. Alter a specific query on WordPress
  17. wpdb->term_taxonomy count posts from both published and private posts?
  18. wpdb print all post meta
  19. Plugin will sort users by usermeta
  20. wpdb query problem to access previous 3 days posts
  21. How to write: $wpdb->update having WHERE NOT value pair in the array
  22. I can’t figure out what’s wrong with this statement. $wpdb->query update
  23. Use mysql_query instead of $wpdb query
  24. wpdb COALESCE won’t work
  25. Custom Query – Based on user input
  26. Custom SQL Query passing array to WHERE p.id
  27. Get posts from category with custom query
  28. Custom Query returns array, but I can’t see it’s elements
  29. Valid SQL query return empty
  30. mysql query – how to escape apostrophe?
  31. $wpdb->prepare affecting the query?
  32. prepare function sql safe method
  33. Updating with $qpdb->query() always returns 0 rows affected
  34. How to return count of custom post type posts with a specific custom field value via $wpdb?
  35. WordPress Mysql query and Duplicate
  36. How do I query for posts by custom meta and those that have been stickied?
  37. Help with Related Posts Function
  38. wpdb update multiple row?
  39. Formatting a date/time returned from a custom $wpdb query
  40. Improve performance of slow query
  41. How do I get specific readable results from this query and array results
  42. implementing my wp_query using $wpdb class
  43. Exclude Posts from a Widget
  44. Fastest and most efficient SQL query to check if UID exists
  45. Use $wpdb->get_results with filter based on array
  46. $wpdb query for price in custom field value
  47. Display result from custom post meta query
  48. Wpdb empty result only if language is Russian
  49. Run an update query in a function
  50. How to fix this insert? Don’t work for me!
  51. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  52. Update vs Insert logic but the last key is always inserted?
  53. There is way to improve this query? wordpress get post data and some meta data
  54. $wpdb: how to use a query as a base for another query?
  55. Wpdb generates too many queries
  56. Custom Query for searching through custom fields
  57. Mysql query and odd results
  58. How to reference same column name but different table in custom db query
  59. Retrieving custom field array value through db query
  60. How to get one result using wpdb class?
  61. Delete query won’t run
  62. update $wpdb one query
  63. Custom query_var causes displaying posts archive on front page
  64. What is the most efficient way of implementing a favorite post system?
  65. Using $wpdb to query posts with meta value containing current post_id
  66. Why does get_the_time(‘F j’) return November 30 for all posts?
  67. Query by one meta_key and sort by another (possibly NULL value)
  68. WPDB Multiple site’s posts and get featured images
  69. Query & Sort Comments by custom comment meta
  70. How to get category link without a database query
  71. Inserting data into `post meta` table?
  72. search through post-type attachments titles
  73. mysql query paging
  74. How to set back query var author_name after unset it?
  75. My SQL function to change user_name
  76. WordPress Loop: List All Posts by a Category & Subcategory
  77. Order query by post meta value
  78. List all posts from past week grouped by sub-category
  79. Query Custom Post Type posts by Keyword/url slug
  80. how would I create a custom query to get all users, and a related post based on a postmeta field?
  81. Display posts with a start OR end date later than current date
  82. Query to Get All Users from wp_users With NO matching user_id In wp_usermeta
  83. WordPress custom setting page – add flashing message
  84. Multiple Category Query
  85. wp_list_pages() refuses to output posts
  86. Can’t seem to do combined query AND sort?
  87. sort query results by newest
  88. Best practice to limit results in get_row()?
  89. Ideas how to search & replace post_content when string contains a newline?
  90. WordPress SQL search, how to handle SQL Injection?
  91. Query to view scheduled or draft post
  92. WP MS: How to query over the network
  93. How to add a Variable to post query
  94. Sort a list of a CPT ( job) if a meta is empty
  95. Restore WordPress Backup Locally?
  96. Trouble migrating custom post types from non-wordpress cms
  97. “order” does not affect order of custom query
  98. Run search query again without pagination gives no results?
  99. Where can I find the SQL to get the most used information by wordpress database?
  100. WooCommerce Total # orders [closed]

Leave a Comment