How can I get posts by 2 meta keys, prioritising one of them?

How can I get posts by 2 meta keys, prioritising one of them?

Related Posts:

  1. Very slow query
  2. Does meta_query work within get_posts array?
  3. How to show more than 5 posts?
  4. How to optimize my query filtering out unwanted data?
  5. Remove posts from query for events whose start date has passed
  6. get_posts() loop returns the same the_title() for each post
  7. List all posts from past week grouped by sub-category
  8. Order posts by custom field DATE value
  9. How do I see the mysql query generated by get_posts( $args )?
  10. Create Indexes for Slow Queries
  11. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  12. pre saved posts query from db options table
  13. Re-sort get_posts query results
  14. Can I include get_posts in this array?
  15. Category_in return empty
  16. Sort order in get_posts [closed]
  17. When should you use WP_Query vs query_posts() vs get_posts()?
  18. How to display SQL query that ran in query?
  19. How can I create a meta_query with an array as meta_field?
  20. Query multiple meta key values?
  21. How to Optimize WP site for millions of posts
  22. Get the ID of the latest post
  23. How to get comments by post ID?
  24. WP_Query vs get_posts
  25. Differences between wpdb->get_results() and wpdb->query()
  26. Is there a way of increasing the speed of this query?
  27. Get all image from single page using this query
  28. How can I query all users who registered today?
  29. Get Terms by IDs with IDs order
  30. Reversing the order of posts AFTER the query is performed
  31. what are the numbers between curly brackets in search query
  32. simple sql query on wp_postmeta very slow
  33. Using WordPress public query variables
  34. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  35. When/why does ‘$query->get( ‘tax_query’ );’ return empty?
  36. How to get link and title of next and previous post on single page
  37. Create pagination and order according to alphabet
  38. wpdb get posts by taxonomy SQL
  39. How to List Events by Year and Month Using Advanced Custom Fields?
  40. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  41. How to organize and cache additional data associated with terms?
  42. wordpress query – orderby child post date
  43. How many WordPress SQL Queries per page?
  44. How to display Section for certain time
  45. Add multiple value to a query variable in WordPress
  46. Search custom post type by meta data
  47. Custom query_var causes displaying posts archive on front page
  48. How to know if get_posts() failed?
  49. Slow wp_enqueue_media()
  50. Multipart/formatted MySQL query problem
  51. What is the most efficient way of implementing a favorite post system?
  52. Remove [gallery] shortcode altogether
  53. Compare two numeric custom fields
  54. wp_dropdown_categories with multiple select
  55. Advanced Custom Fields – Query Efficiency
  56. Why does get_the_time(‘F j’) return November 30 for all posts?
  57. Get posts by meta data OR title
  58. Query by one meta_key and sort by another (possibly NULL value)
  59. How to tune search argument in WP_Query to show only exactly the same results?
  60. Custom query filter not working on woocommerce category page
  61. How to delete a transient on post/page publish?
  62. query multiple taxonomy and show post count
  63. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  64. Query & Sort Comments by custom comment meta
  65. How to get my loop to pull posts into three columns
  66. How to display lastest post date in the homepage?
  67. Custom $wpdb Query for Custom Post Type by Category
  68. Limit number of pages in pagination
  69. Get a user’s most recent post title
  70. Categories and products in random order
  71. add_query_arg() XSS Vulnerability
  72. Count user posts by user ID, Post type and Post status
  73. Can’t pass table to $wpdb->prepare
  74. Query set using tax_query with relation ‘OR’ modifies category object?
  75. $query->query_var[‘post_type’] not set for pages
  76. is_archive() doesn’t work on public query var archive pages?
  77. How to extract all ID variables from a query string?
  78. When add_query_arg() is necessary?
  79. Different Main Navigation per category
  80. How to get category link without a database query
  81. Insert html after certain amount of posts?
  82. wp remove query
  83. Show recent products first but “sold out last” in query
  84. WordPress creating excessive joins on meta_query with search
  85. How to display liked posts of current user in wordpress?
  86. Can not switch the queried post in pre_get_posts hook
  87. Filter query posts by the count of metas for a meta key
  88. How to tell if $query_var isset?
  89. Show All Posts Insert Edit Link
  90. $wpdb->get_var not returning a result
  91. search through post-type attachments titles
  92. How to count get_users query?
  93. Date query year and month OR just year
  94. cron job to auto delete posts of a specific post type older than x days
  95. Possible to get posts from multiple meta keys/values in a single query?
  96. Are database queries created using WordPress filters protected from SQL injection?
  97. Get IDs of posts currently visible on archive
  98. Get posts by category with pure SQL query
  99. can’t get query to order posts by acf datepicker
  100. WP_query category__in not working, only pulls from first category
File not found.