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