Publicity #5693
closed
Social Paper Stats for grant report
Added by Matt Gold over 8 years ago.
Updated over 8 years ago.
Category name:
Social Paper
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.
- 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 |
+---------------------------------------+
- Status changed from Assigned to Resolved
thanks again for this, Boone.
Also available in: Atom
PDF