If orderby parameter using pre_get_posts is the same for multiple posts what fallback does the query use?

For identical values they’ll be in whatever order they’re returned by the database engine, which would typically be the order they were inserted in the database.

Anyway, the question you’ve linked is old, you can order by multiple columns with WP_Query:

$query->set( 'orderby', array( 'menu_order' => 'ASC', 'date' => 'ASC' ) );

pre_get_posts acts on a WP_Query instance and has the same parameters available to it, so whether pre_get_posts or a custom WP_Query is the correct choice depends on whether or not you’re trying to modify the main query.

Related Posts:

  1. When to use WP_query(), query_posts() and pre_get_posts
  2. Should I use Pre Get Posts or WP_Query
  3. Using pre_get_posts with WP_Query
  4. WP_Query orderby post__in remains ineffective in the Loop [closed]
  5. What is “main query”? [duplicate]
  6. Reduce or prevent calling of update_meta_cache
  7. How to add taxonomy filter on the query fly?
  8. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  9. How to uniquely identify queries?
  10. Order Search Results Page by meta_value If no Value Return Remaining Results
  11. pre_get_posts with get_posts
  12. How-to exclude terms from the main query the most performant way?
  13. Changing Posts Per Page and offset with pre_get_posts
  14. Slow SQL_CALC_FOUND_ROWS Query
  15. How do I order pages and categories by ID or name in the same query?
  16. “pre_get_posts” firing on every query
  17. RSS feed with specific keyword
  18. Using is_main_query to select custom post type on certain page
  19. Multiple orderby parameters in pre_get_posts() action
  20. SQL Statement generated by WP_Query not producing expected results
  21. Sorting Posts by custom field
  22. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  23. Query with pre_get_posts to get pagination
  24. Recommended way to drop a pending query (in pre_get_posts)?
  25. Single page theme that uses pages for the content
  26. WordPress altering my custom query, How to fix it?
  27. WordPress custom search form with pre_get_posts not work
  28. Can not switch the queried post in pre_get_posts hook
  29. How to target the default Recent Posts and Recent Comments widgets with pre_get_posts?
  30. order by multiple meta keys in pre_get_posts
  31. How to sort posts in admin by titles with dd.mm.yyyy format?
  32. WP_Tax_Query with post_tag not working
  33. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  34. How to Modify Taxonomy Archive Page with Search Parameter?
  35. Using pre_get_posts on a specific core/query block
  36. Searching through different categories on different pages code is not working
  37. How to display future posts – modified query still yields 404
  38. Change default ordering of taxonomy terms – pre_get_terms
  39. pre_get_posts filter meta_query without conflicting existing meta_query
  40. Including only current user’s posts in search
  41. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  42. How to change posts order on Category and Tag archives?
  43. Formulate a url to show posts with both taxonomy terms
  44. My Main Query Modification is Messing up my dynamic main – why?
  45. Offset Page Loops and Pagination
  46. pre_get_posts Remove tax_query Completely
  47. WP_Query Excluding pages with Order is 0
  48. pre_get_posts order by not working
  49. Adding a parameter to the default query
  50. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  51. Single meta_query query using OR instead of AND in request’s WHERE statement
  52. How to choose between hooking into per_get_posts or into parse_query
  53. Store sticky post’s ids in a transient
  54. How to change main query based on post meta
  55. new WP_Query to get max price meta value not working
  56. Display posts from only one post form in custom query and exclude in main query
  57. Show Sticky Post at the top but do not show again in the loop?
  58. WP_Query, pre_get_posts and offset
  59. Complex WP SQL Query
  60. Using meta_query with multiple keys and compare values
  61. How to set multiple `orderby` in query argument?
  62. Can I set my WP_Query to be a Main Query?
  63. Remove category from query (show all posts in archive.php) pre_get_posts()
  64. Why isn’t my multiple orderby working?
  65. Show scheduled posts in main loop but not in WP_Query?
  66. hide custom post types with specific meta key ON admin backend
  67. WP_Query ignoring tax_query when is_singular
  68. Woocommerce – Changing the order of the upsell products [closed]
  69. Applying posts_clauses filter to specific queries only
  70. Help ordering Post loop by two meta values
  71. Filtering out child category posts from parent category archive not working
  72. Order ascending is ignored in meta query?
  73. New WP_Query calls Pre_get_posts filter twice
  74. Shouldn’t I be able to modify the main query by this filter?
  75. How Can I Change The Tax Query For The Main Loop For Taxonomy Archives?
  76. using pre_get_posts for search results not found
  77. Hide elements outside loop based on query
  78. Woocommerce – exclude only older out-of-stock items
  79. WP Query – order posts by meta field first and then order the rest
  80. pre_get_posts – Trying to get property of non-object warning
  81. queried_object using pre_get_posts gets notices and warning
  82. date_query in pre_get_posts out of memory
  83. How I can change the condition or compare operator for WP_Query in pre_get_posts
  84. WP_Query – How to get all posts of specific days of week by custom field date?
  85. Multiple meta_key ordering with pre_get_posts
  86. Sorting search results with custom dropdown
  87. pre_get_posts – editing query, tax_query
  88. Child pages not affected by orderby
  89. How to apply pre_get_posts to a custom query?
  90. Sort posts in dashboard using custom field; also include posts where field isn’t set
  91. Looking for a way to exclude frontpage and nav menu from query filter
  92. pre_get_posts redirecting
  93. Avoiding page loop
  94. Custom post types loop on a page template
  95. Pre_get_post on CPT archive page
  96. Search query alteration not working for meta values
  97. Can I use WP_Query to find a post with a particular menu_order?
  98. How to put posts with some taxonomy on top of others in `pre_get_posts`
  99. When to use WP_query(), query_posts() and pre_get_posts
  100. How to choose between hooking into pre_get_posts or into parse_query

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)