When I use WP_Query in combination with a meta_query LIKE lookup I don’t get any results. Using get_posts works fine, but with that option I don’t get the pagination.
Querying the sql gave me this:
SELECT SQL_CALC_FOUND_ROWS beva_posts.ID FROM beva_posts INNER JOIN beva_postmeta ON ( beva_posts.ID = beva_postmeta.post_id ) WHERE 1=1 AND (
beva_posts.ID NOT IN (
SELECT object_id
FROM beva_term_relationships
WHERE term_taxonomy_id IN (1)
)
) AND (
( beva_postmeta.meta_key = 'details_land_koppeling' AND beva_postmeta.meta_value LIKE '{7676272a9b0cdf0e41c2415b4eb485868847825a24c6cb2b63d6e3518173cd7d}\"138936\"{7676272a9b0cdf0e41c2415b4eb485868847825a24c6cb2b63d6e3518173cd7d}' )
) AND beva_posts.post_type = 'post' AND ((beva_posts.post_status = 'publish')) GROUP BY beva_posts.ID ORDER BY beva_posts.ID DESC LIMIT 0, 24
As you can see the percent sign get hashed. With this it is obvious I don’t get any results. Is this a problem with the ACF plugin? After searching in Google I found this has something to do with: https://make.wordpress.org/core/2017/10/31/changed-behaviour-of-esc_sql-in-wordpress-4-8-3/
Could this be fixed or is there someone who can tell me where to change temporarily some ACF code?