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