Project

General

Profile

Publicity #5693

Social Paper Stats for grant report

Added by Matt Gold over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority name:
Normal
Assignee:
Category name:
Social Paper
Target version:
Start date:
2016-06-13
Due date:
% Done:

0%

Estimated time:

Description

Hi Boone,

For the aforementioned grant report I am compiling, can you please let me know the following, if easily accessible:

-- the total number of Social Papers that have been created (including private ones) since launch
-- the total number of comments on papers
-- the total number of commenters on papers

I see 115 papers here -- http://commons.gc.cuny.edu/papers/ -- but I don't know whether that count includes private papers.

Thanks in advance for your help with this.

History

#1 Updated by Boone Gorges over 2 years ago

  • Target version set to Not tracked

-- the total number of Social Papers that have been created (including private ones) since launch

115 is correct. Only 37 are public (view as a logged-out user to see).

the total number of comments on papers

mysql> select count(wp_1_comments.comment_ID) from wp_1_comments join wp_1_posts on wp_1_posts.ID = wp_1_comments.comment_post_ID where wp_1_posts.post_type = 'cacsp_paper';
+---------------------------------+
| count(wp_1_comments.comment_ID) |
+---------------------------------+
|                             864 |
+---------------------------------+

-- the total number of commenters on papers

mysql> select count(distinct wp_1_comments.user_id) from wp_1_comments join wp_1_posts on wp_1_posts.ID = wp_1_comments.comment_post_ID where wp_1_posts.post_type = 'cacsp_paper';
+---------------------------------------+
| count(distinct wp_1_comments.user_id) |
+---------------------------------------+
|                                    66 |
+---------------------------------------+

#2 Updated by Matt Gold over 2 years ago

  • Status changed from Assigned to Resolved

thanks again for this, Boone.

Also available in: Atom PDF