CUNY Academic Commons

Docs

All time

Items: 2227

Revisions: 7303

Groups: 290

Users: 785

Since Nov 1 2017

Items: 437

Revisions: 571

Groups: 63

Users: 296

Since May 1 2019

Items: 66

Revisions: 51

Groups: 14

Users: 62

select count(distinct term_taxonomy_id)

from wp_1_term_relationships where

object_id in

	(

	select ID from wp_1_posts where (

		post_type = 'bp_doc' OR

		(post_type = 'revision' and post_parent in ( select ID from wp_1_posts where post_type = 'bp_doc'))

		)

		and post_date >= '2019-05-01'

	)

	and

	term_taxonomy_id in (select term_taxonomy_id from wp_1_term_taxonomy where taxonomy = 'bp_docs_associated_item');

select count(distinct post_author) from wp_1_posts where (post_type = 'bp_doc' OR (post_type = 'revision' and post_parent in (select ID from wp_1_posts where post_type = 'bp_doc') ) );

Papers

All time

Items: 581

Revisions: 1331

Groups: 40

Users: 263

Since Nov 1 2017

Items: 206

Revisions: 290

Groups: 10

Users: 129

Since May 1 2019

Items: 29

Revisions: 6

Groups: 0

Users: 16

select count(distinct term_taxonomy_id)

from wp_1_term_relationships where

object_id in

	(

	select ID from wp_1_posts where (

		post_type = 'cacsp_paper' OR

		(post_type = 'revision' and post_parent in ( select ID from wp_1_posts where post_type = 'cacsp_paper'))

		)

		and post_date >= '2017-11-01'

	)

	and

	term_taxonomy_id in (select term_taxonomy_id from wp_1_term_taxonomy where taxonomy = 'cacsp_paper_group');

Group Files

All time

Items: 11926

Groups: 642

Users: 1133

Since Nov 1 2017

Items: 2693

Groups: 171

Users: 389

Since May 1 2019

Items: 573

Groups: 55

Users: 116