Project

General

Profile

cac-3176-scratch.txt

Boone Gorges, 2019-10-28 11:27 AM

 
1

    
2
Docs
3

    
4
All time
5
Items: 2227
6
Revisions: 7303
7
Groups: 290
8
Users: 785
9

    
10
Since Nov 1 2017
11
Items: 437
12
Revisions: 571
13
Groups: 63
14
Users: 296
15

    
16
Since May 1 2019
17
Items: 66
18
Revisions: 51
19
Groups: 14
20
Users: 62
21

    
22
select count(distinct term_taxonomy_id)
23
from wp_1_term_relationships where
24
object_id in
25
	(
26
	select ID from wp_1_posts where (
27
		post_type = 'bp_doc' OR
28
		(post_type = 'revision' and post_parent in ( select ID from wp_1_posts where post_type = 'bp_doc'))
29
		)
30
		and post_date >= '2019-05-01'
31
	)
32
	and
33
	term_taxonomy_id in (select term_taxonomy_id from wp_1_term_taxonomy where taxonomy = 'bp_docs_associated_item');
34

    
35
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') ) );
36

    
37
Papers
38

    
39
All time
40
Items: 581
41
Revisions: 1331
42
Groups: 40
43
Users: 263
44

    
45
Since Nov 1 2017
46
Items: 206
47
Revisions: 290
48
Groups: 10
49
Users: 129
50

    
51
Since May 1 2019
52
Items: 29
53
Revisions: 6
54
Groups: 0
55
Users: 16
56

    
57
select count(distinct term_taxonomy_id)
58
from wp_1_term_relationships where
59
object_id in
60
	(
61
	select ID from wp_1_posts where (
62
		post_type = 'cacsp_paper' OR
63
		(post_type = 'revision' and post_parent in ( select ID from wp_1_posts where post_type = 'cacsp_paper'))
64
		)
65
		and post_date >= '2017-11-01'
66
	)
67
	and
68
	term_taxonomy_id in (select term_taxonomy_id from wp_1_term_taxonomy where taxonomy = 'cacsp_paper_group');
69

    
70

    
71
Group Files
72

    
73
All time
74
Items: 11926
75
Groups: 642
76
Users: 1133
77

    
78
Since Nov 1 2017
79
Items: 2693
80
Groups: 171
81
Users: 389
82

    
83
Since May 1 2019
84
Items: 573
85
Groups: 55
86
Users: 116