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 string starting like pattern
- compare meta_query in get_posts arguments
- how to show posts that are missing a meta_value
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
- querying with custom meta field with meta_query
- Order by two meta keys
- multiple meta key but get server load is very high
- A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
- Order by meta_value_num DESC and meta_value ASC on WP 4.0
- Wp_query order by multiple custom fields?
- WordPress altering my custom query, How to fix it?
- 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?
- Use meta_query to display events by date in custom field
- How to show recent and upcoming birthdays using meta_query
- Multiple meta queries but arrange by specific meta value order
- Order Posts by meta value AND published date
- Using WP_Query and WP_Meta_Query Outside of WordPress
- What format does the meta_query TIME type require?
- If two first numbers exist in wp_meta_query value
- WP_Query on custom field and order results
- pre_get_posts order by not working
- WP_Query filter and order by meta ordering by wrong joined table
- Tax query clause inside a meta query clause?
- Optional Meta Query
- How do I make a meta_query OR relation work? [closed]
- meta_query in WP_Query value is not accepting array
- Meta_query on same meta key, with diffrenct values
- Can we return all category (not post) with Custom Query Filter? [closed]
- Extend product search with meta in WooCommerce
- how to make members list directory through wordpress post custom meta key.
- Changing sort order for presentation by Jetpack infinite scroll
- 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?
- 2 weeks ago from meta query meta value
- WP_Query with meta_query dosen’t return results
- How to filter a query by multiple meta keys and order by other meta keys
- Query posts with “non set” meta value
- Ordering a mysql style datetime stamp with meta_query
- Meta Query doesn’t works as espected
- Wp_query with 2 meta keys and array of meta values
- Advanced WP_Query with meta_query, orderby?
- meta_query: check if number exists
- Event with multiple dates, display events chronologically
- Issues with search after added meta_query
- Display posts with specific value first in query
- WP_Query: apply an SQL function to meta fileld value
- How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
- How to create dynamic value in WP_Query meta_query
- query post by author gender
- How do I add an item to the WP admin menu?
- Multiple meta query from array
- WP Query / Meta Query [duplicate]
- Query posts by searching for a string in a meta field
- WP_Query with 4 post meta field arguments gives 500 internal server error
- Use have_posts() with array of post results retrieved by $wpdb->get_results
- 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
- Combine query in WP_User_Query()
- Multiple nested meta queries
- How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
- Custom meta_query order for Elementor based on post meta key [closed]
- What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
- How can I modify the query by adding to the existing query?
- ElasticPress is (aparently) messing with my search filters
- Meta query ignores multiple values of the key
- Multiple meta_query not returning rows
- WordPress Query custom ordering by temporary variable
- Check for not NULL not working in meta query
- Comparing Meta Field date in WPQuery using Meta_Query?
- Get unique post by meta value using wp_query
- How to create better WP_Query to look for date time which is anywhere between two meta values?
- Query against multiple locations within single custom post type post
- WP_Query, ACF field and array
- Order by Date Custom Field
- Filtering WP_Query based on wp_postmeta keys values
- WP Query. Ordering posts by another post types meta
- Complex Meta Query
- 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
- Get posts meta_query by repater field
- Query 3 meta_key and orderby
- Extending WP Query: Custom geolocation meta values work, but tax_query breaks
- meta_query not working with the_content()
- Using custom field as ‘orderby’ value causing post grouping by publish date
- Set right order for query that returns posts based on two custom fields
- WP_Query with several meta_query-statements and order by meta_value
- Use meta query only 3 or more results?
- Display only posts with thumbnails
- WordPress – Optimize the Meta Query for 3 meta keys at a time
- How to use meta_query to retrieve posts from multiple custom post type
- WP_Query filtering in ACF field containing dates