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 | 14 |
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 | 3 |
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 | 3 |
6 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
8 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
10 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
12 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
14 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
16 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
18 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
20 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
22 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 4 |
24 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
26 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
28 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
30 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
32 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
34 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
36 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
38 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
40 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
42 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
44 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
46 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
48 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
50 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
52 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
54 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
56 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
58 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
60 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
62 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
64 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
66 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
68 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
70 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
72 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
74 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
76 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
78 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
80 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
82 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
84 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
86 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
88 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
90 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 3 |
92 | SELECT matviewname as name FROM pg_matviews; | | 0 | 0 | 1 |
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 | 2 |
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 | 1 |
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 | 39 |
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 | 5 |
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 | 5 |
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 | 9 |
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 | 43 |
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 | 6 |
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 | 5 |
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 | 6 |
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 | 4 |
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 | 4 |
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 | 8 |
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 | 4 |
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 | 4 |
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 | 19 |
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 | 4 |
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 | 4 |
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 | 8 |
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 | 5 |
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 | 21 |
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 | 8 |
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 | 5 |
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 | 25 |
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 | 5 |
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 | 13 |
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 | 21 |
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 | 8 |
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 | 6 |
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 | 7 |
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 | 6 |
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 | 5 |
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 | 6 |
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 | 6 |
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 | 6 |
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 | 6 |
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 | 9 |
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 | 8 |
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 | 8 |
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 | 5 |
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 | 5 |
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 | 7 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 7 |
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 | 5 |
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 | 7 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
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 | 5 |
223 | drop table cumulative_targets; | | 0 | 0 | 1 |
224 | commit | | 0 | 0 | 43 |
225 | begin | | 0 | 0 | 0 |
226 | 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 | 22 |
227 |
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 |
228 |
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 |
229 |
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 |
230 |
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 |
231 |
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 |
232 |
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 |
233 |
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 |
234 |
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 |
235 |
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 |
236 |
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 |
237 |
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 |
238 |
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 |
239 |
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 |
240 |
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 |
241 |
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 |
242 |
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 |
243 |
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 |
244 |
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 |
245 |
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 |
246 |
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 |
247 |
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 |
248 |
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 |
249 |
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 |
250 |
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 |
251 |
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 |
252 |
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 |
253 |
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 | 40 |
254 |
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 |
255 |
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 |
256 |
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 |
257 |
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 |
258 |
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 |
259 |
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 |
260 |
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 |
261 |
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 |
262 |
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 |
263 |
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 |
264 |
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 |
265 |
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 |
266 |
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 |
267 |
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 |
268 |
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 |
269 |
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 |
270 |
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 |
271 |
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 |
272 |
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 |
273 |
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 |
274 |
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 |
275 |
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 |
276 |
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 |
277 |
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 |
278 |
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 |
279 |
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 |
280 |
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 |
281 |
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 |
282 |
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 |
283 |
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 |
284 |
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 |
285 |
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 |
286 |
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 |
287 |
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 |
288 |
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 |
289 |
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 |
290 |
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 |
291 |
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 |
292 |
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 |
293 |
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 |
294 |
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 |
295 |
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 |
296 |
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 |
297 |
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 |
298 |
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 |
299 |
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 |
300 |
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 |
301 |
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 |
302 |
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 |
303 |
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 |
304 |
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 |
305 |
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 |
306 |
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 |
307 |
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 |
308 |
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 |
309 |
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 |
310 |
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 |
311 |
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 |
312 |
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 |
313 |
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 |
314 |
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 |
315 |
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 |
316 |
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 |
317 |
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 |
318 |
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 |
319 |
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 |
320 |
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 |
321 |
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 |
322 |
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 |
323 |
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 |
324 |
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 |
325 |
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 |
326 |
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 |
327 |
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 |
328 |
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 |
329 |
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 |
330 |
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 |
331 |
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 |
332 |
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 |
333 |
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 |
334 |
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 |
335 |
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 |
336 |
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 |
337 |
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 |
338 |
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 |
339 |
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 |
340 |
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 |
341 |
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 |
342 |
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 |
343 |
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 |
344 |
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 |
345 |
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 |
346 |
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 |
347 |
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 |
348 |
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 |
349 |
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 |
350 |
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 |
351 |
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 |
352 |
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 |
353 | drop table cumulative_targets_stopped; | | 0 | 0 | 1 |
354 | commit | | 0 | 0 | 13 |
355 | begin | | 0 | 0 | 0 |
356 | 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 | 80 |
357 |
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 | 5 |
358 |
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 | 4 |
359 |
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 | 5 |
360 |
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 | 5 |
361 |
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 | 3 |
362 |
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 | 3 |
363 |
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 | 4 |
364 |
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 | 4 |
365 |
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 | 4 |
366 |
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 | 4 |
367 |
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 | 4 |
368 |
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 | 7 |
369 |
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 | 5 |
370 |
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 | 8 |
371 |
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 | 9 |
372 |
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 | 4 |
373 |
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 | 8 |
374 |
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 | 12 |
375 |
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 | 6 |
376 |
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 | 9 |
377 |
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 | 7 |
378 |
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 | 7 |
379 |
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 | 11 |
380 |
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 | 11 |
381 |
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 | 7 |
382 |
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 | 8 |
383 |
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 | 10 |
384 |
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 | 9 |
385 |
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 | 9 |
386 |
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 | 8 |
387 |
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 | 11 |
388 |
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 | 6 |
389 |
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 | 8 |
390 |
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 | 10 |
391 |
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 | 11 |
392 |
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 | 10 |
393 |
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 | 7 |
394 |
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 | 7 |
395 |
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 | 5 |
396 |
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 | 5 |
397 |
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 | 6 |
398 |
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 | 5 |
399 |
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 | 5 |
400 |
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 | 5 |
401 |
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 | 5 |
402 |
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 | 6 |
403 |
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 | 5 |
404 |
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 | 5 |
405 |
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 | 5 |
406 |
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 | 5 |
407 |
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 | 5 |
408 |
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 | 5 |
409 |
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 | 5 |
410 |
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 | 5 |
411 |
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 | 5 |
412 |
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 | 5 |
413 |
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 | 5 |
414 |
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 | 5 |
415 |
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 | 5 |
416 |
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 | 5 |
417 |
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 | 5 |
418 |
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 | 5 |
419 |
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 | 5 |
420 |
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 | 5 |
421 |
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 | 5 |
422 |
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 | 5 |
423 |
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 | 5 |
424 |
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 | 5 |
425 |
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 | 5 |
426 |
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 | 5 |
427 |
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 | 5 |
428 |
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 | 5 |
429 |
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 | 5 |
430 |
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 | 5 |
431 |
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 | 5 |
432 |
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 | 5 |
433 |
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 | 5 |
434 |
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 |
435 |
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 | 5 |
436 |
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 | 5 |
437 |
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 | 5 |
438 |
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 | 5 |
439 |
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 | 5 |
440 |
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 | 5 |
441 |
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 | 5 |
442 |
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 | 5 |
443 |
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 | 5 |
444 |
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 | 5 |
445 |
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 | 5 |
446 |
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 | 5 |
447 |
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 | 5 |
448 |
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 | 5 |
449 |
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 | 5 |
450 |
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 | 5 |
451 |
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 | 5 |
452 |
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 | 5 |
453 |
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 | 5 |
454 |
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 | 7 |
455 |
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 | 6 |
456 |
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 | 5 |
457 |
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 | 5 |
458 |
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 | 5 |
459 |
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 | 5 |
460 |
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 | 5 |
461 |
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 | 5 |
462 |
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 | 5 |
463 |
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 | 5 |
464 |
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 | 5 |
465 |
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 | 5 |
466 |
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 | 5 |
467 |
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 | 5 |
468 |
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 | 5 |
469 |
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 | 5 |
470 |
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 | 5 |
471 |
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 | 5 |
472 |
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 | 5 |
473 |
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 | 5 |
474 |
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 | 5 |
475 |
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 | 5 |
476 |
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 | 5 |
477 |
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 | 5 |
478 |
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 | 5 |
479 |
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 | 5 |
480 |
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 | 5 |
481 |
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 | 5 |
482 |
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 | 5 |
483 | drop table cumulative_clones; | | 0 | 0 | 1 |
484 | commit | | 0 | 0 | 384 |
485 | begin | | 0 | 0 | 0 |
486 | 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 | 81 |
487 |
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 | 5 |
488 |
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 | 3 |
489 |
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 | 4 |
490 |
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 | 5 |
491 |
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 | 3 |
492 |
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 | 3 |
493 |
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 | 4 |
494 |
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 | 3 |
495 |
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 | 3 |
496 |
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 | 3 |
497 |
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 | 4 |
498 |
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 | 6 |
499 |
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 | 5 |
500 |
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 | 7 |
501 |
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 | 8 |
502 |
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 | 4 |
503 |
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 | 7 |
504 |
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 | 12 |
505 |
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 | 6 |
506 |
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 | 9 |
507 |
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 | 7 |
508 |
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 | 6 |
509 |
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 | 10 |
510 |
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 | 11 |
511 |
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 | 6 |
512 |
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 | 7 |
513 |
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 | 9 |
514 |
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 | 8 |
515 |
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 | 8 |
516 |
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 | 7 |
517 |
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 | 9 |
518 |
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 | 5 |
519 |
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 | 6 |
520 |
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 | 8 |
521 |
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 | 9 |
522 |
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 | 8 |
523 |
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 | 6 |
524 |
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 | 6 |
525 |
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 | 5 |
526 |
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 | 4 |
527 |
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 | 5 |
528 |
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 | 4 |
529 |
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 | 4 |
530 |
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 | 5 |
531 |
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 | 5 |
532 |
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 | 6 |
533 |
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 | 4 |
534 |
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 | 4 |
535 |
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 | 4 |
536 |
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 | 4 |
537 |
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 | 4 |
538 |
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 | 4 |
539 |
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 | 4 |
540 |
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 | 5 |
541 |
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 | 4 |
542 |
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 | 4 |
543 |
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 | 4 |
544 |
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 | 4 |
545 |
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 | 4 |
546 |
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 | 4 |
547 |
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 | 4 |
548 |
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 | 4 |
549 |
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 | 4 |
550 |
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 | 4 |
551 |
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 | 4 |
552 |
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 | 4 |
553 |
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 | 4 |
554 |
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 | 4 |
555 |
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 | 4 |
556 |
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 | 4 |
557 |
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 | 4 |
558 |
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 | 4 |
559 |
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 | 4 |
560 |
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 | 4 |
561 |
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 | 4 |
562 |
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 | 4 |
563 |
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 | 4 |
564 |
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 | 4 |
565 |
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 | 4 |
566 |
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 | 4 |
567 |
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 | 4 |
568 |
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 | 4 |
569 |
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 | 4 |
570 |
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 | 4 |
571 |
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 | 4 |
572 |
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 | 4 |
573 |
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 | 4 |
574 |
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 | 4 |
575 |
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 | 4 |
576 |
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 | 4 |
577 |
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 | 4 |
578 |
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 | 4 |
579 |
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 | 4 |
580 |
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 | 4 |
581 |
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 | 4 |
582 |
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 | 4 |
583 |
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 | 4 |
584 |
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 | 4 |
585 |
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 | 4 |
586 |
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 | 4 |
587 |
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 | 4 |
588 |
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 | 4 |
589 |
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 | 4 |
590 |
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 | 4 |
591 |
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 | 4 |
592 |
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 | 4 |
593 |
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 | 4 |
594 |
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 | 4 |
595 |
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 | 4 |
596 |
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 | 4 |
597 |
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 | 4 |
598 |
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 | 4 |
599 |
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 | 4 |
600 |
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 | 4 |
601 |
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 | 4 |
602 |
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 | 4 |
603 |
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 | 4 |
604 |
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 | 4 |
605 |
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 | 4 |
606 |
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 | 4 |
607 |
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 | 4 |
608 |
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 | 4 |
609 |
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 | 4 |
610 |
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 | 4 |
611 |
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 | 4 |
612 |
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 | 4 |
613 | drop table cumulative_clones_success; | | 0 | 0 | 1 |
614 | commit | | 0 | 0 | 42 |
615 | begin | | 0 | 0 | 0 |
616 | create temporary table cumulative_clones_express as SELECT c.target_id, c_success.experiment_date, count(*) as count FROM (select c.id, min(e.experiment_date_start) as experiment_date
from clone c join expression e on c.id = e.clone_id
where e.status = 'success'
group by c.id) as c_success
join
clone c on c_success.id = c.id WHERE (true) AND (1=1) GROUP BY c.target_id, c_success.experiment_date; | | 8576 | 0 | 145 |
617 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
618 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01'
group by target_id) as a
| | 1 | 1 | 1 |
619 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2010-12-01' and experiment_date >= '2010-11-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_express
where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01'
group by target_id) as a
| | 1 | 1 | 1 |
621 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
622 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01'
group by target_id) as a
| | 1 | 1 | 1 |
623 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01'
group by target_id) as a
| | 1 | 1 | 1 |
624 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01'
group by target_id) as a
| | 1 | 1 | 1 |
625 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01'
group by target_id) as a
| | 1 | 1 | 1 |
626 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01'
group by target_id) as a
| | 1 | 1 | 1 |
627 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2011-08-01' and experiment_date >= '2011-07-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_express
where experiment_date < '2011-09-01' and experiment_date >= '2011-08-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_express
where experiment_date < '2011-10-01' and experiment_date >= '2011-09-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_express
where experiment_date < '2011-11-01' and experiment_date >= '2011-10-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_express
where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01'
group by target_id) as a
| | 1 | 1 | 3 |
632 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2012-01-01' and experiment_date >= '2011-12-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_express
where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01'
group by target_id) as a
| | 1 | 1 | 1 |
634 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2012-03-01' and experiment_date >= '2012-02-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_express
where experiment_date < '2012-04-01' and experiment_date >= '2012-03-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_express
where experiment_date < '2012-05-01' and experiment_date >= '2012-04-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_express
where experiment_date < '2012-06-01' and experiment_date >= '2012-05-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_express
where experiment_date < '2012-07-01' and experiment_date >= '2012-06-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_express
where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01'
group by target_id) as a
| | 1 | 1 | 3 |
640 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2012-09-01' and experiment_date >= '2012-08-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_express
where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
642 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2012-11-01' and experiment_date >= '2012-10-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_express
where experiment_date < '2012-12-01' and experiment_date >= '2012-11-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_express
where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01'
group by target_id) as a
| | 1 | 1 | 3 |
645 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01'
group by target_id) as a
| | 1 | 1 | 4 |
646 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-03-01' and experiment_date >= '2013-02-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_express
where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01'
group by target_id) as a
| | 1 | 1 | 3 |
648 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-05-01' and experiment_date >= '2013-04-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_express
where experiment_date < '2013-06-01' and experiment_date >= '2013-05-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_express
where experiment_date < '2013-07-01' and experiment_date >= '2013-06-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_express
where experiment_date < '2013-08-01' and experiment_date >= '2013-07-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_express
where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01'
group by target_id) as a
| | 1 | 1 | 4 |
653 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01'
group by target_id) as a
| | 1 | 1 | 3 |
654 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01'
group by target_id) as a
| | 1 | 1 | 3 |
655 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2013-12-01' and experiment_date >= '2013-11-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_express
where experiment_date < '2014-01-01' and experiment_date >= '2013-12-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_express
where experiment_date < '2014-02-01' and experiment_date >= '2014-01-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_express
where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01'
group by target_id) as a
| | 1 | 1 | 3 |
659 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2014-04-01' and experiment_date >= '2014-03-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_express
where experiment_date < '2014-05-01' and experiment_date >= '2014-04-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_express
where experiment_date < '2014-06-01' and experiment_date >= '2014-05-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_express
where experiment_date < '2014-07-01' and experiment_date >= '2014-06-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_express
where experiment_date < '2014-08-01' and experiment_date >= '2014-07-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_express
where experiment_date < '2014-09-01' and experiment_date >= '2014-08-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_express
where experiment_date < '2014-10-01' and experiment_date >= '2014-09-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_express
where experiment_date < '2014-11-01' and experiment_date >= '2014-10-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_express
where experiment_date < '2014-12-01' and experiment_date >= '2014-11-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_express
where experiment_date < '2015-01-01' and experiment_date >= '2014-12-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_express
where experiment_date < '2015-02-01' and experiment_date >= '2015-01-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_express
where experiment_date < '2015-03-01' and experiment_date >= '2015-02-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_express
where experiment_date < '2015-04-01' and experiment_date >= '2015-03-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_express
where experiment_date < '2015-05-01' and experiment_date >= '2015-04-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_express
where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01'
group by target_id) as a
| | 1 | 1 | 2 |
674 |
select count(target_id), sum(count)
from
(select target_id, sum(count) as count
from cumulative_clones_express
where experiment_date < '2015-07-01' and experiment_date >= '2015-06-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_express
where experiment_date < '2015-08-01' and experiment_date >= '2015-07-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_express
where experiment_date < '2015-09-01' and experiment_date >= '2015-08-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_express
where experiment_date < '2015-10-01' and experiment_date >= '2015-09-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_express
where experiment_date < '2015-11-01' and experiment_date >= '2015-10-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_express
where experiment_date < '2015-12-01' and experiment_date >= '2015-11-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_express
where experiment_date < '2016-01-01' and experiment_date >= '2015-12-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_express
where experiment_date < '2016-02-01' and experiment_date >= '2016-01-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_express
where experiment_date < '2016-03-01' and experiment_date >= '2016-02-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_express
where experiment_date < '2016-04-01' and experiment_date >= '2016-03-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_express
where experiment_date < '2016-05-01' and experiment_date >= '2016-04-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_express
where experiment_date < '2016-06-01' and experiment_date >= '2016-05-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_express
where experiment_date < '2016-07-01' and experiment_date >= '2016-06-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_express
where experiment_date < '2016-08-01' and experiment_date >= '2016-07-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_express
where experiment_date < '2016-09-01' and experiment_date >= '2016-08-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_express
where experiment_date < '2016-10-01' and experiment_date >= '2016-09-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_express
where experiment_date < '2016-11-01' and experiment_date >= '2016-10-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_express
where experiment_date < '2016-12-01' and experiment_date >= '2016-11-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_express
where experiment_date < '2017-01-01' and experiment_date >= '2016-12-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_express
where experiment_date < '2017-02-01' and experiment_date >= '2017-01-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_express
where experiment_date < '2017-03-01' and experiment_date >= '2017-02-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_express
where experiment_date < '2017-04-01' and experiment_date >= '2017-03-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_express
where experiment_date < '2017-05-01' and experiment_date >= '2017-04-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_express
where experiment_date < '2017-06-01' and experiment_date >= '2017-05-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_express
where experiment_date < '2017-07-01' and experiment_date >= '2017-06-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_express
where experiment_date < '2017-08-01' and experiment_date >= '2017-07-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_express
where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01'
group by target_id) as a
| | 1 | 1 | 2 |