Order posts by date and then by custom field

  add_filter('posts_orderby', 'posts_orderby');

  function posts_orderby($orderby_for_query) {
        global $wpdb;
        $prefix = $wpdb->prefix;
        $orderby_for_query = "LEFT(" . $prefix . "posts.post_date, 10) DESC, " . $orderby_for_query;
        return $orderby_for_query;
    }

This produces this query:

SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1  AND wp_posts.post_type="post" AND (wp_posts.post_status="publish") AND (wp_postmeta.meta_key = 'my_post_rating' ) GROUP BY wp_posts.ID ORDER BY LEFT(wp_posts.post_date, 10) DESC, wp_postmeta.meta_value+0 DESC

Related Posts:

  1. Sorting posts by custom date fields (non standard date format)
  2. Revolution Slider Orderby Two Custom Fields
  3. Order Posts by meta value AND published date
  4. Understanding the orderby in WP_Query?
  5. Order by empty custom field
  6. meta_value_num not ordering all items
  7. Sorting posts by Multiple custom fields in defined order
  8. Order 2 meta_queries differently in WP_Query?
  9. Order Custom Field by Price
  10. query_posts with sorting on a custom datestamp
  11. WP_Query sort by ACF date field (newest first) with blank dates first
  12. WP_Query orderby post__in remains ineffective in the Loop [closed]
  13. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  14. Sorting: custom query with orderby meta_value_num THEN by title
  15. Custom WP_Query order by post_meta and (author) user_meta
  16. How to order posts tag by tag?
  17. WP_Query sort by comment meta data
  18. Trying to perform complex custom field query with order by set to field value
  19. WP_query ‘orderby=none’ Problem
  20. Sorting Posts by custom field
  21. Query two post types and order by two different date fields
  22. Order by the results of a function with WP_query
  23. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  24. How to order posts in wp_query by a meta_value of the corresponding author
  25. Order by menu structure
  26. meta_key and meta_value not working together
  27. Ordering by meta_value AND date NOT WORKING with wp_query
  28. WP_Query orderby breaks when using AJAX?
  29. Order WP Query posts by custom order calculated from post meta values
  30. Custom Post order for homepage
  31. Change default ordering of taxonomy terms – pre_get_terms
  32. Ordering Posts Type A by Custom Fields of related Post Type B
  33. Wp query orderby ‘title’ doesn’t work
  34. How can I order Wp_Query hierarchically?
  35. Sorting posts DESC based on the number of comments using WP_Query
  36. Search Posts with Custom Fields as query
  37. exclude posts with a specific custom field and value
  38. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  39. How to make Meta Query case sensitive?
  40. Complex WP_Query order request: DESC by day, but then ASC by time
  41. WP_Query orderby not working with meta_value_num and menu_order
  42. Sort wordpress custom posts based on meta value
  43. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  44. meta_query BETWEEN, but the range is stored in the custom field
  45. Get a list of posts with associated meta_value
  46. WordPress Comments sort by custom meta key
  47. Order by summing multiple values
  48. How to list custom fields as headers and list all pages sharing that custom field under it?
  49. Order ascending is ignored in meta query?
  50. Search posts missing a particular custom field
  51. How to Order a list of taxonomies? orderby?
  52. Conditional operator OR not working with custom fields
  53. WP_QUERY with group by with custom fields
  54. Intiger meta value with ‘>=’ returns posts with lower value
  55. Posts query according to meta box date
  56. create metabox to activate slider
  57. Query posts using less than
  58. Query only displays one page_id
  59. Child pages not affected by orderby
  60. Display post meta conditionally based on it’s value
  61. Query using string from custom field as array value
  62. How to show list of posts with custom field value (a date) that are coming soon
  63. Randomly select one of last 3 posts
  64. WP_Query orderby random do not repeat infinite scroll – one loop
  65. how to retrieve WP_Query without ordering by date [duplicate]
  66. meta_query weird behaviour, static int will work, but not user data
  67. Woocommerce Shortcode which displays a table with product data
  68. WP_Query orderby
  69. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  70. How can I order a post query’s results based on the number of matching taxonomy terms?
  71. How to sort store location by specific category order in WP store locations
  72. Query posts by post type, author and post meta
  73. How to use the Term Object from a custom select field in a query
  74. How to sort wordpress posts already selected by WP_QUERY
  75. Trouble with serialized metadata
  76. WP_Query random ordering not working since 5.4
  77. Meta query orderby meta_value_num sorting by role first
  78. WP Query with meta queries
  79. Query post by Category and custom file (ACF)
  80. Problem with my loops
  81. Sort posts on custom field AND after that sort on date?
  82. Query by meta value (add a dropdown of all values)
  83. WP_Query sort by meta_value_num or date
  84. How to order posts, that have already been filtered by custom taxonomy, by their category names?
  85. Display three sequential posts on each page load, without repeating previous
  86. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  87. WP_Query with Pagination and orderby meta_value_num showing duplicates
  88. Using orderby with 2 meta keys
  89. Custom search (wp query by custom fields)
  90. How do I display posts with specific value in a custom field into my loop?
  91. $args Orderby The number
  92. Custom Search Query – include only custom fields and title
  93. Order by multiple meta keys on wordpress
  94. WP_Query with several meta_query-statements and order by meta_value
  95. WP_Query – order with usort by custom meta
  96. Get posts that were most recently tagged
  97. Why does wp_query only display the most recent post when using order ASC?
  98. How to include custom fields in wordpress search
  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

Leave a Comment