Sharing_Service::get_posts_total PHP Method

    public function get_posts_total()
    {
        $totals = array();
        global $wpdb, $blog_id;
        $my_data = $wpdb->get_results($wpdb->prepare("SELECT post_id as id, SUM( count ) as total FROM sharing_stats WHERE blog_id = %d GROUP BY post_id ORDER BY count DESC ", $blog_id));
        if (!empty($my_data)) {
            foreach ($my_data as $row) {
                $totals[] = new Sharing_Post_Total($row->id, $row->total);
            }
        }
        usort($totals, array('Sharing_Post_Total', 'cmp'));
        return $totals;
    }