wpdb

var_dump($einzel); array(10) { [0]=> string(3) “144” [1]=> string(10) “21.05.2020” [2]=> string(10) “00.00.0000” [3]=> string(30) “Zugtag der Königsgilde Voitze” [4]=> string(14) ” ab 10.00 Uhr ” [5]=> string(0) “” [6]=> string(41) “Schützenhaus Voitze, Salzwedeler Straße” [7]=> string(6) “Voitze” [8]=> string(11) “Gaede,Joerg” [9]=> string(23) “[email protected]” } There are two same column names: ‘id’ and ‘name’. I worked … Read more

You have a mistake in your query $sql = “SELECT {$wpdb->prefix}commentmeta.comment_id, avg({$wpdb->prefix}commentmeta.meta_value) avg_meta_value FROM {$wpdb->prefix}commentmeta LEFT JOIN {$wpdb->prefix}comments ON {$wpdb->prefix}commentmeta.comment_id = {$wpdb->prefix}comments.comment_ID WHERE {$wpdb->prefix}commentmeta.meta_key = ‘rating’ GROUP BY {$wpdb->prefix}commentmeta.comment_id ORDER BY avg_meta_value desc”; $results = $wpdb->get_results($sql); foreach ($results as $result) { echo $result->comment_id.'<br>’; }