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
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) 1438 queries took 4198 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';1091098
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';1091092
4SELECT matviewname as name FROM pg_matviews;000
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';1091091
6SELECT matviewname as name FROM pg_matviews;000
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';1091091
8SELECT matviewname as name FROM pg_matviews;000
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';1091091
10SELECT matviewname as name FROM pg_matviews;000
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';1091092
12SELECT matviewname as name FROM pg_matviews;000
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';1091091
14SELECT matviewname as name FROM pg_matviews;000
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';1091092
16SELECT matviewname as name FROM pg_matviews;000
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';1091092
18SELECT matviewname as name FROM pg_matviews;000
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';1091092
20SELECT matviewname as name FROM pg_matviews;000
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';1091092
22SELECT matviewname as name FROM pg_matviews;000
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';1091092
24SELECT matviewname as name FROM pg_matviews;000
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';1091092
30SELECT matviewname as name FROM pg_matviews;000
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';1091092
32SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
36SELECT matviewname as name FROM pg_matviews;000
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';1091092
38SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091092
48SELECT matviewname as name FROM pg_matviews;000
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';1091092
50SELECT matviewname as name FROM pg_matviews;000
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';1091092
52SELECT matviewname as name FROM pg_matviews;000
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';1091092
54SELECT matviewname as name FROM pg_matviews;000
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';1091092
56SELECT matviewname as name FROM pg_matviews;000
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';1091092
58SELECT matviewname as name FROM pg_matviews;000
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';1091092
60SELECT matviewname as name FROM pg_matviews;000
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';1091092
62SELECT matviewname as name FROM pg_matviews;000
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';1091092
64SELECT matviewname as name FROM pg_matviews;000
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';1091092
66SELECT matviewname as name FROM pg_matviews;000
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';1091092
68SELECT matviewname as name FROM pg_matviews;000
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';1091092
70SELECT matviewname as name FROM pg_matviews;000
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';1091092
72SELECT matviewname as name FROM pg_matviews;000
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';1091092
74SELECT matviewname as name FROM pg_matviews;000
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';1091092
76SELECT matviewname as name FROM pg_matviews;000
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';1091092
78SELECT matviewname as name FROM pg_matviews;000
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';1091092
80SELECT matviewname as name FROM pg_matviews;000
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';1091092
82SELECT matviewname as name FROM pg_matviews;000
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';1091092
84SELECT matviewname as name FROM pg_matviews;000
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';1091092
86SELECT matviewname as name FROM pg_matviews;000
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';1091092
88SELECT matviewname as name FROM pg_matviews;000
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';1091092
90SELECT matviewname as name FROM pg_matviews;000
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';1091092
92SELECT matviewname as name FROM pg_matviews;000
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 1002
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) ;33218041
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 114
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 113
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 116
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 1126
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 114
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 113
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 113
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 113
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 113
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 114
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 113
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 112
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 1111
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 113
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 113
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 115
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 113
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 1112
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 115
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 113
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 1114
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 113
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 117
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 1112
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 115
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 113
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 114
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 113
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 113
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 113
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 113
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 113
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 113
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 115
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 114
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 114
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 113
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 113
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 114
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 113
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 113
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 113
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 113
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 114
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 113
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 114
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 114
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 114
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 114
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 114
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 114
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
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 113
205drop table cumulative_targets;002
206commit006
207begin000
208create 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) ;7375018
209 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 111
210 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
211 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
212 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
213 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
214 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
215 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
216 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
217 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
218 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
219 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
220 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
221 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
222 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
223 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
224 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
225 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 112
226 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 112
227 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
228 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
229 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
230 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
231 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
232 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
233 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
234 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
235 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 1124
236 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 111
237 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 111
238 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 111
239 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 111
240 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 111
241 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 111
242 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 111
243 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 111
244 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 111
245 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 111
246 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 111
247 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 111
248 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 111
249 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 111
250 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 111
251 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 111
252 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 111
253 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 111
254 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 111
255 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 111
256 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 111
257 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 111
258 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 111
259 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 111
260 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 111
261 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 111
262 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 111
263 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 111
264 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 111
265 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 111
266 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 111
267 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 111
268 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 111
269 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 111
270 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 111
271 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 111
272 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 111
273 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 111
274 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 111
275 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 111
276 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 111
277 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 111
278 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 111
279 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 111
280 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 111
281 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 111
282 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 111
283 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 111
284 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 111
285 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 111
286 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 111
287 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 111
288 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 111
289 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 111
290 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 111
291 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 111
292 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 111
293 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 111
294 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 111
295 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 111
296 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 111
297 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 111
298 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 111
299 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 111
300 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 111
301 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 111
302 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 111
303 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 111
304 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 111
305 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 111
306 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 111
307 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 111
308 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 111
309 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 111
310 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 111
311 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 111
312 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 111
313 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 111
314 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 111
315 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 111
316 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 111
317drop table cumulative_targets_stopped;000
318commit004
319begin000
320create 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;29586056
321 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 114
322 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 113
323 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 114
324 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 114
325 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 113
326 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 113
327 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 113
328 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 113
329 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 113
330 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 113
331 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 113
332 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 117
333 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 114
334 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 116
335 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 116
336 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 113
337 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 116
338 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 119
339 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 115
340 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 118
341 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 116
342 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 115
343 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 1114
344 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 117
345 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 114
346 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 115
347 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 116
348 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 115
349 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 115
350 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 114
351 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
352 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 113
353 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 116
354 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 116
355 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 118
356 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 116
357 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 115
358 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 115
359 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 113
360 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 113
361 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 114
362 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 113
363 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 113
364 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 113
365 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 114
366 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 114
367 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 113
368 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 113
369 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 113
370 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 113
371 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 114
372 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 113
373 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 113
374 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 114
375 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 113
376 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 113
377 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 113
378 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 113
379 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 113
380 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 113
381 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 114
382 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 113
383 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 113
384 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 113
385 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 113
386 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 113
387 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 113
388 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 113
389 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 113
390 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 113
391 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 113
392 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 113
393 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 113
394 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 113
395 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 113
396 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 113
397 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 113
398 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 113
399 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 113
400 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 113
401 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 113
402 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 113
403 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 113
404 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 113
405 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 114
406 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 113
407 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 113
408 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 113
409 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 113
410 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 113
411 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 113
412 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 113
413 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 113
414 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 113
415 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 113
416 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 112
417 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 113
418 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 113
419 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 113
420 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 113
421 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 113
422 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 113
423 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 113
424 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 113
425 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 113
426 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 113
427 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 113
428 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 113
429drop table cumulative_clones;000
430commit004
431begin000
432create 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;26688048
433 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 113
434 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 112
435 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 113
436 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 113
437 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 112
438 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 112
439 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 112
440 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 112
441 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 113
442 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 112
443 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 113
444 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
445 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 115
446 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 1112
447 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 117
448 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 112
449 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 115
450 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 117
451 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 114
452 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 115
453 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 115
454 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 116
455 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 119
456 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 119
457 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 114
458 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 114
459 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 116
460 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 115
461 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 115
462 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 114
463 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 116
464 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 113
465 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 114
466 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 115
467 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 115
468 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 115
469 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 114
470 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 116
471 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
472 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 113
473 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 113
474 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 113
475 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 113
476 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 113
477 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 113
478 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 114
479 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 113
480 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 112
481 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 112
482 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 112
483 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 112
484 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 112
485 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 113
486 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 113
487 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 113
488 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 113
489 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 113
490 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 113
491 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 113
492 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 112
493 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 112
494 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 112
495 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 112
496 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 112
497 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 112
498 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 112
499 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 116
500 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 113
501 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 112
502 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 112
503 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 112
504 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
505 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 118
506 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 113
507 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 113
508 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 113
509 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 113
510 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 112
511 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 112
512 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 112
513 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 112
514 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 112
515 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 112
516 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 112
517 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 112
518 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 112
519 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 112
520 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 112
521 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 112
522 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 112
523 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 113
524 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 113
525 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 113
526 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 113
527 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 113
528 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 113
529 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 113
530 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 113
531 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 112
532 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 112
533 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 113
534 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 112
535 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 112
536 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 112
537 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 112
538 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 112
539 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 112
540 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 112
541drop table cumulative_clones_success;000
542commit004
543begin000
544create 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;8576079
545 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 112
546 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 111
547 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 111
548 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 111
549 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 111
550 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 111
551 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 111
552 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 111
553 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 111
554 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 111
555 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 111
556 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 111
557 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 111
558 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 111
559 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 111
560 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 111
561 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 111
562 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 111
563 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 111
564 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 111
565 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 111
566 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 111
567 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 112
568 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 111
569 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 112
570 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 111
571 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 111
572 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 112
573 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 112
574 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 111
575 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 112
576 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 111
577 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 111
578 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 111
579 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 111
580 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 112
581 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 111
582 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 112
583 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 111
584 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 111
585 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 111
586 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 111
587 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 111
588 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 111
589 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 111
590 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 111
591 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 111
592 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 111
593 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 111
594 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 111
595 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 111
596 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 111
597 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 111
598 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 111
599 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 111
600 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 111
601 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 111
602 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 111
603 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 111
604 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 111
605 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 111
606 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 111
607 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 111
608 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 111
609 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 111
610 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 111
611 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 111
612 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 111
613 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 111
614 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 111
615 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 111
616 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 111
617 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 111
618 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 111
619 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 111
620 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 111
621 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 111
622 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 111
623 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 111
624 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 111
625 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 111
626 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 111
627 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 111
628 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 111
629 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 111
630 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 111
631 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 111
632 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 111
633 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 111
634 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 111
635 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 111
636 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 111
637 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 111
638 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 111
639 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 111
640 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 111
641 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 111
642 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 111
643 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 111
644 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 111
645 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 111
646 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 111
647 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 111
648 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 111
649 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 111
650 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 111
651 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 111
652 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 111
653drop table cumulative_clones_express;000
654commit004
655begin000
656create 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;7923076
657 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 112
658 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
659 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 111
660 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
661 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 111
662 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 111
663 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
664 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 111
665 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 111
666 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 111
667 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 111
668 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 111
669 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 111
670 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 111
671 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 111
672 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 111
673 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 111
674 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 111
675 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 111
676 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 111
677 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 111
678 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 111
679 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 112
680 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 111
681 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01' group by target_id) as a 111
682 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01' group by target_id) as a 111
683 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2012-12-01' and experiment_date >= '2012-11-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 < '2013-01-01' and experiment_date >= '2012-12-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 < '2013-02-01' and experiment_date >= '2013-01-01' group by target_id) as a 113
686 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01' group by target_id) as a 111
687 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-04-01' and experiment_date >= '2013-03-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 < '2013-05-01' and experiment_date >= '2013-04-01' group by target_id) as a 111
689 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01' group by target_id) as a 111
690 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01' group by target_id) as a 111
691 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01' group by target_id) as a 111
692 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-09-01' and experiment_date >= '2013-08-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 < '2013-10-01' and experiment_date >= '2013-09-01' group by target_id) as a 111
694 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01' group by target_id) as a 111
695 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01' group by target_id) as a 111
696 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01' group by target_id) as a 111
697 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01' group by target_id) as a 111
698 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01' group by target_id) as a 111
699 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01' group by target_id) as a 111
700 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_soluble where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01' group by target_id) as a 111
(labdb) 2 queries took 3 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';2932933
2SELECT matviewname as name FROM pg_matviews;000
(psipubs) 12 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32326
2SELECT matviewname as name FROM pg_matviews;001
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
4SELECT matviewname as name FROM pg_matviews;000
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
6SELECT matviewname as name FROM pg_matviews;000
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
8SELECT matviewname as name FROM pg_matviews;000
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
10SELECT matviewname as name FROM pg_matviews;000
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
12SELECT matviewname as name FROM pg_matviews;000