I’ve found that you can replace current_user_can( ‘edit_posts’ ) with current_user_can( ‘edit_private_posts’ ) and it works for subscribers. I think there are 2 instances of this.
Hmmm…on further investigation it seems that the sum function isn’t working. I’ve got a time field and had been using SEC_TO_TIME(SUM(TIME_TO_SEC(wp_table_time.duration))) successfully in PhpMyAdmin. I even tried plain old SUM with no transposing. No luck. Thoughts? Thanks!