Custom SQL Query passing array to WHERE p.id

This is more of a SQL question then a WordPress question.

Here are some ideas:

  • You’re most likely looking for this kind of structure:

    AND p.ID NOT IN (1433, 1344)

  • You should consider using $wp->prepare() if your query depends on some user input.

  • You might also want to replace CURDATE() with a PHP generated date string, to see if it gives you any performance gain.

  • In general it’s more flexible to use the WP_Query() when possible, to avoid such hardcoded SQL bastards 😉

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. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  10. wpdb::prepare() isn’t working
  11. $wpdb doesn’t appear to work on page inside of a plugin
  12. Strange string in console from wpdb query
  13. Using $wpdb->update but confused on the WHERE in and SET
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. How to write: $wpdb->update having WHERE NOT value pair in the array
  23. I can’t figure out what’s wrong with this statement. $wpdb->query update
  24. Use mysql_query instead of $wpdb query
  25. wpdb COALESCE won’t work
  26. Custom Query – Based on user input
  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. How to Optimize WP site for millions of posts
  64. wpdb::prepare was called incorrectly
  65. How many WordPress SQL Queries per page?
  66. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  67. Advanced Custom Fields – Query Efficiency
  68. How to display lastest post date in the homepage?
  69. How to tell if $query_var isset?
  70. Get the timout value of a saved transient?
  71. Does meta_query work within get_posts array?
  72. Slow meta_query with about 4 milion record on wp_postmeta
  73. How to show more than 5 posts?
  74. WP Query Sort by meta value (date)
  75. mySQL query. ORDER BY meta_key
  76. Update slug (URL) of pending posts via phpMyAdmin
  77. $wpdb query a post type within a specific taxonomy term while ordering posts by custom meta value?
  78. Get stock by custom meta field on all Woocommerce variable products
  79. Changing status of Published posts which have less Content to “Draft”
  80. Exclude all sticky posts front page twenty twelve
  81. How to read the value of a WordPress $query associative array (hash) key
  82. PHP -> SQL Query with Summing
  83. Query posts based on previous query
  84. Waypoints + infinite scroll with custom query
  85. How do I get all results from my query
  86. How to create an overview of posts with the same tag?
  87. JetEngine Query Builder – order by value from repeater
  88. Filter orders by modify date
  89. How to add url parameter to every search query in SearchWp?
  90. Heavy meta query causing SQL crash
  91. Speed up search query that searches in post meta?
  92. Pulling values from a sepcific row in table
  93. very slow wordpress query with default query
  94. Adding an orderby filter, casting postmeta with multiple keys
  95. If more than 1 image show post link?
  96. How to specify what kind of is_single post?
  97. Can’t See Media Queries with Inspect Tool [closed]
  98. Print data from wordpress sql query
  99. Can I create my own query in wordpress with traditional methods?
  100. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?