WordPress meta_query and order by custom field

I discovered the problem by inspecting the actual SQL created by WP_Query. I realized that the generated SQL query has 2 INNER JOINs, one for the meta_key and another for the actual meta_query.

Basically on one hand it is filtering those films that have a showings_%_start_datetime in the next seven days, and on the other hand (independently) it is ordering the films by their showings_%_start_datetime value.

Just moving the meta_query parameters to the base query works fine:

query = new \WP_Query( array(
    'numberposts'   => -1,
    'post_type'     => 'film',
    'meta_key'      => 'showings_%_start_datetime',
    'meta_value'    => array( time(), strtotime( '+7 days' ) ),
    'meta_type'     => 'NUMERIC',
    'meta_compare'  => 'BETWEEN',
    'orderby'       => 'meta_value_num',
    'order'         => 'ASC',
));

Related Posts:

  1. Display List Of Posts Containing a Relationship Field Value [ACF]
  2. Using OR conditions in meta_query for query_posts argument
  3. ACF Relationship Field Search Filtering [closed]
  4. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  5. Revolution Slider Orderby Two Custom Fields
  6. meta_query with array as value
  7. query posts in functions.php and update a field
  8. Minimising number of queries on a page when using Advanced Custom Fields
  9. Query Posts depends on custom field inside repeater field using acf
  10. ACF Relationship + WP Template Parts
  11. Minimising Database Queries when using Advanced Custom Fields
  12. ACF – Get lowest & highest value from field
  13. If two first numbers exist in wp_meta_query value
  14. WP_Query meta_query >= date
  15. How To Fix WP Query Returns Results But Shouldn’t?
  16. ACF Date Based wp_query
  17. Multiple taxonomy And acf filter group by
  18. Custom query based on meta key – Reduce three states to two in results?
  19. Include custom field in Ajax search WordPress
  20. What is the random string I am seeing when I use get_query_var?
  21. Any number in meta key (wp query)
  22. How do I run through a WordPress loop called from a filter function?
  23. How can I display a custom field from all posts and order them individually from their parent post
  24. Is there a way to work with a specific the_field from an already queried post? [closed]
  25. How to Union two different conditions in one WP_Query
  26. Excluding pages in WP_query using ACF
  27. How to do a wp_query with two acf-fields, sorting on one of them
  28. Using Advanced Custom Field for file upload, how do I load the file url
  29. Multisite wp_query & switch_to_blog issue
  30. Stuck in the query loop
  31. Get all fields inlcuding “ACF” (Advanced Custom Fields) columns in wp_query
  32. WP_Query with meta_query dosen’t return results
  33. wordpress ajax relationship query
  34. Is there a better way to pull in custom content without querying posts?
  35. Include post content of linked posts in search
  36. WP User Query with Custom Fields and Search Results
  37. ACF accessing a field from the query, but not in post
  38. filter wp_query result with custom field values
  39. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  40. Merge 2 custom post type posts and taxonomy terms and sort ascending
  41. Add ACF field in a query
  42. JSON – Create rest api endpoint for Advanced Custom Fields
  43. Expecting statement error from php loop using ACF plugin
  44. Custom query filter by ACF date custom field
  45. Get a list of ACF Repeater-Fields as array
  46. WordPress dynamic AJAX query
  47. WP Query orderby ACF boolean values and ACF field value
  48. Optimising WP_Query with ACF Fields
  49. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  50. Multi-layered WP_Query
  51. Oxygen Repeater Advanced Query
  52. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  53. Nearby locations using Advanced custom fields, maps?
  54. WP_Query – display posts by custom field and order by another
  55. WP_Query for distinct meta values
  56. Group Product Types
  57. WPQuery Date and ACF
  58. Excluding posts from search results page with meta query not working
  59. Populate select list with meta values from all posts of a Custom Post Type
  60. Form checkbox value going to dynamic URL
  61. ACF: How can I publish values of ACF fields in a loop while using wp_query?
  62. WP Query by variable custom field
  63. create custom shortcode wp and put php code in
  64. Query for getting posts with their custom fields data in WordPress
  65. Why does my output of get_the_ID() change after a wp_query?
  66. How to get taxonomy image attached to a Post Type WordPress
  67. How to rearrange posts based on input field values added by WordPress “Advanced Custom Fields”
  68. WP Query with meta queries
  69. Custom query showing all acf field values instead of the one searched
  70. WP_Query, ACF field and array
  71. Pre get posts sort by meta key returns no results if meta key does not exist
  72. How to query wordpress with array of meta_values?
  73. ACF query-pass field value
  74. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  75. Limit default Search query to post_title
  76. Query string order by custom field
  77. ACF: using two loops, the_field returns field content from another loop
  78. Get posts meta_query by repater field
  79. How can I modify standard search query to include also ACF custom fields values?
  80. Wrap group of wp query posts to parent div by date/year
  81. Object of class WP_Query could not be converted to int inside shortcode
  82. Wrote a WP Cron Plugin and it triggers a fatal error upon activation
  83. WP_Query within save_post doesn’t include the item that triggered the action?
  84. Issue in If else condition [closed]
  85. Can’t get the_content to show
  86. Geo location query inside wp_query?
  87. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  88. Get the type of an advanced custom field (ACF) in a WP_Query loop [closed]
  89. Query posts filter not working
  90. Creating array to compare custom field values
  91. Display all custom meta field values from the database using ACF Repeater
  92. Output ACF field dynamicaly within a taxonomy loop [closed]
  93. Get posts using multiple values from ACF checkbox as meta query wordpress
  94. I want to place a post before all others from an ACF boleen field
  95. How do I subquery with custom meta fields?
  96. Best performance for use Custom Field in WP
  97. Use value from meta key array for use in WP_Query
  98. WP_query shortcode inside acf Repeater breaks the repeater loop
  99. Using WP_Query with multiple loops on one page in search.php
  100. Sort by price wpdb

Leave a Comment

error code: 523