WordPress query by category, sorted by custom field

I don’t think there’s an easy to sort by three different meta values, and really, I don’t see why you need to in this case. Why not just save the event date in one meta value and sort by that? It makes your query much more efficient (removes two unnecessary joins) and lets you use the WP_Query orderby field to sort your posts rather than writing a custom query or filtering each of the SQL clauses of the query to make it do what you want.

Related Posts:

  1. How to fix pagination for custom loops?
  2. WP_Query vs get_posts
  3. Remove the Homepage Query
  4. simple sql query on wp_postmeta very slow
  5. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  6. wordpress query – orderby child post date
  7. Compare two numeric custom fields
  8. Custom query filter not working on woocommerce category page
  9. How to delete a transient on post/page publish?
  10. Transient not working for custom loops
  11. How to extract all ID variables from a query string?
  12. WordPress creating excessive joins on meta_query with search
  13. How to display liked posts of current user in wordpress?
  14. How to tell if $query_var isset?
  15. If No Search Results, Show Posts from Alternate Search Query
  16. Remove Unnecessary Mysql Query
  17. Grouping related postmeta data via SQL query
  18. Does meta_query work within get_posts array?
  19. Slow meta_query with about 4 milion record on wp_postmeta
  20. How to show more than 5 posts?
  21. WordPress Find Duplicate Post By Content
  22. WP Query Sort by meta value (date)
  23. mySQL query. ORDER BY meta_key
  24. how to query multiple categories in wordpress?
  25. Disable the MySQL query in the main query
  26. Strange string in console from wpdb query
  27. Update slug (URL) of pending posts via phpMyAdmin
  28. How can I get the query that would be run for the archive page?
  29. Query metas (and not : query posts by metas)
  30. Select query for a login
  31. What’s wrong with my $wpdb prepare?
  32. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  33. where should I reset query after using get_results?
  34. Query last updated posts (posts updated in the last 24 hours)
  35. Exclude featured image and custom field from this get_attachment query
  36. wpdb print all post meta
  37. Form and custom query problem
  38. Export Specific User data without plugin
  39. How to write: $wpdb->update having WHERE NOT value pair in the array
  40. Exclude all sticky posts front page twenty twelve
  41. Include current post into loop
  42. wpdb COALESCE won’t work
  43. Loop inside query
  44. get csv of users with user_meta
  45. Custom SQL Query passing array to WHERE p.id
  46. Query does not return content
  47. WordPress query undefined offset in loop
  48. Issue with custom loop in Archive page
  49. Query posts dynamic date range
  50. Parse query filter in wordpress and relation
  51. Waypoints + infinite scroll with custom query
  52. get posts by tag to showing in a widget
  53. Mysql query not working on WordPress 4.2.2
  54. get_post_meta with WP_query
  55. List WordPress Post and Related Attachments outside of a post page
  56. How properly create a blog template for wordpress?
  57. Is there a way to add a link directly into this media query?
  58. Problem on displaying the results on my query
  59. Improve performance of slow query
  60. WordPress search in modified post title
  61. meta_query not working
  62. Cannot get sql request from Query object?
  63. WordPress query: merge meta key (number) values and sort
  64. Heavy meta query causing SQL crash
  65. Question about of query
  66. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  67. Modify behaviour of “s” parameter in wp_query
  68. Speed up search query that searches in post meta?
  69. How to make MySQL search queries with quotes
  70. Limiting a filtered query
  71. Alternative layout the loop
  72. Ordering Posts by parent category, name ascending
  73. Show posts by tags excluding current post
  74. Advanced Post Display/Pagination/Ordering
  75. Archive query not working correctly
  76. Custom MySQL Query for Post and Post Meta
  77. How to fix pagination for custom loops?
  78. meta_query dates from an array
  79. Displaying popular posts
  80. Pagination not working with custom loop
  81. How to have more post in a page than in your home page
  82. Detecting top parent category fails on home page
  83. Find all posts via SQL beginning with A of type B
  84. learn to run wpdb class
  85. Display old posts if no future posts exist
  86. Access Tables with number prefix
  87. how to add a read more button to my blog page?
  88. Can’t See Media Queries with Inspect Tool [closed]
  89. How to add multiple values with add_query_arg?
  90. Query parsing only author ids
  91. 3 queries to update WordPress
  92. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  93. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  94. update $wpdb one query
  95. Admin Post List table Query filtering “WHERE” for custom post type
  96. Ascending & descending posts on same page with IF statement
  97. Prevent executing query for wp_global_styles
  98. How to use a dynamic term id for the query block
  99. Meta Query compare with LIKE pulls similar post types: 55 and 155, and 1,155
  100. Query Loop Block: possible to restrict just child pages?