get_blog_list

The timeline below displays how wordpress function get_blog_list has changed across different WordPress versions. If a version is not listed, refer to the next available version below.

WordPress Version: 6.2

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU (3.0.0)
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param int    $start      Optional. Offset for retrieving the blog list. Default 0.
 * @param int    $num        Optional. Number of blogs to list. Default 10.
 * @param string $deprecated Unused.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", get_current_network_id()), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ('all' === $num) {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 5.5

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU (3.0.0)
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 *
 * @param int    $start      Optional. Offset for retrieving the blog list. Default 0.
 * @param int    $num        Optional. Number of blogs to list. Default 10.
 * @param string $deprecated Unused.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", get_current_network_id()), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ('all' === $num) {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 4.9

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU (3.0.0)
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 *
 * @param int    $start      Optional. Offset for retrieving the blog list. Default 0.
 * @param int    $num        Optional. Number of blogs to list. Default 10.
 * @param string $deprecated Unused.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", get_current_network_id()), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 4.6

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 *
 * @param int    $start      Optional. Offset for retrieving the blog list. Default 0.
 * @param int    $num        Optional. Number of blogs to list. Default 10.
 * @param string $deprecated Unused.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", $wpdb->siteid), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 4.5

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 *
 * @param int    $start      Optional. Offset for retrieving the blog list. Default 0.
 * @param int    $num        Optional. Number of blogs to list. Default 10.
 * @param string $deprecated Unused.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", $wpdb->siteid), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 4.4

/**
 * Deprecated functionality to retrieve a list of all sites.
 *
 * @since MU
 * @deprecated 3.0.0 Use wp_get_sites()
 * @see wp_get_sites()
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", $wpdb->siteid), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 4.2

/**
 * @since MU
 * @deprecated 3.0.0
 * @deprecated No alternative available. For performance reasons this function is not recommended.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", $wpdb->siteid), ARRAY_A);
    $blog_list = array();
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    if (!$blog_list) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blog_list, $start, count($blog_list));
    } else {
        return array_slice($blog_list, $start, $num);
    }
}

WordPress Version: 3.7

/**
 * @since MU
 * @deprecated 3.0.0
 * @deprecated No alternative available. For performance reasons this function is not recommended.
 */
function get_blog_list($start = 0, $num = 10, $deprecated = '')
{
    _deprecated_function(__FUNCTION__, '3.0', 'wp_get_sites()');
    global $wpdb;
    $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id, domain, path FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", $wpdb->siteid), ARRAY_A);
    foreach ((array) $blogs as $details) {
        $blog_list[$details['blog_id']] = $details;
        $blog_list[$details['blog_id']]['postcount'] = $wpdb->get_var("SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'");
    }
    unset($blogs);
    $blogs = $blog_list;
    if (false == is_array($blogs)) {
        return array();
    }
    if ($num == 'all') {
        return array_slice($blogs, $start, count($blogs));
    } else {
        return array_slice($blogs, $start, $num);
    }
}