
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
