';
$count = $wpdb->get_var("
SELECT COUNT(meta_value) FROM $wpdb->commentmeta
LEFT JOIN $wpdb->comments ON $wpdb->commentmeta.comment_id = $wpdb->comments.comment_ID
WHERE meta_key = 'rating'
AND comment_post_ID = $post->ID
AND comment_approved = '1'
AND meta_value > 0
");
$rating = $wpdb->get_var("
SELECT SUM(meta_value) FROM $wpdb->commentmeta
LEFT JOIN $wpdb->comments ON $wpdb->commentmeta.comment_id = $wpdb->comments.comment_ID
WHERE meta_key = 'rating'
AND comment_post_ID = $post->ID
AND comment_approved = '1'
");
if ( $count > 0 ) :
$average = number_format($rating / $count, 2);
echo '
';
echo '
'.$average.' '.__('out of 5', 'woocommerce').'
';
echo '
'.sprintf( _n('%s review %s', '%s reviews %s', $count, 'woocommerce'), ''.$count.'', ''.wptexturize($post->post_title).'' ).'';
echo '
';
echo '
';
else :
echo '
';
endif;
echo '