You can go directly to the database via $wpdb
.
<?php
$wpdb->get_results( "SELECT * FROM $wpdb->blogs WHERE archived = 1" );
Or wrapped up in a function:
<?php
function wpse34731_get_archived_blogs()
{
global $wpdb;
if( empty( $wpdb ) ) return;
$blogs = $wpdb->get_results( "SELECT * FROM $wpdb->blogs WHERE archived = 1" );
return $blogs;
}
Related Posts:
- How to list all network sites on one page
- List all sites in multisite
- how to list all subdomain in wordpress multiuser
- List all sites in multisite
- Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
- What do I need to do to convert my MultiSite from HTTP to HTTPS?
- WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
- SSL wildcard issue for wp multisite subdomains
- How to set configuration options for particular sub blogs?
- Perform action on WPMU blog deletion
- Changing Multisite themes on mass
- Organize uploaded media files
- How to upload images manually to wordpress?
- MU domain mapping login issue
- Sitemap Plugin for WordPress Network
- How to make WordPress use new Upload Path settings in Multisite Setup
- WPDB Multiple site’s posts and get featured images
- Using WP CLI to set options in WP Multisite
- Import a regular WordPress blog into a MU installation
- Basic analytics across WordPress Multisite network [closed]
- Which is the recommended method to transfer a wordpress site to wordpress Multisite?
- Ideal WP multisite server setup for up to 1000 sites?
- Changing Multisite URL after the subsite has been in use
- Can’t find “Add New” button for themes in a multisite
- WordPress 3.2(Multisite) – How to add custom user meta fields to signup form?
- WordPress 3.8.1 Multisite blog slug problem
- How to make wp-signup.php a 1-step process [closed]
- Transients API and multisite
- Multiple Multisite networks on the same domain?
- How the mu-plugins Folder Works in a Multisite Installation?
- Replacing the default content created while the site creation
- Importing Multiple DB to one MU database
- Get Permalink of Network Blog Post
- What is the best practice to get a site from local to online?
- Multisite, can’t see sub blogs
- WP Multisite – domain mapping to domain.com and separate site to domain.com/help
- How i can get blog info using site url in multi-site
- Embedding screencast.com Videos in WordPress Multisite
- upgrade from WPMU 2.9.2 to WP 3.2.1
- How to create a network using a command line script?
- Mapping subdomain to point to sudirectory site in WordPress Multisite Network
- Multiple multisite instances connecting to the same database
- Multisite multidomain
- Notice bar at frontpage for multisite
- Syncing content in Multisite. Possible?
- Query to import data from one MultiSite table to another (pages/sub-pages)
- Multisite – Images often getting uploaded to the wrong month directory
- How to fix blocked cookies error that doesn’t let me log into wp-admin?
- Limit entries number on network/sites.php
- Apache Site Aliases & WordPress Multisite
- Single sign on for several website domains
- How to create a Multi-Network subsite?
- Hierarchy in multisite
- Create default pages in wordpress multisite
- Migrating Multisite with WP-Cli and/or Search-Replace-DB
- Remove superadmin role from the “change role to” menu in user listing
- use get_theme_mod from all sites in network
- Generate HTTPS Urls in multisite
- Replicate network plugins without having to configure it for each subsite?
- Why are “numeric only” names disallowed when creating a new site in a WordPress multisite network?
- How to organize my js files
- Installing multisite network on a bluehost addon domain
- If statement in wp-config.php, is it possible?
- How do I correctly configure my AMPPS localhost to use subdomains for multisite?
- Update WP install to WP network & it broke the DB connection
- WordPress Multisite URLs and Multiple Updates
- How can you customize on a multisite?
- Multisite switch to blog
- WordPress multisite, allow non super admins to create sites
- How to Force WWW. in Domain With WordPress MU Domain Mapping Plugin?
- How does WP decide how to evaluate database integrity
- Manually Moving Posts/Pages/Comments/Tags from WPMU to WP3.0
- Setup another new subdomain root on top of multisite configuration
- WordPress keeps deleting user account for multisite after loggin out i need your help please?
- Change main site / network admin site?
- Create link preview for theme wordpress
- Language per user role, how can I achieve this?
- Internet explorer not finding right content from multisite
- Change WordPress multisite to sub-folder installation
- Serve theme and plugins assets from correct domain on multi-domain multisite
- How to add a link of “one” website in posts of “second” website in multisite WordPress
- Themes are visible in Network, but invisible in sites
- logging out with/without confirmation – single site, multisite
- No debug log for WP multisite is created
- Multisite different domains mapping error on GGS
- Multisite – each site with it’s own set of users
- WordPress Multisite wp-admin/ redirect loop but adding index.php works fine
- Can WP multisite manage multiple ccTLDs
- Should i use multisite for my business?
- WordPress Network with SSL for multiple domains
- Nginx rules for subdomain multisite install (Bedrock)
- Migrate site from WordPress multisite to another WordPress multisite
- WordPress Multisite redirect loop
- How to Create WPMu New User?
- Split a Multisite Into Single WordPress Websites
- WordPress Multisite Subsite WP admin not working
- How to make Multisite global login that redirects to correct subsite after login
- Multiple WordPress sites on one hosting [closed]
- get_category_link() or get_tag_link() return wrong category/tag base in wordpress multisite
- Multisite subdomain microsite on secondary domain