last_name + first_name orderby with meta_query [solved]

To do this you need to use named meta query clauses according to the official developer docs for WP_Query:

‘orderby’ with multiple ‘meta_key’s

If you wish to order by two different pieces of postmeta (for example, City first and State second), you need to combine and link your meta query to your orderby array using ‘named meta queries’. See the example below:

    'meta_query' => array(
        'relation' => 'AND',
        'state_clause' => array(
            'key' => 'state',
            'value' => 'Wisconsin',
        ),
        'city_clause' => array(
            'key' => 'city',
            'compare' => 'EXISTS',
        ), 
    ),
    'orderby' => array( 
        'city_clause' => 'ASC',
        'state_clause' => 'DESC',
    ), ) ); ```

https://developer.wordpress.org/reference/classes/wp_query/#order-orderby-parameters

This question was also asked and answered already here:

Order by multiple meta key and meta value

Related Posts:

  1. User Relationship
  2. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  3. WP_User_Query Orderby Not Working
  4. wp_user_query with meta_value_num for leaderboard
  5. How to check a single number value against an array of meta_key values?
  6. WP_User_Query with combined meta query – not working?
  7. meta_query key value from array
  8. Order by nested named meta queries with ‘exists’ and ‘not exists’
  9. Arrange Posts By Date In Order Of Closest To The Current Date
  10. WP_User_Query with meta_query array relation ‘OR’
  11. List of posts by day of the week
  12. WP User Query fails when searching meta queries and search columns
  13. How to pass user meta_key and meta_value (values as array)
  14. Custom post type archive with rand and meta_value
  15. WP User Query Issues
  16. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  17. Orderby doesn’t work like expected on custom query
  18. meta query based on month regardless of year
  19. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  20. meta query or with meta value
  21. how to search all user meta data that have value like “vivek”
  22. wordpress meta value compare between two date
  23. get_users with Serialized Custom Meta Value
  24. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  25. meta_query compare “=“ returns nothing when it seems it should
  26. Order resultset by configured value and then list all the rest
  27. Issue with user meta_query
  28. How to do WP_User_Query for Nested Array value Inside Nested Array field
  29. get_user can’t read variable
  30. meta_query check multiple date formats
  31. WordPress meta query with meta serialized data array value
  32. meta_query orderby sort multiple keys
  33. Reading Content in an Array as it relates to a meta_query
  34. Why does this incorrect pre_get_posts meta_query work for sort order?
  35. Trouble with calling an imploded variable in an array
  36. Query for user roles and their skills
  37. meta_query for user ID in array
  38. WP User Query with meta queries
  39. How to fetch WP_User_Query with multiple role arguments [duplicate]
  40. Display Users from two roles in one list
  41. Sort users by custom user meta value
  42. how to get list of all users and their metadata
  43. Get result from meta_query() between two numbers
  44. Custom WP_Query order by post_meta and (author) user_meta
  45. Getting all user metadata from user
  46. get_users meta_query
  47. Meta query interfering with orderby relevance
  48. WP REST API: Order posts by meta value (acf)?
  49. Return posts with specific meta key first, but the rest in alpha order by last name
  50. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  51. How to exlude posts that have certain meta_value?
  52. Order WP Query posts by custom order calculated from post meta values
  53. Meta query with order by another custom field
  54. Can an array be used as a meta_query value?
  55. sort by date in Advanced Custom Field
  56. WordPress Core – Optimizing meta_query generated SQL?
  57. How to insert new element to existing array in usermeta?
  58. Author list ‘special’ author first then ‘normal’ author
  59. Complex WP_User_Query call fails on production server
  60. WP_User_Query ignoring ‘meta_query’ arguments
  61. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  62. get_*_meta doesn’t always return an array
  63. How to orderby multiple meta fields if some fields are empty
  64. WordPress, fetching users with an exact match in a string of comma separated values in user_meta
  65. Display a CPT based on a metabox selection
  66. How to query post only with different excerpt?
  67. How to use meta query for greater than value in array?
  68. Wp Query custom search by meta query
  69. Filter posts by meta query?
  70. How to filter a query by multiple meta keys and order by other meta keys
  71. How to get all users by custom current user meta (array)?
  72. Ordering posts by custom field named “date” in backend
  73. Meta query date column add [x] days to validate
  74. Grouping posts by a custom meta value
  75. How to combine two get_users() array?
  76. Advanced WP_Query with meta_query, orderby?
  77. How to get user ID’s from multiple usernames?
  78. WordPress query reverse order
  79. Array of user ids to list of user names
  80. get Insert id for meta field
  81. meta_query returning excluded result
  82. How to cache the results of a query and display the cached results
  83. Counting instances of words in the results of a post query
  84. Trouble with serialized metadata
  85. How to count items of meta query?
  86. wordpress meta query with multiple meta condition causing a load on server and slows down the server..!
  87. Multiple meta key and value search in the query
  88. Memory Leak in Processing Large JSON file
  89. get_users when from meta key that has serialized values
  90. like_escape notice when using LIKE in meta query
  91. Extend WP_User_Query or WP_User to return all custom fields?
  92. Querying by meta key and value
  93. How to compare date in post meta value
  94. Sort posts by post views and consider meta key
  95. Order posts with custom taxonomy array
  96. Sort Posts with custom meta key by default which is currently set as optional
  97. WP_Query with several meta_query-statements and order by meta_value
  98. WP_Query orderby meta key/value suddely stopped working
  99. Unable to do WP_User_Query with meta filter
  100. How do I have multiple metaqueries inside one wordpress query