Project

General

Profile

Actions
Copy link

Publicity #5693

closed

Social Paper Stats for grant report

Added by Matt Gold almost 8 years ago. Updated almost 8 years ago.

Status:
Resolved
Priority name:
Normal
Assignee:
Boone Gorges
Category name:
Social Paper
Target version:
Not tracked
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.

Actions
Copy link
 #1

Updated by Boone Gorges almost 8 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 |
+---------------------------------------+
Actions
Copy link
 #2

Updated by Matt Gold almost 8 years ago

  • Status changed from Assigned to Resolved

thanks again for this, Boone.

Actions
Copy link

Also available in: Atom PDF