Below query gets a list of blogs in order of most recent update. But it doesn't bring "all posts" What could be the issue?
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' AND blog_id != '1' AND last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)ORDER BY last_updated DESC");
"WHERE public = '1' "
Again, are all blogs public?
yes that's what I want to change. I want to display all whether public or not, what should I do?
Then take that bit out. Because right now it only pulls public blogs. taking that part out will pull all.
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' AND blog_id != '1' AND last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)ORDER BY last_updated DESC");