Warning (2): Illegal string offset 'username' [/var/www/unitrack/unitrack_app_model.php, line 150]
New York Center for Structural Genomics - Progresses

PSI: Biology Pipeline - Cumulative Growth

Export data as: CSV, TSV, XLS
Approved targetsWork stoppedCloning trialsSuccessful clonesExpressing clonesSoluble expressing clonesPurification attemptsSuccessful purificationsIn crystallization trialsCrystal harvestedDatasets collectedStructures deposited in PDB
Sep 201000285/479285/475312/324311/32222/2822/256/12263/32/20/0
Oct 2010290096/9696/9633/3332/3294/9994/9930/86468/93/31/1
Nov 201012350365/559361/555117/14194/10972/7570/7321/347614/7314/282/2
Dec 201074160463/734462/7038/81/124/2917/195/9602/74/84/4
Jan 201146009/109/1082/8579/7915/1515/1513/27546/92/31/1
Feb 2011261036/5036/5049/5749/5766/6964/6718/41266/94/40/0
Mar 20113610176/296128/2079/129/1227/4727/4744/1520718/11010/5111/15
Apr 201157064/6453/5368/8730/4024/3724/3713/63969/164/411/11
May 201100167/259106/13223/2324/2433/3433/3416/55802/21/11/1
Jun 20117750142/201106/12679/8078/7957/7257/7133/139525/510/101/1
Jul 2011170187/392162/32690/21290/21158/7658/7548/1560116/1107/767/7
Aug 201130692/740687/722133/136132/13586/10786/10733/264961/15/57/7
Sep 201130780430/492345/365177/218161/20287/9687/9663/292588/106/73/3
Oct 201100943/945939/941236/259238/261121/133120/13265/1955119/4113/149/9
Nov 2011001083/10901078/1085314/315314/315131/154123/14667/2961615/2716/209/9
Dec 2011884099/9999/99130/130127/127133/144127/13752/2806219/368/812/12
Jan 20121040901/1129874/95461/6165/65175/198173/195107/4473616/302/26/6
Feb 2012330701687/16901677/1680218/220215/217145/202113/15687/3268828/5522/2816/16
Mar 20127420584/584584/584213/215206/208177/190101/10981/3514516/3217/1813/13
Apr 20123801159/16491065/1463294/313290/308145/160145/160124/5000418/355/56/8
May 201240410781/1031781/1031204/208162/16675/7775/77137/545583/160/07/12
Jun 201200671/862536/665200/202179/181102/111102/11155/2164817/3212/233/3
Jul 2012166401383/19781318/1734426/437429/440121/130121/13035/1113614/378/95/5
Aug 2012320201353/20441351/1947221/263213/23359/6959/6943/119764/71/14/4
Sep 20126560585/1201506/966425/465205/22285/9685/9670/2356817/244/46/7
Oct 20122760612/1235598/104071/7858/63124/136124/13676/2753816/286/68/8
Nov 201247073751149/19351148/1841137/153141/15888/10488/10459/1898118/1709/556/6
Dec 20121780963/963954/954371/404361/378152/165152/16525/73928/150/01/1
Jan 201300851/1135789/974674/715679/723107/138107/138141/486726/81/14/4
Feb 20131040714/845639/727178/178178/17852/6351/62100/3157919/749/910/11
Mar 201314401226/15341141/1371338/368336/366144/154143/15378/3392429/37614/17317/20
Apr 20131220355/440310/39247/6147/61134/153134/15387/3006720/7413/426/18
May 2013940693/777534/584109/138109/138161/171161/171130/741609/262/43/3
Jun 201383001090/2053760/1492241/334241/334108/120108/120127/5609122/30514/632/5
Jul 201356301386/1666976/1256232/232231/231110/138110/13867/3344410/455/603/3
Aug 201358501082/1930836/1633497/500486/48885/9385/9371/221135/90/01/1
Sep 2013250545/862455/748253/256253/25661/6361/6389/254558/164/61/1
Oct 201310478/786345/591386/386261/26126/2926/2982/357695/446/135/5
Nov 20133840108/131104/1127/86/735/5135/5124/887433/21816/580/0
Dec 20131500/00/0167/167108/10833/3433/3414/46085/414/200/0
Jan 201400248/248224/2240/00/026/2726/2765/327360/01/14/4
Feb 20140015/1515/15250/251248/24930/3730/3719/72965/201/10/0
Mar 2014200/00/050/5051/5110/1110/1136/1487423/13710/560/0
Apr 20144480128/128104/1041/11/137/3937/3921/96002/41/10/0
May 201400127/12794/940/00/015/2215/2122/67208/140/01/1
Jun 20143830378/438364/420110/118110/11872/8472/8412/126570/00/00/0
Jul 2014000/00/00/00/07/77/729/1819817/55213/2161/1
Aug 2014300/00/01/11/13/33/33/2883/341/10/0
Sep 2014000/00/00/00/01/11/11/5761/11/16/6
Oct 2014000/00/00/00/05/75/721/132846/381/10/0
Nov 2014000/00/00/00/01/21/26/822320/37616/830/0
Dec 2014000/00/00/00/00/00/00/02/342/133/3
Jan 2015000/00/00/00/01/11/11/2780/02/31/1
Feb 20150094/9483/830/00/01/11/110/58560/02/30/0
Mar 2015000/00/00/00/03/33/37/68641/10/02/2
Apr 2015000/00/00/00/01/11/15/397817/4008/1210/0
May 2015000/00/00/00/00/00/00/00/00/03/3
Jun 2015000/00/00/00/02/22/20/00/01/13/3
Jul 2015000/00/00/00/01/11/10/00/01/10/0
Aug 2015000/00/00/00/00/00/00/00/00/00/0
Sep 2015000/00/00/00/00/00/07/73620/01/11/1
Oct 2015000/00/00/00/00/00/09/57559/1996/380/0
Nov 2015000/00/00/00/00/00/00/01/11/11/1
Dec 2015000/00/00/00/01/11/10/00/00/00/0
Jan 2016000/00/00/00/00/00/00/00/00/00/0
Feb 2016000/00/00/00/00/00/00/00/01/10/0
Mar 2016000/00/00/00/00/00/01/26100/00/02/2
Apr 2016000/00/00/00/01/11/12/32857/1292/130/0
May 2016000/00/00/00/00/00/00/00/00/00/0
Jun 2016000/00/00/00/00/00/00/00/00/00/0
Jul 2016000/00/00/00/00/00/00/00/00/00/0
Aug 2016000/00/00/00/01/11/10/00/00/00/0
Sep 2016000/00/00/00/02/62/61/2870/04/70/0
Oct 2016000/00/00/00/02/42/44/37690/00/00/0
Nov 2016000/00/00/00/00/00/03/20162/562/130/0
Dec 2016000/00/00/00/00/00/00/00/02/130/0
Jan 2017000/00/00/00/00/00/01/5760/01/20/0
Feb 2017000/00/00/00/00/00/02/21060/01/30/0
Mar 2017000/00/00/00/00/00/02/14401/52/40/0
Apr 2017000/00/00/00/02/22/20/00/01/30/0
May 2017000/00/00/00/00/00/00/00/01/10/0
Jun 2017000/00/00/00/00/00/00/00/00/00/0
Jul 2017000/00/00/00/00/00/00/00/00/00/0
Aug 2017000/00/00/00/00/00/00/00/00/00/0
Sep 2017000/00/00/00/00/00/01/2880/00/00/0
Oct 2017000/00/00/00/00/00/00/00/01/40/0
Nov 2017000/00/00/00/00/00/00/00/00/00/0
Dec 2017000/00/00/00/00/00/00/00/00/00/0
Jan 2018000/00/00/00/00/00/00/00/00/00/0
Feb 2018000/00/00/00/01/11/12/14400/00/00/0
Mar 2018000/00/00/00/00/00/03/11673/71/10/0
Apr 2018000/00/00/00/00/00/01/153/542/70/0
May 2018000/00/00/00/00/00/00/00/00/00/0
Jun 2018000/00/00/00/00/00/00/00/00/00/0
Jul 2018000/00/00/00/00/00/00/00/00/00/0
Aug 2018000/00/00/00/00/00/00/00/00/00/0
Sep 2018000/00/00/00/00/00/00/00/00/00/0
Oct 2018000/00/00/00/00/00/00/00/00/00/0
Nov 2018000/00/00/00/00/00/00/00/00/00/0
Dec 2018000/00/00/00/00/00/00/00/00/00/0
Jan 2019000/00/00/00/00/00/00/00/00/00/0
Feb 2019000/00/00/00/00/00/00/00/00/00/0
Mar 2019000/00/00/00/00/00/00/00/00/00/0
Apr 2019000/00/00/00/00/00/00/00/00/00/0
May 2019000/00/00/00/00/00/00/00/00/00/0
Jun 2019000/00/00/00/00/00/00/00/00/00/0
Jul 2019000/00/00/00/00/00/00/00/00/00/0
Aug 2019000/00/00/00/00/00/00/00/00/00/0
Sep 2019000/00/00/00/00/00/00/00/00/00/0
Oct 2019000/00/00/00/00/00/00/00/00/00/0
Nov 2019000/00/00/00/00/00/00/00/00/00/0
Dec 2019000/00/00/00/00/00/00/00/00/00/0
Monthly growth of the number of targets/experiments by month (using the end of the month as a cutoff).
For each category, the number of targets and number of experiments is displayed.*


    Number of experiments denotes:
  • # of constructs for "Cloning trials", "Successful clones", "Expressing clones", "Soluble expressing clones"
  • # of purification experiments for "Purification attempts" and "Succesful purifications"
  • # of crystallization drops for "Crystallization trials"
  • # of crystals collected for "Crystals harvested"
  • # of datasets collected for "Datasets collected"
  • # of structures solved for "Structures solved"
  • # of PDB deposits for "Structures deposited in PDB"
