get_results('SELECT `blog_id` FROM `'.$table_prefix.'blogs` ORDER BY `last_updated` DESC LIMIT '.$count); $union=array(); foreach($blogs as $blog){ if ($blog->blog_id==1) $union[]='SELECT *, (@blog:='.$blog->blog_id.') AS blog_id FROM `'.$table_prefix.'posts` WHERE `post_status`="publish" AND `post_type`="post" '; else $union[]='SELECT *, (@blog:='.$blog->blog_id.') AS blog_id FROM `'.$table_prefix.$blog->blog_id.'_posts` WHERE `post_status`="publish" AND `post_type`="post" '; } $query = implode(' UNION ',$union).' ORDER BY `post_date` DESC LIMIT '.$count; $posts = $wpdb->get_results($query); $out=''; foreach($posts as $post){ $out .= "

  • ".$post->post_title."

    • "; } return $out; } function all_posts_widget_meta($args) { extract($args, EXTR_SKIP); $options = get_option('all_posts_widget_meta'); $title = empty($options['title']) ? 'All Posts' : $options['title']; $limit = $options['limit']; ?>