Make division in post_query?

MySQL can do math but can’t pass it through query_posts like that, or any WordPress’ post query functions, which depend upon WP_Query. They will literally look for a table/column named, in your case, “meta_value_num / date”. To do it in SQL I believe– aka., this is untested– you’d have to do something like this:

SELECT (meta_value_num / DATE()) as ddiv
FROM <some-table>
ORDER BY ddiv

And that isn’t going to be a very efficient query anyway.

Why can’t you do the division after the query? I believe the sort order will be the same either way.

Related Posts:

  1. Using $wpdb to query posts with meta value containing current post_id
  2. Query posts from current year
  3. How to show posts rank based on custom field value
  4. How do I create Comma Separated list of attached image ids?
  5. How to add posts to wp_query result?
  6. Order post by year DESC and month ASC
  7. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  8. How can I display a specific user’s first published post?
  9. wp_enqueue_media() slows down my WP site
  10. How can I get all posts data from within a paginated search result?
  11. Sorting posts alphabetical that have single digits
  12. Query posts from different categories in multisite
  13. posts_per_page doesnt work
  14. Sorting posts according to view counts not working
  15. Only display posts after current date
  16. Improving WP_Query for performance when random posts are ordered
  17. Get posts by name and taxonomy term
  18. WP_Query Authors OR Categories
  19. Get Posts that are in the current month or later
  20. do_shortcode within post query
  21. Get Meta Key Value While Saving Post
  22. Most liked page not displaying posts
  23. Query get post,how to add comment box
  24. get query() without post content?
  25. How can I setup a relationship using categories in WordPress?
  26. posts_per_page option limits the number of Gallery items
  27. How i can limit period of post publication?
  28. How to setup a query to output posts by groups of five?
  29. Exclude current custom post on single post
  30. Dynamically switch template on click
  31. Get all custom post types excepted some…
  32. Get all comments of author’s posts
  33. First x post with another template then the others
  34. Why Query is returning empty array?
  35. Delete all drafts?
  36. Wrap every month posts in div
  37. meta_value timestamp older than now
  38. Counter is skipping post when I still want it visible [closed]
  39. Do not show children of a category
  40. post__in not working with pre_get_posts, but post__not_in does work
  41. How to get all post_parents of a post?
  42. Query for first 3 posts to change the look and feel
  43. Why posts array is empty?
  44. Query posts and filter at query time by value of custom meta
  45. Run query_posts if SESSION is empty?
  46. Very complex post query
  47. Delete post revisions only for a single post
  48. How to give classname to post if post has no content?
  49. Display post by click on the link
  50. Queries take 120+ seconds on my large WordPress site
  51. How to retrieve certain number of images from a wordpress post?
  52. How to convert query sql to shortcode in wordpress?
  53. WordPress loop not working on static front page
  54. Some doubts about how the loop work (trying debugging it)
  55. How to display only one category in a custom post type?
  56. Adjust the order for returned posts
  57. Trim posts from WP-Query?
  58. Anyone know a php snippet for showing the first 200 characters of the most recent post?
  59. Get current taxonomy and display query accordingly
  60. Trying to exclude custom posts based on date, while sorting by custom field
  61. How Can I Always Display A Particular Post First Using WP_Query?
  62. how to add tags to post in the Loop?
  63. Merge get_comments & get_posts into a single query
  64. How to optimize posts query in wordpress
  65. Check if almost 10 year old – working code is up to date
  66. Query to fetch custom taxonomy along with post title
  67. How to fetch courses in all languages in WordPress?
  68. Query custom post type custom meta key
  69. How to search through “post title” and “tags” using WP_Query?
  70. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  71. I have two post types in the same query, how can I use CSS to select only one post type?
  72. filter posts based on menu_order
  73. Bulk Post update_post_meta
  74. Show 5 posts and than 3 posts offset with pagination
  75. I need some explanation on global $post [duplicate]
  76. How to delete all posts with dead image urls?
  77. Numbering author posts in posts query
  78. How to run select query of post with category and tags?
  79. Querying posts from current category, using a variable as array argument
  80. Query posts from newest category
  81. wp query custom orderby not custom field
  82. Custom Select Query pagination not working properly
  83. Query post by meta key of another table
  84. Sort / Filter Queries
  85. Query post category & remove any post id
  86. Display the latest post from some selected authors
  87. Ordering posts alphabetically by meta keys and title
  88. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  89. Grab next post title in archive page
  90. Continuous listing from a custom field
  91. Displaying Results From Custom Taxonomy Query
  92. How to store post rating system data post independent?
  93. Get first comment link on the post itself
  94. How to limit post query to only return a total count of items with certain post statuses?
  95. The page that displays Posts on homepage
  96. query_post or single-[cpt].php?
  97. Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields
  98. Display posts with id equal to relationship value
  99. Sort Posts Alphabetically Based on Specific Category (Divi)
  100. Change permalinks in posts via SQL