1 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 8 |
2 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
3 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
4 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
5 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
6 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
7 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
8 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
9 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
10 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
11 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
12 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
13 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
14 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
15 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
16 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
17 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
18 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
19 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
20 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
21 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
22 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
23 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
24 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
25 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
26 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
27 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
28 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
29 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
30 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
31 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
32 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
33 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
34 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
35 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
36 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
37 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
38 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
39 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
40 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
41 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
42 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
43 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
44 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
45 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
46 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
47 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
48 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
49 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
50 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
51 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
52 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
53 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
54 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
55 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
56 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
57 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
58 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
59 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
60 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
61 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
62 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
63 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
64 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
65 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
66 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
67 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
68 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
69 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
70 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
71 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
72 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
73 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
74 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
75 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
76 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
77 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
78 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
79 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
80 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
81 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
82 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
83 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
84 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
85 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 2 |
86 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
87 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
88 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
89 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
90 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
91 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb'; | | 109 | 109 | 1 |
92 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 0 |
93 | SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1 | | 0 | 0 | 1 |
94 | SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1 | | 0 | 0 | 0 |
95 | begin | | 0 | 0 | 0 |
96 | create temporary table cumulative_targets as SELECT target_id, coalesce(date_approved, inserted) as experiment_date, 1 as count FROM targets.target as Target WHERE (true) AND (1=1) ; | | 33218 | 0 | 26 |
97 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
98 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
99 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01'
group by target_id) as a
| | 1 | 1 | 6 |
100 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01'
group by target_id) as a
| | 1 | 1 | 28 |
101 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01'
group by target_id) as a
| | 1 | 1 | 4 |
102 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
103 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01'
group by target_id) as a
| | 1 | 1 | 4 |
104 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
105 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
106 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01'
group by target_id) as a
| | 1 | 1 | 5 |
107 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
108 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
109 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-10-01' and experiment_date >= '2011-09-01'
group by target_id) as a
| | 1 | 1 | 12 |
110 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
111 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
112 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01'
group by target_id) as a
| | 1 | 1 | 5 |
113 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
114 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01'
group by target_id) as a
| | 1 | 1 | 13 |
115 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01'
group by target_id) as a
| | 1 | 1 | 5 |
116 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
117 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01'
group by target_id) as a
| | 1 | 1 | 16 |
118 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
119 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01'
group by target_id) as a
| | 1 | 1 | 8 |
120 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01'
group by target_id) as a
| | 1 | 1 | 13 |
121 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01'
group by target_id) as a
| | 1 | 1 | 5 |
122 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01'
group by target_id) as a
| | 1 | 1 | 4 |
123 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01'
group by target_id) as a
| | 1 | 1 | 4 |
124 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
125 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
126 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
127 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
128 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
129 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
130 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01'
group by target_id) as a
| | 1 | 1 | 5 |
131 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01'
group by target_id) as a
| | 1 | 1 | 4 |
132 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01'
group by target_id) as a
| | 1 | 1 | 4 |
133 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
134 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
135 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01'
group by target_id) as a
| | 1 | 1 | 4 |
136 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
137 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
138 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
139 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
140 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01'
group by target_id) as a
| | 1 | 1 | 4 |
141 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-06-01' and experiment_date >= '2014-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
142 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01'
group by target_id) as a
| | 1 | 1 | 4 |
143 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
144 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
145 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
146 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
147 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
148 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
149 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
150 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
151 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
152 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
153 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
154 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
155 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
156 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
157 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
158 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
159 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
160 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
161 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
162 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
163 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
164 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
165 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
166 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
167 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
168 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
169 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
170 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
171 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
172 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
173 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
174 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
175 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
176 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
177 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
178 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
179 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
180 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
181 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
182 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
183 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
184 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
185 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
186 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
187 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
188 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
189 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
190 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
191 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
192 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
193 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
194 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
195 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
196 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
197 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
198 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
199 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
200 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
201 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
202 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
203 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
204 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
205 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
206 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
207 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
208 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
209 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
210 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
211 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
212 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
213 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
214 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
215 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
216 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
217 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
218 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
219 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
220 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
221 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
222 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
223 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
224 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
225 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
226 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
227 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
228 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
229 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
230 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
231 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
232 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
233 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
234 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
235 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
236 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
237 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
238 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
239 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
240 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
241 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-10-01' and experiment_date >= '2022-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
242 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-11-01' and experiment_date >= '2022-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
243 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2022-12-01' and experiment_date >= '2022-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
244 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2023-01-01' and experiment_date >= '2022-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
245 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2023-02-01' and experiment_date >= '2023-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
246 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets
where experiment_date < '2023-03-01' and experiment_date >= '2023-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
247 | drop table cumulative_targets; | | 0 | 0 | 1 |
248 | commit | | 0 | 0 | 1 |
249 | begin | | 0 | 0 | 0 |
250 | create temporary table cumulative_targets_stopped as SELECT Target.target_id, h.change_date as experiment_date, 1 as count FROM priority_history as h
join
target as Target
on h.target_id = Target.target_id WHERE (stage='work_stopped' and new_priority=0 and coalesce(old_priority,1)!=0) AND (1=1) ; | | 7375 | 0 | 15 |
251 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
252 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
253 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
254 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
255 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
256 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
257 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
258 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
259 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
260 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
261 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
262 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
263 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-10-01' and experiment_date >= '2011-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
264 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
265 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
266 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
267 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
268 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
269 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
270 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
271 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
272 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
273 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
274 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
275 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
276 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
277 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01'
group by target_id) as a
| | 1 | 1 | 26 |
278 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
279 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
280 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
281 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
282 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
283 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
284 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
285 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
286 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
287 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
288 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
289 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
290 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
291 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
292 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
293 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
294 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
295 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-06-01' and experiment_date >= '2014-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
296 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
297 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
298 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
299 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
300 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
301 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
302 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
303 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
304 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
305 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
306 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
307 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
308 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
309 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
310 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
311 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
312 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
313 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
314 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
315 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
316 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
317 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
318 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
319 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
320 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
321 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
322 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
323 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
324 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
325 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
326 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
327 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
328 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
329 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
330 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
331 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
332 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
333 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
334 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
335 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
336 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
337 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
338 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
339 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
340 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
341 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
342 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
343 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
344 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
345 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
346 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
347 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
348 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
349 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
350 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
351 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
352 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
353 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
354 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
355 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
356 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
357 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
358 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
359 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
360 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
361 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
362 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
363 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
364 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
365 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
366 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
367 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
368 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
369 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
370 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
371 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
372 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
373 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
374 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
375 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
376 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
377 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
378 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
379 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
380 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
381 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
382 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
383 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
384 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
385 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
386 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
387 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
388 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
389 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
390 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
391 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
392 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
393 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01'
group by target_id) as a
| | 1 | 1 | 1 |
394 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01'
group by target_id) as a
| | 1 | 1 | 1 |
395 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-10-01' and experiment_date >= '2022-09-01'
group by target_id) as a
| | 1 | 1 | 1 |
396 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-11-01' and experiment_date >= '2022-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
397 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2022-12-01' and experiment_date >= '2022-11-01'
group by target_id) as a
| | 1 | 1 | 1 |
398 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2023-01-01' and experiment_date >= '2022-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
399 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2023-02-01' and experiment_date >= '2023-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
400 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_targets_stopped
where experiment_date < '2023-03-01' and experiment_date >= '2023-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
401 | drop table cumulative_targets_stopped; | | 0 | 0 | 0 |
402 | commit | | 0 | 0 | 1 |
403 | begin | | 0 | 0 | 0 |
404 | create temporary table cumulative_clones as SELECT target_id, experiment_date_start as experiment_date, count(*) as count FROM clone WHERE (true) AND (1=1) GROUP BY target_id, experiment_date_start; | | 29586 | 0 | 65 |
405 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01'
group by target_id) as a
| | 1 | 1 | 4 |
406 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
407 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01'
group by target_id) as a
| | 1 | 1 | 9 |
408 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01'
group by target_id) as a
| | 1 | 1 | 4 |
409 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
410 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
411 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
412 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
413 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01'
group by target_id) as a
| | 1 | 1 | 9 |
414 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01'
group by target_id) as a
| | 1 | 1 | 7 |
415 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
416 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01'
group by target_id) as a
| | 1 | 1 | 4 |
417 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-10-01' and experiment_date >= '2011-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
418 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01'
group by target_id) as a
| | 1 | 1 | 7 |
419 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01'
group by target_id) as a
| | 1 | 1 | 12 |
420 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
421 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01'
group by target_id) as a
| | 1 | 1 | 12 |
422 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01'
group by target_id) as a
| | 1 | 1 | 8 |
423 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01'
group by target_id) as a
| | 1 | 1 | 4 |
424 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01'
group by target_id) as a
| | 1 | 1 | 6 |
425 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01'
group by target_id) as a
| | 1 | 1 | 5 |
426 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01'
group by target_id) as a
| | 1 | 1 | 5 |
427 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01'
group by target_id) as a
| | 1 | 1 | 7 |
428 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01'
group by target_id) as a
| | 1 | 1 | 7 |
429 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01'
group by target_id) as a
| | 1 | 1 | 4 |
430 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01'
group by target_id) as a
| | 1 | 1 | 5 |
431 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01'
group by target_id) as a
| | 1 | 1 | 6 |
432 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01'
group by target_id) as a
| | 1 | 1 | 5 |
433 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01'
group by target_id) as a
| | 1 | 1 | 5 |
434 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01'
group by target_id) as a
| | 1 | 1 | 5 |
435 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01'
group by target_id) as a
| | 1 | 1 | 6 |
436 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
437 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01'
group by target_id) as a
| | 1 | 1 | 5 |
438 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01'
group by target_id) as a
| | 1 | 1 | 6 |
439 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01'
group by target_id) as a
| | 1 | 1 | 7 |
440 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01'
group by target_id) as a
| | 1 | 1 | 6 |
441 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01'
group by target_id) as a
| | 1 | 1 | 4 |
442 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01'
group by target_id) as a
| | 1 | 1 | 4 |
443 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
444 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
445 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
446 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
447 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
448 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
449 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-06-01' and experiment_date >= '2014-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
450 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01'
group by target_id) as a
| | 1 | 1 | 4 |
451 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
452 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
453 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
454 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
455 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
456 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
457 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
458 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
459 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
460 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
461 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
462 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
463 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
464 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
465 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
466 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
467 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
468 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
469 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
470 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
471 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
472 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
473 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
474 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
475 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
476 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
477 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
478 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
479 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
480 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
481 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
482 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01'
group by target_id) as a
| | 1 | 1 | 5 |
483 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
484 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
485 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
486 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
487 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
488 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
489 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
490 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
491 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
492 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
493 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
494 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
495 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
496 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
497 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
498 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
499 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
500 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
501 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
502 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
503 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
504 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
505 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
506 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
507 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
508 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
509 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
510 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
511 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
512 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
513 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
514 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
515 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
516 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
517 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01'
group by target_id) as a
| | 1 | 1 | 7 |
518 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
519 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
520 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
521 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
522 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
523 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
524 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
525 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
526 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
527 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
528 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
529 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
530 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
531 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
532 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
533 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
534 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
535 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
536 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
537 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
538 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
539 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
540 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
541 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
542 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
543 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01'
group by target_id) as a
| | 1 | 1 | 9 |
544 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01'
group by target_id) as a
| | 1 | 1 | 4 |
545 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
546 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
547 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
548 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01'
group by target_id) as a
| | 1 | 1 | 3 |
549 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-10-01' and experiment_date >= '2022-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
550 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-11-01' and experiment_date >= '2022-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
551 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2022-12-01' and experiment_date >= '2022-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
552 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2023-01-01' and experiment_date >= '2022-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
553 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2023-02-01' and experiment_date >= '2023-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
554 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones
where experiment_date < '2023-03-01' and experiment_date >= '2023-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
555 | drop table cumulative_clones; | | 0 | 0 | 0 |
556 | commit | | 0 | 0 | 1 |
557 | begin | | 0 | 0 | 0 |
558 | create temporary table cumulative_clones_success as SELECT target_id, experiment_date_start as experiment_date, count(*) as count FROM clone WHERE (status='success') AND (1=1) GROUP BY target_id, experiment_date_start; | | 26688 | 0 | 44 |
559 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
560 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
561 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
562 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
563 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
564 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
565 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
566 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
567 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
568 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
569 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
570 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01'
group by target_id) as a
| | 1 | 1 | 4 |
571 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-10-01' and experiment_date >= '2011-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
572 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01'
group by target_id) as a
| | 1 | 1 | 5 |
573 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01'
group by target_id) as a
| | 1 | 1 | 5 |
574 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
575 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01'
group by target_id) as a
| | 1 | 1 | 5 |
576 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01'
group by target_id) as a
| | 1 | 1 | 8 |
577 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01'
group by target_id) as a
| | 1 | 1 | 4 |
578 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01'
group by target_id) as a
| | 1 | 1 | 5 |
579 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01'
group by target_id) as a
| | 1 | 1 | 5 |
580 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01'
group by target_id) as a
| | 1 | 1 | 4 |
581 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01'
group by target_id) as a
| | 1 | 1 | 6 |
582 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01'
group by target_id) as a
| | 1 | 1 | 7 |
583 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01'
group by target_id) as a
| | 1 | 1 | 4 |
584 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01'
group by target_id) as a
| | 1 | 1 | 4 |
585 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01'
group by target_id) as a
| | 1 | 1 | 6 |
586 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01'
group by target_id) as a
| | 1 | 1 | 5 |
587 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01'
group by target_id) as a
| | 1 | 1 | 5 |
588 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01'
group by target_id) as a
| | 1 | 1 | 4 |
589 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01'
group by target_id) as a
| | 1 | 1 | 6 |
590 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
591 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01'
group by target_id) as a
| | 1 | 1 | 4 |
592 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01'
group by target_id) as a
| | 1 | 1 | 5 |
593 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01'
group by target_id) as a
| | 1 | 1 | 5 |
594 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01'
group by target_id) as a
| | 1 | 1 | 5 |
595 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01'
group by target_id) as a
| | 1 | 1 | 4 |
596 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
597 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
598 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
599 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01'
group by target_id) as a
| | 1 | 1 | 3 |
600 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
601 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
602 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01'
group by target_id) as a
| | 1 | 1 | 3 |
603 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-06-01' and experiment_date >= '2014-05-01'
group by target_id) as a
| | 1 | 1 | 3 |
604 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01'
group by target_id) as a
| | 1 | 1 | 3 |
605 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
606 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
607 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
608 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
609 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
610 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
611 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
612 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
613 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
614 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
615 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
616 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
617 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
618 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
619 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
620 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
621 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
622 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
623 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
624 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
625 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
626 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
627 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
628 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
629 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
630 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
631 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
632 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
633 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
634 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
635 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
636 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
637 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
638 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
639 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
640 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
641 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
642 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
643 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
644 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
645 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
646 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
647 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
648 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
649 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
650 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
651 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
652 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
653 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
654 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
655 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
656 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
657 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
658 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
659 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
660 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
661 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
662 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
663 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
664 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
665 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
666 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
667 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
668 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
669 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
670 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
671 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
672 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
673 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
674 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
675 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
676 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
677 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
678 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
679 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
680 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
681 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
682 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
683 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
684 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
685 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
686 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
687 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
688 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01'
group by target_id) as a
| | 1 | 1 | 2 |
689 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01'
group by target_id) as a
| | 1 | 1 | 2 |
690 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01'
group by target_id) as a
| | 1 | 1 | 2 |
691 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01'
group by target_id) as a
| | 1 | 1 | 2 |
692 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01'
group by target_id) as a
| | 1 | 1 | 2 |
693 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01'
group by target_id) as a
| | 1 | 1 | 2 |
694 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01'
group by target_id) as a
| | 1 | 1 | 2 |
695 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01'
group by target_id) as a
| | 1 | 1 | 2 |
696 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01'
group by target_id) as a
| | 1 | 1 | 2 |
697 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01'
group by target_id) as a
| | 1 | 1 | 2 |
698 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01'
group by target_id) as a
| | 1 | 1 | 2 |
699 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
700 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_success
where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01'
group by target_id) as a
| | 1 | 1 | 2 |