How to sort posts by the average of comment meta values

I’ve done exactly something similar. First, use get_comment_meta for getting the per comment rating, you don’t need the SQL for it. Then get the average rating (addition of individual comment ratings on a single post / number of comments on this post). Then store this average value as post meta for this post. Use WP_Query custom fields parameters for ordering these posts.

Related Posts:

  1. How to get a value from comment meta
  2. What for is the table “wp_commentmeta” exactly?
  3. Getting Post Comments for post ID using WP_Query() and a Custom Loop?
  4. Running a function on comment status change
  5. Is it possible to show custom comment metadata in the admin panel?
  6. Add Comment Custom Field
  7. Upload images with comment
  8. Add a drop down list to comment form?
  9. An action hook where a comment meta is updated
  10. What are the additional fields in wp_comments used for?
  11. Display comment meta data after quick update
  12. WordPress Comment. Need some details of wp_comments DB table
  13. How would I count the number of times a comment meta field’s value is in a post’s entire comments?
  14. Get comments from post and sort by commentmeta value
  15. How to get comment images stored as serialized comment meta
  16. Name of comment field differs on different sites
  17. Make every comment go to the spam folder
  18. How to display comment meta under each comment content
  19. Update comment meta for all comments of specific post
  20. How to get Post title by locale with Qtranslate-X
  21. get_comment_meta not behaving as expected
  22. How / where is the wp_query object created for RSS feeds?
  23. How to filter comments by comment_meta
  24. Top rated posts Average rating issue
  25. WordPress Commenting System User access and Security
  26. Add comment meta
  27. Comment-Meta doesn’t work with latest wordpress update
  28. add field comment [duplicate]
  29. Loop not displaying comments_popup_link
  30. Use country flag as user avatar based on comments IP address?
  31. Nofollow the date/time hyperlink in comment
  32. Resetting comment count
  33. Redirect user to a custom url after submitting the comment
  34. Add comments from the admin panel?
  35. One comment per user per post but be able to reply to existing comments
  36. What’s the easiest way to close comments on media/attachments?
  37. Using Disqus, how to stop storing comments in wp database?
  38. Multiple Comment Moderators and Notifications
  39. function to remove ‘comments and trackbacks are closed’
  40. Get threaded comments number
  41. SQL query to delete comments older than 90 days?
  42. Let user edit his own comment
  43. Get the number of comments awaiting moderation
  44. Changing position of cancel_comment_reply_link and other elements of comment form
  45. What does the “$depth” parameter in the Walker_Comment stand for?
  46. Why do comment moderators need to have all create/edit/delete toboth posts and pages?
  47. Comment pagination – How to show determined number of comments on the first page?
  48. How to allow a particular role like Contributor be able to only view pending comments and approve them?
  49. How do I really disable comments?
  50. Sort comments by karma
  51. Bots posting comments on pages
  52. Comment form connection to Gravity Forms
  53. Add classname comment template from functions.php
  54. Comments deactivated
  55. List user comments in author page
  56. Filter custom posts with / without comments
  57. Create comments.php form of custom HTML code
  58. Display comments on homepage of twenty seventeen theme
  59. How to dynamic Heart Like in WordPress?
  60. Disqus comments and pingback script – how to change the order?
  61. To whom do emails get sent via the WordPress comments form?
  62. Is it possible to embed github gists in wordpress comments?
  63. Comments feed – Undefined named entity: ndash
  64. Error While Sending Comment
  65. How to convert WordPress comments to bbPress replies [closed]
  66. Get declared variable in single.php to work in comments.php without re-declaring it [closed]
  67. What is causing wp-comments-post.php to redirect to the browser’s IP address?
  68. Extra Title field for Comments
  69. Comments offset
  70. How to hide trackbacks on wp-admin/edit-comments.php
  71. comments_number not displaying
  72. Using a static callback on wp_insert_comment
  73. WordPress Recent Comments Widget exclude own comments
  74. How to prevent multiple comments
  75. Hide comments on specific pages, not just disable future comments
  76. Add comment_meta to wp_comment_reply
  77. How do comments work?
  78. Can’t reply to comments [closed]
  79. What’s the difference with trash_comment and wp_trash_comment?
  80. ask and edit an extra comment field
  81. Refresh individual comment text via API
  82. Prevent users to delete comments from trash
  83. How to display replies to his comments in user profile of current user
  84. How do I refresh “Post Last Modified Time”, as long as comment is updated to Approve status?
  85. stop url changing when user comments
  86. Badges for Guests based on their comment counts [closed]
  87. How to add a class to comment submit button?
  88. WordPress Comments – Only show part of user name
  89. Broken comments section – WordPress 2014 Theme
  90. Need an advice about comments
  91. How do I get the comments section to show up?
  92. By Default, Turn Comments Off for Pages & Leave Comments On for Posts
  93. same comment list for two posts
  94. Replace do_action() with a normal submit form in comments.php
  95. edit-comments.php in Admin – how to change ‘Comments’ title?
  96. Comments on pages not appearing, even though I enabled them
  97. Stop future commenting on specific post
  98. The last comments of a post for the author of that post
  99. Remove rel=”nofollow ugc” from links in comments
  100. How can I not redirect users to the single post when they add a threaded comment?