(default) 1486 queries took 9069 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT 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';10910917
2SELECT matviewname as name FROM pg_matviews;001
3SELECT 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';1091093
4SELECT matviewname as name FROM pg_matviews;001
5SELECT 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';1091093
6SELECT matviewname as name FROM pg_matviews;001
7SELECT 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';1091093
8SELECT matviewname as name FROM pg_matviews;001
9SELECT 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';1091093
10SELECT matviewname as name FROM pg_matviews;001
11SELECT 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';1091093
12SELECT matviewname as name FROM pg_matviews;001
13SELECT 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';1091093
14SELECT matviewname as name FROM pg_matviews;001
15SELECT 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';1091093
16SELECT matviewname as name FROM pg_matviews;001
17SELECT 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';1091093
18SELECT matviewname as name FROM pg_matviews;001
19SELECT 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';1091093
20SELECT matviewname as name FROM pg_matviews;001
21SELECT 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';1091093
22SELECT matviewname as name FROM pg_matviews;001
23SELECT 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';1091093
24SELECT matviewname as name FROM pg_matviews;001
25SELECT 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';1091093
26SELECT matviewname as name FROM pg_matviews;001
27SELECT 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';1091093
28SELECT matviewname as name FROM pg_matviews;001
29SELECT 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';1091093
30SELECT matviewname as name FROM pg_matviews;001
31SELECT 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';1091094
32SELECT matviewname as name FROM pg_matviews;001
33SELECT 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';1091093
34SELECT matviewname as name FROM pg_matviews;001
35SELECT 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';1091093
36SELECT matviewname as name FROM pg_matviews;001
37SELECT 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';1091093
38SELECT matviewname as name FROM pg_matviews;001
39SELECT 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';1091093
40SELECT matviewname as name FROM pg_matviews;001
41SELECT 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';1091093
42SELECT matviewname as name FROM pg_matviews;001
43SELECT 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';1091093
44SELECT matviewname as name FROM pg_matviews;001
45SELECT 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';1091093
46SELECT matviewname as name FROM pg_matviews;001
47SELECT 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';1091093
48SELECT matviewname as name FROM pg_matviews;001
49SELECT 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';1091093
50SELECT matviewname as name FROM pg_matviews;001
51SELECT 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';1091093
52SELECT matviewname as name FROM pg_matviews;001
53SELECT 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';1091094
54SELECT matviewname as name FROM pg_matviews;001
55SELECT 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';1091093
56SELECT matviewname as name FROM pg_matviews;001
57SELECT 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';1091093
58SELECT matviewname as name FROM pg_matviews;001
59SELECT 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';1091093
60SELECT matviewname as name FROM pg_matviews;001
61SELECT 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';1091093
62SELECT matviewname as name FROM pg_matviews;001
63SELECT 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';1091093
64SELECT matviewname as name FROM pg_matviews;001
65SELECT 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';1091093
66SELECT matviewname as name FROM pg_matviews;001
67SELECT 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';1091093
68SELECT matviewname as name FROM pg_matviews;001
69SELECT 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';1091093
70SELECT matviewname as name FROM pg_matviews;001
71SELECT 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';1091094
72SELECT matviewname as name FROM pg_matviews;001
73SELECT 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';1091093
74SELECT matviewname as name FROM pg_matviews;001
75SELECT 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';1091093
76SELECT matviewname as name FROM pg_matviews;001
77SELECT 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';1091093
78SELECT matviewname as name FROM pg_matviews;001
79SELECT 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';1091093
80SELECT matviewname as name FROM pg_matviews;001
81SELECT 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';1091094
82SELECT matviewname as name FROM pg_matviews;001
83SELECT 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';1091093
84SELECT matviewname as name FROM pg_matviews;001
85SELECT 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';1091093
86SELECT matviewname as name FROM pg_matviews;001
87SELECT 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';1091093
88SELECT matviewname as name FROM pg_matviews;001
89SELECT 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';1091094
90SELECT matviewname as name FROM pg_matviews;001
91SELECT 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';1091093
92SELECT matviewname as name FROM pg_matviews;001
93SELECT "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 1003
94SELECT "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 1001
95begin000
96create 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) ;332180445
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 1146
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 116
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 1112
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 1151
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 117
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 116
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 117
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 115
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 115
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 1110
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 115
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 115
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 1123
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 115
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 115
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 1110
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 116
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 1125
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 119
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 116
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 1129
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 116
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 1115
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 1124
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 1110
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 117
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 119
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 117
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 116
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 117
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 117
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 117
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 116
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 1110
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 119
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 119
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 116
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 116
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 118
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 116
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 116
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 116
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 116
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 118
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 116
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 118
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 116
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 116
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 116
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 116
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 116
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 117
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 117
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 117
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 117
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 116
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 117
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 116
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 116
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 117
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 116
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 116
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 116
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 117
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 116
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 117
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 116
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 117
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 116
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 116
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 116
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 116
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 117
209drop table cumulative_targets;0035
210commit0038
211begin000
212create 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) ;7375070
213 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 112
214 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 111
215 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 111
216 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 111
217 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 111
218 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 111
219 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 111
220 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 111
221 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 111
222 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 111
223 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 111
224 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 111
225 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 111
226 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 111
227 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 111
228 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 111
229 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 111
230 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 111
231 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 111
232 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 111
233 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 111
234 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 111
235 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 111
236 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 111
237 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 111
238 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 111
239 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 1148
240 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 112
241 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 112
242 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 112
243 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 112
244 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 112
245 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 112
246 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 112
247 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 112
248 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 112
249 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 112
250 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 112
251 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 112
252 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 112
253 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 112
254 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 112
255 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 112
256 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 112
257 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 112
258 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 112
259 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 112
260 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 112
261 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 112
262 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 112
263 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 112
264 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 112
265 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 112
266 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 112
267 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 112
268 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 112
269 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 112
270 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 112
271 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 112
272 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 112
273 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 112
274 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 112
275 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 112
276 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 112
277 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 112
278 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 112
279 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 112
280 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 112
281 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 112
282 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 112
283 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 112
284 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 112
285 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 112
286 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 112
287 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 112
288 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 112
289 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 112
290 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 112
291 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 112
292 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 112
293 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 112
294 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 112
295 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 112
296 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 112
297 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 112
298 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 112
299 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 112
300 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 112
301 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 112
302 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 112
303 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 112
304 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 112
305 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 112
306 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 112
307 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 112
308 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 112
309 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 112
310 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 112
311 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 112
312 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 112
313 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 112
314 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 112
315 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 112
316 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 112
317 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 112
318 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 112
319 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 112
320 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 112
321 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 112
322 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 112
323 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 112
324 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 112
325drop table cumulative_targets_stopped;001
326commit0025
327begin000
328create 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;295860126
329 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 117
330 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 115
331 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 116
332 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 117
333 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 114
334 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 115
335 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 115
336 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 114
337 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 115
338 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 115
339 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 115
340 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 118
341 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 117
342 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 119
343 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 1110
344 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 115
345 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 1110
346 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 1114
347 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 118
348 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 1111
349 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 119
350 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 119
351 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 1113
352 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 1113
353 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 118
354 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 1110
355 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 1112
356 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 1110
357 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 1110
358 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 119
359 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 1113
360 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 117
361 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 119
362 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 1111
363 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 1113
364 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 1111
365 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 118
366 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 118
367 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 116
368 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 116
369 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 117
370 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 116
371 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 115
372 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 116
373 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 116
374 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 117
375 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 116
376 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 116
377 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 116
378 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 115
379 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 115
380 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 116
381 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 115
382 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 116
383 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 115
384 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 115
385 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 115
386 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 115
387 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 116
388 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 115
389 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 115
390 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 116
391 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 116
392 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 115
393 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 115
394 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 116
395 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 116
396 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 116
397 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 115
398 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 115
399 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 115
400 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 116
401 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 116
402 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 115
403 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 115
404 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 116
405 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 115
406 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 115
407 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 116
408 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 115
409 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 116
410 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 115
411 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 116
412 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 115
413 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 116
414 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 115
415 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 115
416 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 116
417 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 115
418 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 115
419 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 116
420 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 116
421 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 116
422 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 115
423 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 115
424 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 115
425 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 116
426 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 116
427 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 115
428 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 115
429 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 115
430 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 116
431 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 115
432 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 115
433 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 115
434 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 116
435 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 116
436 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 116
437 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 115
438 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 115
439 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 115
440 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 116
441drop table cumulative_clones;001
442commit0023
443begin000
444create 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;266880108
445 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 116
446 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 115
447 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 116
448 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 116
449 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 115
450 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 116
451 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 115
452 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 114
453 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 115
454 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 114
455 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 115
456 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 117
457 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 116
458 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 119
459 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 1110
460 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 115
461 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 119
462 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 1114
463 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 117
464 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 1111
465 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 119
466 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 117
467 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 1112
468 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 1113
469 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 118
470 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 119
471 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 1111
472 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 1110
473 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 119
474 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 118
475 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 1112
476 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 117
477 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 118
478 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 1110
479 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 1111
480 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 1110
481 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 118
482 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 117
483 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 115
484 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 115
485 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 116
486 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 115
487 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 115
488 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 116
489 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 116
490 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 117
491 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 115
492 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 115
493 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 115
494 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 115
495 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 115
496 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 115
497 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 115
498 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 115
499 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 115
500 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 115
501 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 115
502 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 115
503 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 115
504 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 115
505 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 115
506 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 115
507 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 115
508 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 115
509 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 115
510 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 115
511 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 115
512 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 115
513 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 115
514 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 115
515 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 115
516 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 115
517 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 115
518 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 115
519 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 115
520 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 115
521 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 115
522 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 115
523 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 115
524 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 115
525 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 115
526 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 115
527 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 115
528 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 115
529 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 115
530 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 115
531 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 115
532 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 115
533 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 115
534 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 115
535 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 115
536 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 116
537 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 115
538 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 115
539 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 115
540 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 115
541 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 115
542 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 115
543 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 115
544 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 115
545 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 115
546 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 115
547 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 115
548 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 115
549 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 115
550 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 115
551 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 115
552 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 115
553 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 115
554 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 115
555 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 115
556 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 115
557drop table cumulative_clones_success;001
558commit0020
559begin000
560create 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;85760279
561 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 114
562 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 112
563 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 112
564 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 112
565 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 112
566 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 112
567 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 112
568 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 112
569 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 112
570 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 112
571 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 112
572 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 112
573 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 113
574 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 113
575 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 113
576 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 112
577 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 112
578 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 113
579 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 113
580 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 113
581 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 113
582 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 113
583 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 114
584 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 113
585 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 114
586 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 112
587 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 112
588 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 113
589 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 115
590 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 113
591 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 113
592 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 112
593 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 112
594 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 113
595 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 113
596 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 114
597 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 113
598 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 114
599 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 112
600 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 113
601 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 112
602 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 113
603 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 112
604 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 112
605 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 112
606 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 113
607 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 112
608 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 112
609 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 112
610 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 112
611 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 112
612 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 112
613 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 112
614 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 112
615 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 112
616 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 112
617 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 112
618 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 112
619 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 112
620 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 112
621 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 112
622 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 112
623 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 112
624 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 112
625 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 112
626 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 112
627 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 112
628 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 112
629 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 112
630 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 112
631 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 112
632 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 112
633 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 112
634 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 112
635 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 112
636 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 112
637 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 112
638 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 112
639 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 112
640 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 112
641 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 112
642 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 112
643 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 112
644 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 112
645 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01' group by target_id) as a 112
646 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01' group by target_id) as a 112
647 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01' group by target_id) as a 112
648 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01' group by target_id) as a 112
649 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01' group by target_id) as a 112
650 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01' group by target_id) as a 112
651 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01' group by target_id) as a 112
652 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01' group by target_id) as a 112
653 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01' group by target_id) as a 112
654 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01' group by target_id) as a 112
655 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01' group by target_id) as a 112
656 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01' group by target_id) as a 112
657 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01' group by target_id) as a 112
658 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01' group by target_id) as a 112
659 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01' group by target_id) as a 112
660 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01' group by target_id) as a 112
661 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01' group by target_id) as a 112
662 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01' group by target_id) as a 112
663 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01' group by target_id) as a 112
664 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01' group by target_id) as a 112
665 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01' group by target_id) as a 112
666 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01' group by target_id) as a 112
667 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01' group by target_id) as a 112
668 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01' group by target_id) as a 112
669 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01' group by target_id) as a 112
670 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01' group by target_id) as a 112
671 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01' group by target_id) as a 112
672 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01' group by target_id) as a 112
673drop table cumulative_clones_express;001
674commit0032
675begin000
676create temporary table cumulative_clones_soluble 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 and e.status='success' left join purification p on e.id=p.expression_id and p.status='success' where e.solubility_level >= 10 or p.id is not null 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;79230201
677 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01' group by target_id) as a 113
678 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01' group by target_id) as a 111
679 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01' group by target_id) as a 112
680 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01' group by target_id) as a 111
681 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01' group by target_id) as a 112
682 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01' group by target_id) as a 112
683 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01' group by target_id) as a 111
684 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01' group by target_id) as a 112
685 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01' group by target_id) as a 112
686 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01' group by target_id) as a 112
687 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01' group by target_id) as a 112
688 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01' group by target_id) as a 112
689 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-10-01' and experiment_date >= '2011-09-01' group by target_id) as a 112
690 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01' group by target_id) as a 113
691 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01' group by target_id) as a 113
692 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01' group by target_id) as a 112
693 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01' group by target_id) as a 112
694 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01' group by target_id) as a 113
695 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01' group by target_id) as a 112
696 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01' group by target_id) as a 113
697 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01' group by target_id) as a 112
698 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01' group by target_id) as a 112
699 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01' group by target_id) as a 114
700 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01' group by target_id) as a 113
(labdb) 2 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932934
2SELECT matviewname as name FROM pg_matviews;001
(psipubs) 12 queries took 45 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32328
2SELECT matviewname as name FROM pg_matviews;004
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';323212
4SELECT matviewname as name FROM pg_matviews;001
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32323
6SELECT matviewname as name FROM pg_matviews;001
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32323
8SELECT matviewname as name FROM pg_matviews;001
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32323
10SELECT matviewname as name FROM pg_matviews;005
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32323
12SELECT matviewname as name FROM pg_matviews;001