SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)

Solved. After the edit it was easy. It is allowed to use type => ‘decimal(x,x)’ in meta_query. Maximum precision is decimal(65,30).

https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html

array(6) {
  ["orderby"]=>
  array(2) {
    ["uss_product_price"]=>
    string(4) "DESC"
    ["title"]=>
    string(3) "ASC"
  }
  ["meta_query"]=>
  array(3) {
    ["relation"]=>
    string(3) "AND"
    ["sortprimary_clause"]=>
    array(3) {
      ["key"]=>
      string(17) "price"
      ["compare"]=>
      string(6) "EXISTS"
      ["type"]=>
      string(13) "decimal(30,5)"
    }
    [0]=>
    array(4) {
      ["key"]=>
      string(17) "price"
      ["value"]=>
      array(2) {
        [0]=>
        float(0)
        [1]=>
        float(9999)
      }
      ["compare"]=>
      string(7) "BETWEEN"
      ["type"]=>
      string(7) "decimal(30,5)"
    }
  }
  ["tax_query"]=>
  array(1) {
    ["relation"]=>
    string(3) "AND"
  }
  ["post_type"]=>
  string(7) "product"
  ["posts_per_page"]=>
  int(15)
  ["paged"]=>
  string(1) "2"
}

Related Posts:

  1. WP_Query with several meta_query-statements and order by meta_value
  2. Sorting: custom query with orderby meta_value_num THEN by title
  3. Custom WP_Query order by post_meta and (author) user_meta
  4. What is an efficient way to query based on post_meta?
  5. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  6. Advanced WP Query hogs the SQL server
  7. Order WP Query posts by custom order calculated from post meta values
  8. Meta query with order by another custom field
  9. Order Posts by meta value AND published date
  10. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  11. pre_get_posts order by not working
  12. Optional Meta Query
  13. How to orderby multiple meta fields if some fields are empty
  14. Order by summing multiple values
  15. Changing sort order for presentation by Jetpack infinite scroll
  16. Help ordering Post loop by two meta values
  17. Order ascending is ignored in meta query?
  18. meta_value_num not ordering all items
  19. How to filter a query by multiple meta keys and order by other meta keys
  20. Debugging wp_query orderby for taxonomy
  21. Advanced WP_Query with meta_query, orderby?
  22. WP_Query: apply an SQL function to meta fileld value
  23. Randomly select one of last 3 posts
  24. Sort posts using multiple custom fields and menu_order in single query?
  25. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  26. WP Query – grouping posts by same meta key, adding together values from another key
  27. WordPress Query custom ordering by temporary variable
  28. Meta query orderby meta_value_num sorting by role first
  29. WP_User_Query Orderby Not Working
  30. Sorting with meta_query and multiple, optional meta keys
  31. WP Query. Ordering posts by another post types meta
  32. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  33. wp_query sorting – one specific meta_key value at last and then sort by create date
  34. Best way to Order Post in Home without a plugin
  35. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  36. Using orderby with 2 meta keys
  37. Sorting: custom query with orderby meta_value_num THEN by title
  38. orderby in WP_query doesn’t works
  39. WP_Query orderby post__in remains ineffective in the Loop [closed]
  40. How to query posts based on lat-lng coordinate as post meta?
  41. Set Alias for meta_query arguments in get_posts()
  42. Is it possible to orderby multiple meta_keys when using meta_value_num?
  43. Is it possible to wrap Geo Location search around WP_Query?
  44. Using custom meta_query with relation not working as expected
  45. WP_Query meta_query where meta value ends in space
  46. Nested query inside Logical operator OR not working in meta_query
  47. SQL Statement generated by WP_Query not producing expected results
  48. How do I create my own nested meta_query using posts_where / posts_join?
  49. how to retrieve specific product attribute value in an sql query?
  50. Exclude post on loop by multiple meta key value
  51. WP_Query order by date in meta_value
  52. Order posts by meta value and Date
  53. Query sticky posts with thumbnails
  54. Show all parents and children in custom post type in right order
  55. List of posts by day of the week
  56. WP User Query get all authors with last name starting with specific letter
  57. How do I sort posts with multiple pages
  58. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  59. How to correctly pass values to wpdb->prepare()?
  60. Single meta_query query using OR instead of AND in request’s WHERE statement
  61. How to do meta_query for attachments?
  62. Get attachment by meta_key value
  63. Complex WP_Query order request: DESC by day, but then ASC by time
  64. Using meta_query with multiple keys and compare values
  65. Mysql query and order meta value
  66. Sort wordpress custom posts based on meta value
  67. meta_query BETWEEN, but the range is stored in the custom field
  68. How to do WP_Query with two meta fields with orderby clause
  69. Is it possible to set specific posts to show first in a query?
  70. database query with more than a couple meta hangs and doesn’t complete
  71. How to Order a list of taxonomies? orderby?
  72. Sort by presence of thumbnail
  73. it’s possible make a WP_Query with math operations?
  74. Sorting search results with custom dropdown
  75. how to retrieve WP_Query without ordering by date [duplicate]
  76. What’s missing in this wp_query and meta_query
  77. WP_Query orderby
  78. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  79. WP_Query() not working as expected
  80. How to sort store location by specific category order in WP store locations
  81. Trouble with serialized metadata
  82. meta_query order by date present -> future then show null
  83. WP_Query random ordering not working since 5.4
  84. meta_query compare > not working
  85. Saving custom fields for WP_Query to retrieve
  86. Display three sequential posts on each page load, without repeating previous
  87. Filter posts/pages by user_role array
  88. WP_Query with MetaQuery issue
  89. Custom loop – Isolating post meta output depending on current query taxonomy terms
  90. WP_Query with meta_value_num and meta_query not paged correctly
  91. Post Query not working after updating to 4.1
  92. Orderby Meta Value and Query from Meta Query
  93. WP Query to order posts by multiple meta fields
  94. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  95. Order by multiple meta keys on wordpress
  96. Sort posts in dashboard using custom field; also include posts where field isn’t set
  97. Sort Posts with custom meta key by default which is currently set as optional
  98. wpdb LIKE request shows all database data
  99. How do I have multiple metaqueries inside one wordpress query
  100. Display only posts with thumbnails
techhipbettruvabetnorabahisbahis forumueduseduseduseduedueduseduseduedusedu