WordPress multisite content freshness report

stats.php

<?php
// To run it, place into web root and then `wp eval-file stats.php > ~/stats.csv`
global $wpdb;
$sites = $wpdb->get_results( "SELECT blog_id,domain,path,last_updated FROM {$wpdb->prefix}blogs",'ARRAY_A' );
foreach( $sites as &$site){
	if($site['blog_id'] === '1'){
		$post_table = $wpdb->prefix . 'posts';
	} else {
		$post_table = $wpdb->prefix . absint($site['blog_id']) . '_posts';
	}
	$site['posts_number'] = $wpdb->get_var( "SELECT count(*) FROM $post_table WHERE post_type NOT IN ('revision','nav_menu_item','custom_css','customize_changeset','oembed_cache','user_request','wp_block')" );
}
WP_CLI\Utils\format_items( 'csv', $sites, array( 'blog_id', 'domain','path','last_updated','posts_number' ) );