[wp-trac] [WordPress Trac] #38071: Add status links to network/sites.php

[WordPress Trac]

#38071: Add status links to network/sites.php
-------------------------------------------------+-------------------------
 Reporter:  johnjamesjacoby                      |       Owner:
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  4.7
Component:  Networks and Sites                   |     Version:  3.0
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-screenshots needs-     |     Focuses:  multisite
  unit-tests                                     |
-------------------------------------------------+-------------------------

Comment (by PieWP):

 In regards to the wp_count_sites, why use the foreach to sum up the status
 instead of an aggregated query? Might cause issues when someone has many
 subsites within their network.


 {{{
 "SELECT
      SUM(public) AS `public`,
      SUM(archived) AS `archived`,
      SUM(mature) AS `mature`,
      SUM(spam) AS `spam`,
      SUM(deleted) as `deleted`
 FROM {$wpdb->blogs} WHERE site_id = %d"
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/38071#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform