get_last_updated() │ WP 3.0.0

Gets 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.
$quantity(int)
The maximum number of blogs to retrieve.
Default: 40

Notes

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

Changelog

Since 3.0.0 Introduced.

get_last_updated() code WP 6.5.2

wp-includes/ms-blogs.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 );
}