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. Would switching to InnoDB from MyISAM improve performance of comments table?
  32. How can I limit the number of comments per registered user per day?
  33. How can I control the comment counts filtering my CPT replies?
  34. How to auto-approve internal pingbacks?
  35. Comments waiting but no comments found
  36. Programmatically block commenting by restricting view of comment form
  37. What is comment_karma?
  38. How to override function twentyten_comment
  39. Disqus over the default commenting engine, what are some pros and cons?
  40. count number of user comments with a specific comment meta value
  41. How To Remove The “Click here to cancel reply” Link From The WordPress Comment Form
  42. Plugin from WordPress.com for comment notification…available? [closed]
  43. How to add text to comment form #content textarea?
  44. How can I highlight admin comments?
  45. Why are my comments closed?
  46. Load comments per post on click with AJAX
  47. Block comments from search engine indexing
  48. Create a “Reject” action for comments?
  49. Add action on delete comments?
  50. Changing “submitted on date” of comments
  51. Filter custom comment type from Manage Comments & Dash Widgets
  52. WordPress custom form action url
  53. How to add a strip of visual editor on top of comments textarea
  54. Threaded comments not working
  55. Customizing comments pagination for bootstrap
  56. woocommerce allow users to select or use avatar
  57. Comments on homepage (index.php) are duplicated under posts
  58. Comment Form – E-mail Not Required!
  59. Get a total count for all comments and display result
  60. Email notification to an email address other than admin for custom type post comments in wordpress
  61. Notification if Comment Author Field is left empty. E.g. change input border colour
  62. List comments received by every posts of an specific author
  63. Filtering the Admin Comments List to Show Only Comments from the Current User?
  64. Ajax submit comments
  65. Comment Link from get_comments()?
  66. How do I automatically insert some text in the comment textbox on submit?
  67. I cannot view the comments
  68. if null or int(0) value to 0
  69. In wp_list_comments comment dates won’t work?
  70. Only show own comments in admin panel
  71. Sending comment notifications to different recipients depending on taxonomy terms
  72. Replying to comments
  73. Custom comment link
  74. unsetting required fields in the comment reply form
  75. Problem code and show comments
  76. Highlight comments made by registered users of the site
  77. It doesn’t matter if I have more than one comment. get_comments_number still equal to one?
  78. Simple spam check for valid domain in commenter’s email address
  79. Allowing WordPress.org/com accounts on a self-hosted install
  80. How to remove the “comments” bit that appears next to or below the posts
  81. Post comments don’t show
  82. Update post “A” on comment submition on post “B”
  83. Comments counter only for Authors Posts
  84. Pre- Approved Comment Capability
  85. Delete comments function
  86. Comment form not working
  87. Comments page id wp_list_comments
  88. transition_comment_status gets called when untrashing comments
  89. spacebar is not working in input and textarea
  90. wp-editor-area textarea disapear on cancel-comment-reply-link click
  91. Conditionally process comments while ignoring replies
  92. Required Field for Comment parent only?
  93. How do I separate author avatars and comments in 3.4.2?
  94. writing a plugin, how to disable the comment form altogether?
  95. What filter or action to replace comments or add new comment system
  96. Function to get a list of all comments on 1 post [closed]
  97. Auto delete WordPress comments
  98. How to disable comments on new blog post, but allow on new products?
  99. Get approved comments or comments that the author is me
  100. Show/Hide comments