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;

	}

	public function process_request( $post, array $post_data ) {

		/**

		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 {