<?php
$blog_list = get_blog_list( 0, 'all' );
foreach ($blog_list AS $blog){
$domain = $wpdb->get_var( "SELECT domain FROM {$wpdb->blogs} WHERE blog_id=".$blog['blog_id']);
$posts = $wpdb->get_col( "SELECT ID FROM wp_".$blog['blog_id']."_posts WHERE guid like '%".$domain."%'");
foreach($posts as $p)
{
$postdetail=get_blog_post($blog['blog_id'],$p);
?>
<a href="<?php echo $postdetail->guid;?>"><?php echo $postdetail->post_title;?></a>;
<br />
<?php
}
}
?>