Sort by meta key within same day

So here is a quick solution – with a bit of searching over SO and query analyzing : Keep the main query, but add a special filter for ordering.

The filter (in function.php) :

function my_posts_orderby( $orderby ) {
  $orderby = 'DATE(wp_posts.post_date) DESC, wp_postmeta.meta_value DESC';
  return $orderby;
}

Note the DATE() mysql function that takes the date out of the full time field.

And then, before the loop, run the query thus :

<?php add_filter( 'posts_orderby', 'my_posts_orderby' ); ?>

<?php $the_query = new WP_Query( array( 'meta_key' => '_my_meta_field' ) ); ?>

Wich means, call the filter, and then create a query that includes the custom meta field so that it can be sorted.

Then, after the loop, don’t forget to call

<?php remove_filter( 'posts_orderby', 'posts_orderby' ); ?>

failling that no other query will ever work (including displaying a single post)

And that works.

Related Posts:

  1. Order by optional meta key?
  2. Filtering by multiple conditions in the loop
  3. Orderby two meta fields not working
  4. Can wp_query return posts meta in a single request?
  5. order by numeric value for meta value
  6. How do I query for posts by partial meta key?
  7. Use REGEXP in WP_Query meta_query key
  8. WP_Query orderby date not working
  9. Order by DESC, ASC in custom WP_Query
  10. Secondary Sort (fallback) for WP_Query
  11. Is there a way to extend WP_query so Custom Post Types can have properties?
  12. Query Posts in a Predefined Order
  13. Getting attachments by meta value
  14. WP_Query displaying ALL posts
  15. meta_query where value is equal to given value
  16. How do I order pages and categories by ID or name in the same query?
  17. WP_Query ordered by custom field that is a date string?
  18. WP_Query not working as expected for attachments and custom meta_query
  19. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  20. Group posts by meta_key
  21. Order posts ascending with number in title
  22. List taxonomy terms plus their latest post ordered by post date
  23. WordPress altering my custom query, How to fix it?
  24. WP Query post meta value
  25. Would this post meta be better added to the post table rather than post_meta table
  26. Custom URl parameter
  27. Compile meta values from custom loop into array and then calculate sum total
  28. Best approach to create Hot and Trending sections
  29. WP_Query order by date in meta_value
  30. How to use order RAND() on WordPress?
  31. Order posts by meta value and Date
  32. Show all parents and children in custom post type in right order
  33. Efficient way to update multiple post meta
  34. How to make orderby ‘meta_value_num’ OPTIONAL?
  35. Meta query with order by another custom field
  36. WordPress WP_Query orderby being overwritten
  37. Order Posts by meta value AND published date
  38. How can I pick a single post from the latest 3?
  39. Query post with meta_query where date is not in future
  40. Order WP_Query by multiple fields, subtracting them from one another
  41. pre_get_posts order by not working
  42. Group WP_Query by meta_key date
  43. WP_query posts closest to todays date
  44. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  45. Order By table field comment_status in WordPress > 4.0
  46. WP_Query order result by date AND meta_value
  47. How can I sort posts by the date and a custom meta field?
  48. Order by title without taking into account ‘the’
  49. Using hook to use DISTINCT in a wp_query
  50. WP_Query orderby author__in
  51. How to orderby multiple meta fields if some fields are empty
  52. Fetch Record based on meta key dates
  53. Weird orderby => post__in issue
  54. Where to put meta Keys
  55. Large AND OR query timing out
  56. How to order posts by title after they have already been sorted by category
  57. meta_value_num not ordering all items
  58. How to filter a query by multiple meta keys and order by other meta keys
  59. Multiple Orderby’s using random order WP_Query
  60. Debugging wp_query orderby for taxonomy
  61. WP Query – order posts by meta field first and then order the rest
  62. Filter posts by comparing custom meta value against postdate
  63. Order is breaking wp_query
  64. How can I update post meta inside a WP_Query loop or the WordPress loop?
  65. Display count number of posts with the same specific meta_key meta_value
  66. Query posts by searching for a string in a meta field
  67. orderby ignored by wp_query
  68. How do i create a custom post query when the meta value is an array?
  69. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  70. Meta query ignores multiple values of the key
  71. Custom order of posts in wp_query and different taxonomies
  72. WordPress Query custom ordering by temporary variable
  73. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  74. Query Order By Number Variable From API
  75. How to get_comments() ordered by date and parent?
  76. Order 2 meta_queries differently in WP_Query?
  77. WP Query. Ordering posts by another post types meta
  78. Look for string in posts and postmeta
  79. Query postmeta based on meta_value, return array of post_id
  80. update_post_meta() not updating
  81. Best way to query posts and order by relevancy to query
  82. Order & Orderby clause not working with custom query
  83. wp_query sorting – one specific meta_key value at last and then sort by create date
  84. Meta key in wp_query bug?
  85. Order posts by more than one variable (meta_key and publish date AND time)
  86. Create custom order sortby based on array of id
  87. WP Meta Query at depth 2
  88. WP_Query with child element
  89. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  90. Order Custom Field by Price
  91. Sorting Posts with meta value not working
  92. Show sticky post before other WP_Query
  93. Order by multiple meta keys on wordpress
  94. How to query post ids liked by the Author
  95. loop through custom post types with meta data
  96. WP_Query with several meta_query-statements and order by meta_value
  97. WP_Query by meta key not returning any posts
  98. Why does wp_query only display the most recent post when using order ASC?
  99. Extend search query to search meta keys values based on search string
  100. new WP_Query with order args – no more distinction between categories
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduseduedueduedusedueduseduedus