How to order posts by one custom field and filter them by another one?

This is not going to work, because you are setting same meta_key parameter twice with different values and only one will be effective.

Rather than building raw queries it is better to use filters to modify WP query. Query Overview documentation has list of hooks where you can insert your mods (as the end under What Plugins can Modify).

Related Posts:

  1. Add filter menu to admin list of posts (of custom type) to filter posts by custom field values
  2. Is there any action filter/hook for validating a custom field before publishing the post?
  3. Filter WP_Query for posts having a certain meta-value
  4. Apply the_content filter to a custom field with multiple values
  5. Pass all custom fields through the same filter on post load?
  6. Filter results with custom field values and dropdown
  7. Archive sorting functions by custom fields (front-end)
  8. Change content before writing to database
  9. WordPress Search Custom Meta Field Only
  10. How do I assign this filter to a variable? (Appending php & markup to the_content)
  11. Using custom fields in a filter hook
  12. Add an advert every nth Paragraph
  13. How to filter a dd/mm/yyyy date from a custom field in a query
  14. Force hide custom field metaboxes
  15. Saving custom profile fields
  16. Update posts after populating ACF field value [closed]
  17. How to validate custom field on lost password form before the user id field?
  18. Sorting WordPress Posts via Custom Field Values?
  19. filtering custom post types via meta data drop down
  20. global function to apply filter to custom field
  21. Filter multiple custom fields Values with Check boxes
  22. How to get categories with posts by custom field value?
  23. How to Wrote Simple Calculations by Using Custom Fields in Loop?
  24. Best filter to use for modifying custom fields on a post?
  25. How to display childrens custom fields?
  26. Access ACF fields within custom preview function?
  27. Sort posts by clicks on download button
  28. Let Users Filter Posts by Custom Fields
  29. Custom Theme Fields in Settings Menu – apply filters to one of those fields?
  30. Footnotes in custom fields
  31. How to change permalink on headlines in rss feeds?
  32. How to change order of posts in admin
  33. How to query posts by month based on date custom field?
  34. Filter or order based on custom field
  35. How to show ACF fields in Gridbuilder custom block
  36. WP meta_query args not working in function
  37. User Filter Options on Archive Page
  38. How to add content with a filter when there’s no content in the editor
  39. Admin – Search Events by a custom field
  40. change attachment custom field onChange event
  41. Filter and display a specific custom field value [closed]
  42. How to filter post using custom feild value in shortest and longest duration?
  43. Query Posts Via WordPress URL
  44. Checking if field is set before comparing with meta_query in query_posts?
  45. Create widget that filters posts on current page based on entered value
  46. Including inline Custom Fields info with add_filter in functions.php
  47. Sort posts after filtering them through multiple taxonomies
  48. Set new url from custom post field
  49. Add a Jquery Datepicker to custom field in post edit
  50. How can I avoid re-inventing the Custom Fields wheel in my Plugin’s Metabox?
  51. Does wordpress have something like content-type?
  52. Order Posts by Closest Numeric Values
  53. How to get and edit custom fields if in Quick Edit
  54. Create additional short URL with custom field and 301 redirect
  55. Create custom field on post draft or publish?
  56. get_post_meta fields don’t show up on posts page
  57. Function to change meta value in database for each post
  58. Include woocommerce custom field value in front-end search result
  59. WP_Meta_Query causing long-running MySQL queries
  60. MySQL Query that looks for post with Custom Field, then changes Category
  61. Woocommerce: Custom fields and email shortcodes, ec_custom_field
  62. Tweak Meta for Post to work it for Pages also
  63. Create Pop-Up Box with Custom Field Content Inside the Loop
  64. Adding an editable field to template?
  65. Transferring author information from a custom field to a proper author
  66. How to select posts from multiple categories and metavalues?
  67. How do I Implement Atomic Update of Post Metadata?
  68. Custom fields value
  69. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  70. Want to make A CSS if meta key value is empty
  71. Add & store extra fields – WordPress Comments
  72. Outputing a metabox textarea and avoid line breaks inside li tags
  73. Restrict WordPress Search to Custom Field
  74. how to display an excerpt of the latest post on the homepage?
  75. How to add a custom field to a post created programmatically?
  76. Custom post type missing custom fields
  77. Problem with saving large amount of data in postmeta/usermeta
  78. How to get posts with a metadata numeric key greater than X?
  79. “Matching” or “Linking” Two WordPress Pages: Custom Fields?
  80. Meta_query ‘compare’ => ‘LIKE’ not working?
  81. Get text from user and display it on page
  82. Upload & include specific JavaScript files for posts?
  83. If metabox has content display content
  84. Custom meta boxes not saving
  85. Listing the most popular 8 city (custom fields) as used in posts
  86. How to delete file uploaded by Plupload
  87. Display Meta Data with HTML?
  88. Order by custom date field
  89. Group Posts By Custom Meta Value: Date
  90. Meta field bulk editing no longer working in WP 6.0 [closed]
  91. Custom Field: how to save array of multiple key-values in WordPress
  92. Delete user meta but only if found in array
  93. Custom field in media library not saving, selected() function not adding “selected” to select list input type
  94. meta_query to check all custom fields
  95. Show Custom Taxonomy as Headline for related posts
  96. Custom field group on page
  97. display Flexible Fields from options
  98. list pages by custom_field?
  99. Get custom field from page, in a post?
  100. Advenced custom fields auto fill problem