get_last_updated() WP 3.0.0

Get a list of most recently updated blogs.

No Hooks.

Return

Array. The list of blogs.

Usage

get_last_updated( $deprecated, $start, $quantity );

$deprecated(mixed)

Not used.
Default: ''

$start(int)

Number of blogs to offset the query. Used to build LIMIT clause. Can be used for pagination.
Default: 0

$quantity(int)

The maximum number of blogs to retrieve.
Default: 40

Notes

• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

Code of get last updated: wp-includes/ms-blogs.php ^{WP 5.4.2}

<?php
function get_last_updated( $deprecated = '', $start = 0, $quantity = 40 ) {
	global $wpdb;

	if ( ! empty( $deprecated ) ) {
		_deprecated_argument( __FUNCTION__, 'MU' ); // Never used.
	}

	return $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' AND last_updated != '0000-00-00 00:00:00' ORDER BY last_updated DESC limit %d, %d", get_current_network_id(), $start, $quantity ), ARRAY_A );
}