WordPress post type “event” query string fix?

Your date format is wrong, MySQL date format is yyyy-mm-dd. Once you get that fixed, see WP_Query‘s meta_query, no need for raw SQL in this case.

Related Posts:

  1. How to display SQL query that ran in query?
  2. Custom query_var causes displaying posts archive on front page
  3. What is the most efficient way of implementing a favorite post system?
  4. Why does get_the_time(‘F j’) return November 30 for all posts?
  5. Query by one meta_key and sort by another (possibly NULL value)
  6. Very slow query
  7. Query & Sort Comments by custom comment meta
  8. Count user posts by user ID, Post type and Post status
  9. is_archive() doesn’t work on public query var archive pages?
  10. How to count get_users query?
  11. cron job to auto delete posts of a specific post type older than x days
  12. Possible to get posts from multiple meta keys/values in a single query?
  13. Difference between fragment caching and wp_cache
  14. mysql query paging
  15. How to display all posts with today’s same month and day only?
  16. Select User by Joining Multiple Meta Value Results
  17. How do I find if a page has a template?
  18. Show featured image as background image from postQuery
  19. Using $wpdb->update but confused on the WHERE in and SET
  20. You have an error in your SQL syntax – Help with query
  21. How to retrieve elements from another table in a SQL query?
  22. Make one query for adding entries to database
  23. WordPress Loop: List All Posts by a Category & Subcategory
  24. Order query by post meta value
  25. add_query_arg() and empty variables inside
  26. Query Strings and Woocommerce
  27. Style Post Differently In Query
  28. how would I create a custom query to get all users, and a related post based on a postmeta field?
  29. Display posts with a start OR end date later than current date
  30. Help with MySQL to $WPDB query
  31. Order posts by custom field DATE value
  32. Form redirect with query vars to page
  33. Query to Get All Users from wp_users With NO matching user_id In wp_usermeta
  34. WordPress custom setting page – add flashing message
  35. Custom query AFTER rss fetch_feed not working
  36. Attempt to improve WP search, can someone check my SQL query?
  37. WordPress Query orderby title with UTF8 string in title
  38. Searching With Apostrophe
  39. Multiple Category Query
  40. list all categories that have a certain word in title
  41. Passing parameters to a static front page
  42. wp_list_pages() refuses to output posts
  43. List author’s posts with SQL
  44. Where is the query in wp-login.php
  45. Can’t seem to do combined query AND sort?
  46. sort query results by newest
  47. How to reset usual $query on search page to push custom $wpdb query there?
  48. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  49. Order by meta value pro first then meta value free in my search function
  50. Order by title – but now built in wordpress func, sort the_title
  51. Display posts between two particular dates
  52. pre saved posts query from db options table
  53. $post->ID not working in combination with a custom query
  54. How to delete all posts, categories and tags from WordPress database
  55. Ideas how to search & replace post_content when string contains a newline?
  56. Query the WordPress database to get data together with replaced information
  57. $wpdb->prepare affecting the query?
  58. WordPress SQL search, how to handle SQL Injection?
  59. Query for Custom Post Type UI Does Not Loop All the Post
  60. Updating with $qpdb->query() always returns 0 rows affected
  61. wpdb query with dynamic column name?
  62. How do you display the number of a post in a query?
  63. How to manage a particular “order by” for get_search_query()?
  64. Query to view scheduled or draft post
  65. How can I get the name of term post meta value which equals term id
  66. Help with Related Posts Function
  67. Trying to use WP_Query to return post with and without meta values
  68. How to add a Variable to post query
  69. Sort a list of a CPT ( job) if a meta is empty
  70. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  71. SQL query to delete users with multiple meta keys and comments
  72. Restore WordPress Backup Locally?
  73. Trouble migrating custom post types from non-wordpress cms
  74. Pagination adds search query (again)
  75. “order” does not affect order of custom query
  76. Create a new post on a specified publish date via link?
  77. Exclude Posts from a Widget
  78. Fastest and most efficient SQL query to check if UID exists
  79. New custom post type entries are not sorted correctly in admin using pre_get_posts
  80. Query String for the WP_QUERY parameters
  81. Counting And Monitoring How Much Queries My Script Used
  82. $wpdb query for price in custom field value
  83. Run an update query in a function
  84. Multiple terms not working on taxonomy
  85. Sorting of coupons in the right way
  86. search.php is not generating the right results
  87. excludeCat function reverses order of blog posts
  88. Slow query when joining wp_posts with a lookup-table?
  89. Run search query again without pagination gives no results?
  90. Mysql query and odd results
  91. Using wp_list_table how to trigger update function “inline”?
  92. Filter multiple different main queries on custom pages
  93. WP_Query orderby meta key/value suddely stopped working
  94. WP_Query older new links navigation?
  95. How to get one result using wpdb class?
  96. Delete query won’t run
  97. Where can I find the SQL to get the most used information by wordpress database?
  98. WooCommerce Total # orders [closed]
  99. Modify a query using both a text field and a true/false AFC field
  100. How to show sticky posts on all pages of the pagination, not just the first page?