No, you’re doing everything right and this should actually work as those placeholders are removed at a later point before actually executing the query.
This is part of a security measure introduced with WordPress 4.8.3. Quoting from the corresponding developer note:
As part of the WordPress 4.8.3 release, there is a change in
esc_sql()behaviour that may affect plugin developers who expect
esc_sql()to return a string that’s usable outside of the context of
building a query to send to WPDB.Source: https://make.wordpress.org/core/2017/10/31/changed-behaviour-of-esc_sql-in-wordpress-4-8-3/
If you’re really curious about what is going on read the blog post by Anthony Ferrara who discovered the underlying vulnerability:https://blog.ircmaxell.com/2017/10/disclosure-wordpress-wpdb-sql-injection-technical.html
Related Posts:
- order by numeric value for meta value
- numberposts? showposts? posts_per_page?
- $GLOBALS[‘wp_the_query’] vs global $wp_query
- Some doubts about how the main query and the custom query works in this custom theme?
- How to query posts based on lat-lng coordinate as post meta?
- How to query only for products with status “in stock” in WooCommerce? [closed]
- WP_Query displaying ALL posts
- Does WordPress sanitize arguments to WP_Query?
- How to trigger 404 for custom query var?
- get_the_title($postID) OR get_the_title()?
- datetime picker, timestamps and meta queries
- Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
- How to order posts in wp_query by a meta_value of the corresponding author
- How to get sum of meta_values of a meta_key in wp_query according to conditions
- Show single post then all posts (with pagination)
- How to display 3 different loops in 3 columns on homepage
- Get the post thumbnail with wp_query
- Where to use $post global variable?
- Multiple instances of Featured Image Query
- Refine/Filter WP_Query Posts with jQuery or Ajax
- Exclude admin from WP_Query Contributors
- Sticky posts are not showing at the top of category posts
- WPDB query – decrypting DB data
- Storing query variable and then using wp_reset_query
- ACF Date Based wp_query
- exclude posts with a specific custom field and value
- Redirect page when URL parameter not set
- list pages using page.php and NOT page-{slug}.php
- Moving the array pointer inside a WP_Query while loop
- Help with WP_Query – Too many mySQL queries
- Group and list posts by custom taxonomy
- Show scheduled posts in main loop but not in WP_Query?
- WordPress Pagination changes my template
- wp_query ignoring custom post_status
- Query posts(CPT, pages , hierarchical) by Ancestor ID
- How can I make WP_Query get posts that have a tag but also have random other tags?
- Input check to custom post type query
- Get a list of posts with associated meta_value
- WordPress pagination not working on template search.php
- Show all data in database table and make it into an interactive table
- Combine two queries into one to use in loop
- database query with more than a couple meta hangs and doesn’t complete
- How to filter a query by date in a shortcode?
- Search posts missing a particular custom field
- Query post with meta value in set of values
- get_template_part causes 500 error
- Finding WordPress Posts assigned to multiple categories
- The most effective way to split by post type in custom query?
- Does meta_value (array) work with ‘orderby’?
- Shortcode for custom query not returning results when attributes are added
- wp_query is showing posts from other categories
- Sort by presence of thumbnail
- Get posts in taxonomy randomly
- Page navigation doesn’t seem to work when I add offset?
- is_404() – where does this get set?
- wp_query on page template not working (Genesis framework)
- Max Posts and Memory Limit
- WordPress | WP_Query does not return anything with s=a
- WP_Query Pagination
- WP_Query orderby
- Using Ajax and WP_Query to load more posts on category page fails
- I have problems with the search query using multiple post types
- How to check if logged in user have pending custom post?
- How can I re-query post_type and rewrite the url?
- Different query result on local and server
- meta_query compare > not working
- How can I show only last year posts in wordpress archive?
- WP_Query about meta_key and its array value
- Query string order by custom field
- Paging works correctly on local version, but not live?
- Related Post by Tags Code
- I can’t get post based on its postmeta value and key
- Change database image location for transportability
- Combine Tax Archive and Meta_Query in WP_Query
- Get posts by birthday
- How to add in WP_Query to every 3 posts displayed? [duplicate]
- Paginate nested query of child posts
- Display three sequential posts on each page load, without repeating previous
- how to avoid reloading/refresh the page when displaying the post of wp_list_categories
- Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
- Optimising amount of calls to custom fields
- Issue in If else condition [closed]
- Pagination not working with WP_QUERY
- Get Current CPT taxonomy category in shortcode
- Custom Content Slider stop duplicate
- Extract video content from post to display on front page
- Sort Posts with custom meta key by default which is currently set as optional
- wp_query pagination links producing 404
- How return normal search result using wp_ajax action for wordpress
- Custom post types loop on a page template
- Pagination problem with multiple loops on the same page
- Related posts with WP_Query
- Carousel slider with WP_Query to show 3 posts on each slide
- how to use transient method?
- WP_Query – meta fields numeric
- How to query posts from single post format on Genesis framework
- How to replecate the _fields parameter in custom REST api endpoint
- Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
- Get posts using multiple values from ACF checkbox as meta query wordpress
- Why ignore_sticky_posts argument is in sticky post query?