Automattic / jetpack

		return (int) $wpdb->get_var( $wpdb->prepare( 'SELECT count FROM sharing_stats WHERE blog_id = %d AND post_id = %d AND share_service = %s', $blog_id, $post->ID, $name ) );

	}

	public function get_posts_total() {

		global $wpdb, $blog_id;

		$totals = array();

		$name	= strtolower( $this->get_id() );

		$my_data = $wpdb->get_results( $wpdb->prepare( 'SELECT post_id as id, SUM( count ) as total FROM sharing_stats WHERE blog_id = %d AND share_service = %s GROUP BY post_id ORDER BY count DESC ', $blog_id, $name ) );

		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;

	}

		return $totals;

	}

	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;

	}

}

class Sharing_Service_Total {