Custom WP Query with neither ASC or DESC

Don’t think the effort worth it to do it with generating appropriate mysql statements as you can just use three queries, or sort the posts after you have the results of the query with both ways resulting in a mostly readable code. Main reason not to choose the above is if performance is critical.

Another option is to use some different meta field and store some integer value representing the 3 states, but if you are using a plugin that generates the property value status this might be hard work to figure all the place in which the new meta field can be added.

And if you feel like a mysql guru you can probably order by the value of FIND_IN_SET. You will need to figure out which filter to use to override the
query. One pointer is this snippet – https://gist.github.com/mikeschinkel/6402058#file-find-in-set-php but I didn’t inspect that code.

Related Posts:

  1. WP_Query with “post_title LIKE ‘something%'”?
  2. Best way to detect if you are in a SINGLE POST page
  3. compare meta_query in get_posts arguments
  4. How to do a wp_query using “BETWEEN” with two meta_values?
  5. Better way to get tag stats?
  6. Query two taxonomies via URL or link?
  7. How do I order pages and categories by ID or name in the same query?
  8. wp_query order by title
  9. How to do a query only on a specific admin page?
  10. Sort posts by custom taxonomy name
  11. How to adjust found_posts so that it accounts for offset and pagination
  12. SQL query equivalent to WP User Query
  13. Function to check if author has posted within the last x days
  14. Wp_query order by multiple custom fields?
  15. Would this post meta be better added to the post table rather than post_meta table
  16. Show default content if custom WP_Query has no posts
  17. WP Query for Posts (Products) in Specific Category that has 2 Specific Tags (*AND* both tags not *OR*)
  18. meta_query on a date range using an array of values
  19. Pagination for custom query on single.php
  20. Get product list of given category
  21. Remove ellipsis from the excerpt retrieved using get_the_excerpt()
  22. Query Ignoring ‘exclude’ Parameter?
  23. WordPress query vars are not added
  24. How to prevent writing duplicate loops?
  25. merge two query arguments into one WP_Query call
  26. Adding a parameter to the default query
  27. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  28. Taxonomy search/filter with multiple taxonomies and multiple taxonomy terms
  29. Alternative to query->set that appends conditions instead of overriding
  30. While creating Block Themes in WordPress, how can I query custom posts for an Archive view?
  31. How To Fix WP Query Returns Results But Shouldn’t?
  32. why update and delete query not worked in custom table?
  33. get_users is missing or skipping over users in loop
  34. Weird orderby => post__in issue
  35. how to handle multiple ajax wordpress queries?
  36. problem by deleting new plugin installed inside the WordPress after any heroku app sleeping [closed]
  37. How to extract specific post
  38. Adding multiple meta_key fields as orderby options to a WP Query via a function
  39. wp_Qwery works to slow
  40. Search for “2nd” also returns “22nd” in wp_query
  41. 2 weeks ago from meta query meta value
  42. Running main loop 2 times with conditional statement
  43. paged variable not working for category/custom post archive
  44. How to output the title of the blogs home page
  45. Get posts by list of post IDs ordered by those IDs?
  46. Array as ‘key’ in WP_Query
  47. Reset WordPress Post Query to default
  48. Check the Specific Meta Key IF its Meta Value is Empty then… (WP Post Meta Query)
  49. Woocommerce – exclude only older out-of-stock items
  50. Searching for meta_key returns 0 posts
  51. Using custom taxonomies in a query
  52. ACF accessing a field from the query, but not in post
  53. What is the best way (regarding performance) to set transients for logged in users?
  54. List of ways to access WordPress database?
  55. Determining Author post count
  56. Is there a ‘compare’ option when using WP_Query apart from meta_query
  57. WP_Query returns different results from get_posts() [closed]
  58. How to pass query string vars between admin pages?
  59. Query posts by Post title
  60. Differentiate Nested WP_Query from Parent
  61. WP_User_Query and user posts
  62. Why do I have to use pre_get_posts with custom WP_Query to reset posts_per_page?
  63. WP order ASC in custom author loop
  64. Custom Homepage Pagination using WP_Query
  65. My website is getting too many dierect home arechives and this is increasing my bounce rate
  66. Get list of all Grandchild Pages
  67. get latest added term from taxonomy and insert into php variable
  68. Featured images loop for Orbit Slider
  69. Posts limit on homepage (genesis framework)
  70. Trouble passing attribute into shortcode function
  71. WP_Query return posts in wrong order
  72. Exclude post with taxonomy and from the terms (taxonomy & tag) posts count
  73. WordPress search WP_Query to cover multiple post types and their custom fields?
  74. How do i create a custom post query when the meta value is an array?
  75. How to do WP_User_Query for Nested Array value Inside Nested Array field
  76. How to use jQuery validation to set the search bar to accept only a specific input?
  77. Very slow query generated getting meta data from posts
  78. How to compare between two dates in a nested loop?
  79. How to query 5 users in random who have published more than 10 posts
  80. Limit default Search query to post_title
  81. Order & Orderby clause not working with custom query
  82. in tax_query this Is the code correct? I need to access beginner video posts for different subject
  83. How to redirect a query string to a “virtual” subdirectory
  84. WP_Query returns images but post_per_page is incorrect
  85. Problem with custom WP_Query and underlying pagination/posts_per_page
  86. Select posts wich has no relationship in custom taxonomy
  87. WordPress Query posts that have title > another title
  88. WordPress WP_Query offset parameter not working with search parameter
  89. Custom post type archive organized by category
  90. Adding page subdirectory dynamically, as like buddypress does
  91. orderby in WP_query doesn’t works
  92. Displaying content to search engines but via navigation only for registered users.
  93. Duplicate posts showing up in loop using infinite scroll
  94. WP_Query orderby not working on custom post_type
  95. wp_query->set for several categories
  96. Getting posts via WP Query
  97. Print post data inside loop using theme content template
  98. Where to find WP_Query class?
  99. WP_Query with tax_query not working
  100. How to know which editor published a post programmatically?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)