Customy WP Query Args are convertet in SQL result

As the dev note for 4.8.3 implies, you need to unescape the escaped % by using the $wpdb->remove_placeholder_escape method. Something like 

global $wpdb;
add_filter('posts_request',array($wpdb, 'remove_placeholder_escape'));

Very untested.

Related Posts:

  1. order by numeric value for meta value
  2. numberposts? showposts? posts_per_page?
  3. How to query posts based on lat-lng coordinate as post meta?
  4. How to query only for products with status “in stock” in WooCommerce? [closed]
  5. WP_Query displaying ALL posts
  6. Does WordPress sanitize arguments to WP_Query?
  7. How to trigger 404 for custom query var?
  8. Calling a wp_query $posts causes a 500 error
  9. WP_query taxonomy + get all posts with two terms from same taxonomy
  10. How do I create my own nested meta_query using posts_where / posts_join?
  11. Best Practice For Querying Grandchildren?
  12. How to combine tax_query and date_query in WordPress
  13. wp_query display posts from same category of the post
  14. Targeting specific pages in the loop
  15. wp_get_post_terms of cpt but not duplicates if they are used more than once in the loop
  16. How to prevent queried posts from being added to cache?
  17. Order posts by meta value and Date
  18. Include Sticky Posts in Page Post Count for custom query
  19. Query sticky posts with thumbnails
  20. Show all parents and children in custom post type in right order
  21. How to make orderby ‘meta_value_num’ OPTIONAL?
  22. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  23. Can you order posts from wp_query by two custom meta fields?
  24. Retreaving all images attached to current post
  25. Pagination working everywhere but the index page
  26. How can I query posts with newly uploaded images?
  27. Conditional arguments WP_Query for post custom fields
  28. How do I search inside specific taxonomies in WordPress
  29. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  30. How can you get first post, last post and post count in a category?
  31. Random loop with code to prevent duplicate output returns no output at all from time to time
  32. Single meta_query query using OR instead of AND in request’s WHERE statement
  33. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  34. remove query arg from url after set query
  35. How to loop for every result found in the_content() when using the search query?
  36. if statement in wp_query arguments
  37. Need wp_query to return all children and grandchildren
  38. How to use offset in WP_Query
  39. difference between like ‘%%%var%%’ and ‘%var%’
  40. WP Query Category Atribute Not Working
  41. Slow WP_Query for custom post type
  42. How to build a WP_Query using mulitple tags and using AND or OR operator between them
  43. new WP_Query to get max price meta value not working
  44. wp_query should show stickies first
  45. Overwrite YoastSEO meta-tags with another page’s [closed]
  46. How to restrict the search fields for a specific post type
  47. WordPress custom post type with meta – how to retrieve with wp_query
  48. Pagination links missing for first link (1) and previous button? How to get pagination links to work?
  49. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  50. Query with relation and one without relation using multiple taxonomies?
  51. WP_Query with different postmeta filter for each categories
  52. Wp query show post by author name or post title or post content
  53. Automatically Query Parent Taxonomy
  54. wordpress ajax relationship query
  55. Shouldn’t I be able to modify the main query by this filter?
  56. insert value from html into data base with wordpress
  57. Debugging wp_query orderby for taxonomy
  58. Get all posts which was posted on X Days WordPress
  59. Admin Page Post Id wp_reset_postdata not working
  60. Multiple queries and performance – wp_query
  61. Sort by presence of thumbnail
  62. Get posts in taxonomy randomly
  63. embedding shortcodes in php template
  64. Max Posts and Memory Limit
  65. WP_Query orderby
  66. Using Ajax and WP_Query to load more posts on category page fails
  67. I have problems with the search query using multiple post types
  68. How to check if logged in user have pending custom post?
  69. whether a nonce is required for get type and get_query_var?
  70. How can I re-query post_type and rewrite the url?
  71. Different query result on local and server
  72. How can I show only last year posts in wordpress archive?
  73. Related Post by Tags Code
  74. I can’t get post based on its postmeta value and key
  75. Change database image location for transportability
  76. Combine Tax Archive and Meta_Query in WP_Query
  77. Get posts by birthday
  78. How to add in WP_Query to every 3 posts displayed? [duplicate]
  79. Display three sequential posts on each page load, without repeating previous
  80. how to avoid reloading/refresh the page when displaying the post of wp_list_categories
  81. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  82. Optimising amount of calls to custom fields
  83. Issue in If else condition [closed]
  84. Pagination not working with WP_QUERY
  85. Custom Content Slider stop duplicate
  86. Extract video content from post to display on front page
  87. Sort Posts with custom meta key by default which is currently set as optional
  88. wp_query pagination links producing 404
  89. difference between methods of query
  90. Related posts with WP_Query
  91. Carousel slider with WP_Query to show 3 posts on each slide
  92. how to use transient method?
  93. WP_Query – meta fields numeric
  94. How to query posts from single post format on Genesis framework
  95. How to replecate the _fields parameter in custom REST api endpoint
  96. Pagination only showed when no category is set in wp_query
  97. taxonomy-{term}.php terms pagination returning 404 after a certain page
  98. Using WP Query, I want to include all posts in category 1 as long as they are not also in category 2
  99. Prevent URL Parameter Affecting other WP Query
  100. Sort by multiple columns using get_posts