Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook

The other day I was thinking on how to make something like this, I would recommend to save the hottnes as a post meta value, that is updated on every vote, save or update, for that you will need the save_posts filter and then you can get the posts ordered with pre_get_posts and a meta query something like

$query->set('meta_key'=>'hottnes');
$query->set('orderby'=>'meta_value_num');
$query->set('order'=>'DESC');

Hope this helps.

Related Posts:

  1. How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
  2. Sort Posts by Multiple Meta Values [duplicate]
  3. Tax query get first product with attribute value in pre_get_posts
  4. Using meta_query, how can i filter by a custom field and order by another one?
  5. How to return results of a get_posts() in explicitly defined order
  6. Sort posts alphabetically by custom field value, insert divider between different letters
  7. Sort X categories by last update and show image
  8. Sorting problem with ‘query_posts’ funcion in wordpress. Sort by custom field not working
  9. Replace query_posts with pre_get_posts
  10. query_posts sort in multiple directions
  11. get_post_meta causes database queries
  12. Order by meta_key with two meta_queries
  13. ACF Custom Field WP_Query, but need to get all posts, if field doesn’t exist
  14. Order posts using a custom array
  15. orderby:date not working
  16. Single meta key with multiple meta value in like comparison
  17. Help ordering Post loop by two meta values
  18. number of posts per page + random + exclude categories
  19. Filter Loop by Custom Field Value
  20. meta_query check for meta value in key which holds an array of values
  21. Sorting search results with custom dropdown
  22. Meta query stopped working
  23. Custom query looking at multiple custom fields and properly sorting
  24. Ordering Posts By Meta Data
  25. query_posts() with multiple meta data comparisons
  26. why is pre_get_posts not working
  27. wp_query by last month + sort posts
  28. If meta_key has value = 6 | Change the wp_posts.post_date to current date
  29. Custom taxonomy with custom meta value is not sorting correctly (query returns the same value for orderby regardless of sort column click)
  30. posts_per_page no limit
  31. ORDER BY custom field value
  32. Sorting: custom query with orderby meta_value_num THEN by title
  33. Query Multiple Post types each with own meta query
  34. Query posts: how to exclude results if post is in multiple categories
  35. query_posts ->using meta_compare / where meta value is smaller or greater or equals
  36. WP 5.8 “Query Loop” block: where to place custom query?
  37. Meta Query with date and time on the same Day before given time
  38. Pagination on archive.php page
  39. order post my meta value m/d/y format with year as included value
  40. _wp_page_template to dynamically use template
  41. Meta Query “IN” doesn’t work with ACF checkbox filter
  42. Schedule Sticky Posts
  43. Advanced orderby with multiple meta_query
  44. Problem with single-page for my custom post
  45. How to sort posts in admin by titles with dd.mm.yyyy format?
  46. How to make the list of post and load on same page with sub-pages [closed]
  47. Sortable admin column for one meta key with three possible meta values
  48. post_status => publish not working
  49. How to fetch all posts in a category that were published between two given dates?
  50. get_meta_data within a loop
  51. how to exclude “featured” posts from the main loop?
  52. pass query string on url to filter media
  53. Order posts by condition
  54. Co-authors plus problems with query_post
  55. Error sending array of inputs
  56. Custom MySQL Query with logic
  57. Search breaks when querying main loop for category
  58. How to display multiple custom fields with the same meta_key in an ascending order?
  59. Sort the result of the main Query in shop page by a custom taxonomy
  60. How to exclude latest x posts from a paginated query?
  61. Sanitize Custom Field Value in Meta Query
  62. Adding conditional content to single post-type template
  63. Query posts by meta_key whose value is an array
  64. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  65. Currently using a query_posts() in my theme – want to use a request filter in stead
  66. Breadcrumbs stop working on a specific template file
  67. change the default order of posts only for specific categories
  68. Meta_query ‘compare’ => ‘LIKE’ not working?
  69. Custom query filter by ACF date custom field
  70. Order for custom field after the loop
  71. Custom post query error
  72. Why doesn’t my WP Meta Query return any results?
  73. Multiple instances of query_posts
  74. Different layout based on post amount?
  75. If Query Post Returns 1 Post
  76. Keeping get_posts’ offset and is_paged() synchronized
  77. odd behaviours from template tags
  78. How to get any type posts include attachments by ids?
  79. Create a Loop with Posts Ordered by Most Recent Comments
  80. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  81. Sort categories by custom field in WordPress admin
  82. Order column custom date using pre_get_posts
  83. Specifying image size used in template the_content
  84. allow user to edit posts made by others users based on the user role
  85. Pagination not working on my archive page for a custom post type
  86. Custome column sort by date not title
  87. WP search in metadata post
  88. Order posts by ACF checkbox
  89. query_posts with sorting on a custom datestamp
  90. Post per page not working
  91. Show previous month’s posts
  92. query_posts result differs from wp_query request result
  93. Collect posts from last 48 hours
  94. How to go to tag archives using a form
  95. WordPress loop problem: Multiple loops, index.php and is_paged causing duplicate posts on next page
  96. Sorting not working with get_posts
  97. Sort posts with multiple meta_keys
  98. Create “archives by year and week” by category template
  99. ‘Active lotteries’ only custom query for woocommerce lottery plugin and elementor
  100. WP Query – Show custom posts only if user contain some user meta