Your code looks valid for me. The only thing you can try is ‘NUMERIC’ instead of ‘numeric’ and to cast $current to int as date() will return a string.
$current = (int)date('Ymd');
To debug this further you can place this directly under your code:
global $wpdb;
var_dump( $wpdb->last_query );
You’ll then have the complete query and can paste it into a sql-shell (phpMyAdmin or whatever you prefer) to see what’s wrong with it.
If this doesn’t solve your question feel free to edit your question with the complete SQL query and I’ll have a look at it.
Related Posts:
- meta_query with meta values as serialize arrays
- Use REGEXP in WP_Query meta_query key
- compare meta_query in get_posts arguments
- Display products from specific category in shop page
- How to Compare Two Meta Fields
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- Getting attachments by meta value
- Using custom meta_query with relation not working as expected
- Order by meta_value_num DESC and meta_value ASC on WP 4.0
- Query by meta_key and order by meta_value_num return orderby date
- WP_Query not working as expected for attachments and custom meta_query
- WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
- Wp_query order by multiple custom fields?
- WordPress altering my custom query, How to fix it?
- How to query ‘posts_per_page’ to display a different blog posts index template?
- Order by meta_key in custom post type doesn’t affect the query
- How to create/modfiy WP_Query to search in post title OR custom field?
- Order By Multiple Meta Fields
- Advanced WP Query hogs the SQL server
- How to get user_id from wordpress database inside ajax function?
- Multiple meta queries but arrange by specific meta value order
- Order Posts by meta value AND published date
- WP_Query with multiple meta fields filter?
- How to combine meta_query and post__in in WP_Query
- What format does the meta_query TIME type require?
- How to orderby meta_value_num with dollar ($) sign
- pre_get_posts order by not working
- WP_Query filter and order by meta ordering by wrong joined table
- WP_Query last five posts, simply ordered by meta_value
- Meta Query Array Error 500
- What is the random string I am seeing when I use get_query_var?
- Fetch Record based on meta key dates
- meta_query in WP_Query value is not accepting array
- Changing sort order for presentation by Jetpack infinite scroll
- meta_query not working as expected
- get posts by meta_key from inside key of post meta
- Help optimizing slow WP_Query with meta_query
- meta_value_num not ordering all items
- Meta Queries – should nesting work after WP 4.1?
- Filter and Order by Multiple Custom Meta Values
- Meta Query relation “AND” then set array accordingly
- 2 weeks ago from meta query meta value
- Query posts with “non set” meta value
- Query with meta_query and tax_query together not working properly
- Array as ‘key’ in WP_Query
- Ordering a mysql style datetime stamp with meta_query
- Is it possible to query a custom field where the value is between two fields?
- Filter posts by comparing custom meta value against postdate
- Wp_query with 2 meta keys and array of meta values
- meta_query: check if number exists
- Searching for meta_key returns 0 posts
- Event with multiple dates, display events chronologically
- meta_query fails to compare on values containing apostrophes
- Check if searched number is within the post meta value
- add_query_arg to compare and display events from a certain date
- WP Query / Meta Query [duplicate]
- Query posts by searching for a string in a meta field
- WP_Query not returning correct result with meta_query parameter
- Query multiple post types, but different order for each
- How to add date_query to meta_query array
- Order by the first array within a meta_query
- Query ACF relationship field – Comparator IN – Value array
- Query on meta values and post title
- Combine query in WP_User_Query()
- Multiple nested meta queries
- How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
- How do i create a custom post query when the meta value is an array?
- How can I modify the query by adding to the existing query?
- Custom Meta Query doesn’t work the same on two site
- WP Query – grouping posts by same meta key, adding together values from another key
- How to do WP_User_Query for Nested Array value Inside Nested Array field
- Query for current post
- WordPress Query custom ordering by temporary variable
- Custom query to retrieve oldest post and retrieve others with date interval
- Comparing Meta Field date in WPQuery using Meta_Query?
- How to create better WP_Query to look for date time which is anywhere between two meta values?
- Very slow query generated getting meta data from posts
- How to filter on placeholder image
- Filtering WP_Query based on wp_postmeta keys values
- Slow wp_posts and wp_postmeta query using Advance Custom Fields
- Multiple meta_query not working
- compare for multiple meta values for same key in wp_query
- datetime picker, timestamps and meta queries
- WP_Query with meta_query won’t orderby
- meta_query only check if both value are set
- What is the best way to reset a search on a meta_key / meta_value?
- Slow query when selecting with large meta query or post__in
- WP Meta Query at depth 2
- Extending WP Query: Custom geolocation meta values work, but tax_query breaks
- Using custom field as ‘orderby’ value causing post grouping by publish date
- Is there any difference between below WP_Query code snippets?
- Sorting: custom query with orderby meta_value_num THEN by title
- Looking for a way to exclude frontpage and nav menu from query filter
- Creating Custom Query
- Get posts by meta value except one post [closed]
- WP_Query by meta key not returning any posts
- WordPress extremely slow when using get_posts with multiple meta_query relations
- Use meta query only 3 or more results?
- Use value from meta key array for use in WP_Query
- WordPress – Optimize the Meta Query for 3 meta keys at a time