Ticket #19996: get_blog_metadata.txt

/**
* Get a blog post metadata from any site on the network.
*
* @param int $blog_id ID of the blog.
* @param int $post_id ID of the post.
* @param string $meta_key you're looking for. 
* @return object The metadata.
**/
function get_blog_metadata( $blog_id, $post_id, $meta_key ) {
     global $wpdb;
 
     $key = $blog_id . '-' . $post_id;
     $postmeta = wp_cache_get( $key, 'global-postmeta-'.$meta_key );
     if ( $postmeta == false ) {
          $postmeta = $wpdb->get_row( $wpdb->prepare( 'SELECT * FROM ' . $wpdb->get_blog_prefix( $blog_id ) . 'postmeta WHERE post_id = %d AND meta_key = %s', $post_id, $meta_key ) );
          wp_cache_add( $key, $postmeta, 'global-postmeta-'.$meta_key );
      }
  
      return $postmeta;
}