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

PSI: Biology Pipeline - Cumulative Growth

Export data as: CSV, TSV, XLS
Approved targetsWork stoppedCloning trialsSuccessful clonesExpressing clonesSoluble expressing clonesPurification attemptsSuccessful purificationsIn crystallization trialsCrystal harvestedDatasets collectedStructures deposited in PDB
Sep 201000285/479285/475312/324311/32222/2822/256/12263/32/20/0
Oct 2010290096/9696/9633/3332/3294/9994/9930/86468/93/31/1
Nov 201012350365/559361/555117/14194/10972/7570/7321/347614/7314/282/2
Dec 201074160463/734462/7038/81/124/2917/195/9602/74/84/4
Jan 201146009/109/1082/8579/7915/1515/1513/27546/92/31/1
Feb 2011261036/5036/5049/5749/5766/6964/6718/41266/94/40/0
Mar 20113610176/296128/2079/129/1227/4727/4744/1520718/11010/5111/15
Apr 201157064/6453/5368/8730/4024/3724/3713/63969/164/411/11
May 201100167/259106/13223/2324/2433/3433/3416/55802/21/11/1
Jun 20117750142/201106/12679/8078/7957/7257/7133/139525/510/101/1
Jul 2011170187/392162/32690/21290/21158/7658/7548/1560116/1107/767/7
Aug 201130692/740687/722133/136132/13586/10786/10733/264961/15/57/7
Sep 201130780430/492345/365177/218161/20287/9687/9663/292588/106/73/3
Oct 201100943/945939/941236/259238/261121/133120/13265/1955119/4113/149/9
Nov 2011001083/10901078/1085314/315314/315131/154123/14667/2961615/2716/209/9
Dec 2011884099/9999/99130/130127/127133/144127/13752/2806219/368/812/12
Jan 20121040901/1129874/95461/6165/65175/198173/195107/4473616/302/26/6
Feb 2012330701687/16901677/1680218/220215/217145/202113/15687/3268828/5522/2816/16
Mar 20127420584/584584/584213/215206/208177/190101/10981/3514516/3217/1813/13
Apr 20123801159/16491065/1463294/313290/308145/160145/160124/5000418/355/56/8
May 201240410781/1031781/1031204/208162/16675/7775/77137/545583/160/07/12
Jun 201200671/862536/665200/202179/181102/111102/11155/2164817/3212/233/3
Jul 2012166401383/19781318/1734426/437429/440121/130121/13035/1113614/378/95/5
Aug 2012320201353/20441351/1947221/263213/23359/6959/6943/119764/71/14/4
Sep 20126560585/1201506/966425/465205/22285/9685/9670/2356817/244/46/7
Oct 20122760612/1235598/104071/7858/63124/136124/13676/2753816/286/68/8
Nov 201247073751149/19351148/1841137/153141/15888/10488/10459/1898118/1709/556/6
Dec 20121780963/963954/954371/404361/378152/165152/16525/73928/150/01/1
Jan 201300851/1135789/974674/715679/723107/138107/138141/486726/81/14/4
Feb 20131040714/845639/727178/178178/17852/6351/62100/3157919/749/910/11
Mar 201314401226/15341141/1371338/368336/366144/154143/15378/3392429/37614/17317/20
Apr 20131220355/440310/39247/6147/61134/153134/15387/3006720/7413/426/18
May 2013940693/777534/584109/138109/138161/171161/171130/741609/262/43/3
Jun 201383001090/2053760/1492241/334241/334108/120108/120127/5609122/30514/632/5
Jul 201356301386/1666976/1256232/232231/231110/138110/13867/3344410/455/603/3
Aug 201358501082/1930836/1633497/500486/48885/9385/9371/221135/90/01/1
Sep 2013250545/862455/748253/256253/25661/6361/6389/254558/164/61/1
Oct 201310478/786345/591386/386261/26126/2926/2982/357695/446/135/5
Nov 20133840108/131104/1127/86/735/5135/5124/887433/21816/580/0
Dec 20131500/00/0167/167108/10833/3433/3414/46085/414/200/0
Jan 201400248/248224/2240/00/026/2726/2765/327360/01/14/4
Feb 20140015/1515/15250/251248/24930/3730/3719/72965/201/10/0
Mar 2014200/00/050/5051/5110/1110/1136/1487423/13710/560/0
Apr 20144480128/128104/1041/11/137/3937/3921/96002/41/10/0
May 201400127/12794/940/00/015/2215/2122/67208/140/01/1
Jun 20143830378/438364/420110/118110/11872/8472/8412/126570/00/00/0
Jul 2014000/00/00/00/07/77/729/1819817/55213/2161/1
Aug 2014300/00/01/11/13/33/33/2883/341/10/0
Sep 2014000/00/00/00/01/11/11/5761/11/16/6
Oct 2014000/00/00/00/05/75/721/132846/381/10/0
Nov 2014000/00/00/00/01/21/26/822320/37616/830/0
Dec 2014000/00/00/00/00/00/00/02/342/133/3
Jan 2015000/00/00/00/01/11/11/2780/02/31/1
Feb 20150094/9483/830/00/01/11/110/58560/02/30/0
Mar 2015000/00/00/00/03/33/37/68641/10/02/2
Apr 2015000/00/00/00/01/11/15/397817/4008/1210/0
May 2015000/00/00/00/00/00/00/00/00/03/3
Jun 2015000/00/00/00/02/22/20/00/01/13/3
Jul 2015000/00/00/00/01/11/10/00/01/10/0
Aug 2015000/00/00/00/00/00/00/00/00/00/0
Sep 2015000/00/00/00/00/00/07/73620/01/11/1
Oct 2015000/00/00/00/00/00/09/57559/1996/380/0
Nov 2015000/00/00/00/00/00/00/01/11/11/1
Dec 2015000/00/00/00/01/11/10/00/00/00/0
Jan 2016000/00/00/00/00/00/00/00/00/00/0
Feb 2016000/00/00/00/00/00/00/00/01/10/0
Mar 2016000/00/00/00/00/00/01/26100/00/02/2
Apr 2016000/00/00/00/01/11/12/32857/1292/130/0
May 2016000/00/00/00/00/00/00/00/00/00/0
Jun 2016000/00/00/00/00/00/00/00/00/00/0
Jul 2016000/00/00/00/00/00/00/00/00/00/0
Aug 2016000/00/00/00/01/11/10/00/00/00/0
Sep 2016000/00/00/00/02/62/61/2870/04/70/0
Oct 2016000/00/00/00/02/42/44/37690/00/00/0
Nov 2016000/00/00/00/00/00/03/20162/562/130/0
Dec 2016000/00/00/00/00/00/00/00/02/130/0
Jan 2017000/00/00/00/00/00/01/5760/01/20/0
Feb 2017000/00/00/00/00/00/02/21060/01/30/0
Mar 2017000/00/00/00/00/00/02/14401/52/40/0
Apr 2017000/00/00/00/02/22/20/00/01/30/0
May 2017000/00/00/00/00/00/00/00/01/10/0
Jun 2017000/00/00/00/00/00/00/00/00/00/0
Jul 2017000/00/00/00/00/00/00/00/00/00/0
Aug 2017000/00/00/00/00/00/00/00/00/00/0
Sep 2017000/00/00/00/00/00/01/2880/00/00/0
Oct 2017000/00/00/00/00/00/00/00/01/40/0
Nov 2017000/00/00/00/00/00/00/00/00/00/0
Dec 2017000/00/00/00/00/00/00/00/00/00/0
Jan 2018000/00/00/00/00/00/00/00/00/00/0
Feb 2018000/00/00/00/01/11/12/14400/00/00/0
Mar 2018000/00/00/00/00/00/03/11673/71/10/0
Apr 2018000/00/00/00/00/00/01/153/542/70/0
May 2018000/00/00/00/00/00/00/00/00/00/0
Jun 2018000/00/00/00/00/00/00/00/00/00/0
Jul 2018000/00/00/00/00/00/00/00/00/00/0
Aug 2018000/00/00/00/00/00/00/00/00/00/0
Sep 2018000/00/00/00/00/00/00/00/00/00/0
Oct 2018000/00/00/00/00/00/00/00/00/00/0
Nov 2018000/00/00/00/00/00/00/00/00/00/0
Dec 2018000/00/00/00/00/00/00/00/00/00/0
Jan 2019000/00/00/00/00/00/00/00/00/00/0
Feb 2019000/00/00/00/00/00/00/00/00/00/0
Mar 2019000/00/00/00/00/00/00/00/00/00/0
Apr 2019000/00/00/00/00/00/00/00/00/00/0
May 2019000/00/00/00/00/00/00/00/00/00/0
Jun 2019000/00/00/00/00/00/00/00/00/00/0
Jul 2019000/00/00/00/00/00/00/00/00/00/0
Aug 2019000/00/00/00/00/00/00/00/00/00/0
Sep 2019000/00/00/00/00/00/00/00/00/00/0
Oct 2019000/00/00/00/00/00/00/00/00/00/0
Nov 2019000/00/00/00/00/00/00/00/00/00/0
Dec 2019000/00/00/00/00/00/00/00/00/00/0
Jan 2020000/00/00/00/00/00/00/00/00/00/0
Feb 2020000/00/00/00/00/00/00/00/00/00/0
Mar 2020000/00/00/00/00/00/00/00/00/00/0
Apr 2020000/00/00/00/00/00/00/00/00/00/0
May 2020000/00/00/00/00/00/00/00/00/00/0
Jun 2020000/00/00/00/00/00/00/00/00/00/0
Jul 2020000/00/00/00/00/00/00/00/00/00/0
Aug 2020000/00/00/00/00/00/00/00/00/00/0
Sep 2020000/00/00/00/00/00/00/00/00/00/0
Oct 2020000/00/00/00/00/00/00/00/00/00/0
Nov 2020000/00/00/00/00/00/00/00/00/00/0
Dec 2020000/00/00/00/00/00/00/00/00/00/0
Jan 2021000/00/00/00/00/00/00/00/00/00/0
Feb 2021000/00/00/00/00/00/00/00/00/00/0
Mar 2021000/00/00/00/00/00/00/00/00/00/0
Apr 2021000/00/00/00/00/00/00/00/00/00/0
May 2021000/00/00/00/00/00/00/00/00/00/0
Jun 2021000/00/00/00/00/00/00/00/00/00/0
Jul 2021000/00/00/00/00/00/00/00/00/00/0
Aug 2021000/00/00/00/00/00/00/00/00/00/0
Sep 2021000/00/00/00/00/00/00/00/00/00/0
Oct 2021000/00/00/00/00/00/00/00/00/00/0
Nov 2021000/00/00/00/00/00/00/00/00/00/0
Dec 2021000/00/00/00/00/00/00/00/00/00/0
Jan 2022000/00/00/00/00/00/00/00/00/00/0
Feb 2022000/00/00/00/00/00/00/00/00/00/0
Mar 2022000/00/00/00/00/00/00/00/00/00/0
Apr 2022000/00/00/00/00/00/00/00/00/00/0
May 2022000/00/00/00/00/00/00/00/00/00/0
Jun 2022000/00/00/00/00/00/00/00/00/00/0
Jul 2022000/00/00/00/00/00/00/00/00/00/0
Aug 2022000/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) 1870 queries took 4737 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091098
2SELECT matviewname as name FROM pg_matviews;000
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
4SELECT matviewname as name FROM pg_matviews;000
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
6SELECT matviewname as name FROM pg_matviews;000
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
8SELECT matviewname as name FROM pg_matviews;000
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
10SELECT matviewname as name FROM pg_matviews;000
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
12SELECT matviewname as name FROM pg_matviews;000
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
14SELECT matviewname as name FROM pg_matviews;000
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
16SELECT matviewname as name FROM pg_matviews;000
17SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
18SELECT matviewname as name FROM pg_matviews;000
19SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
20SELECT matviewname as name FROM pg_matviews;000
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
22SELECT matviewname as name FROM pg_matviews;000
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
24SELECT matviewname as name FROM pg_matviews;000
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
26SELECT matviewname as name FROM pg_matviews;000
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';1091092
28SELECT matviewname as name FROM pg_matviews;000
29SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
30SELECT matviewname as name FROM pg_matviews;000
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
32SELECT matviewname as name FROM pg_matviews;000
33SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
34SELECT matviewname as name FROM pg_matviews;000
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
36SELECT matviewname as name FROM pg_matviews;000
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
38SELECT matviewname as name FROM pg_matviews;000
39SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
40SELECT matviewname as name FROM pg_matviews;000
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';1091092
42SELECT matviewname as name FROM pg_matviews;000
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
44SELECT matviewname as name FROM pg_matviews;000
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';1091092
46SELECT matviewname as name FROM pg_matviews;000
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
48SELECT matviewname as name FROM pg_matviews;000
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
50SELECT matviewname as name FROM pg_matviews;000
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
52SELECT matviewname as name FROM pg_matviews;000
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
54SELECT matviewname as name FROM pg_matviews;000
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
56SELECT matviewname as name FROM pg_matviews;000
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
58SELECT matviewname as name FROM pg_matviews;000
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
60SELECT matviewname as name FROM pg_matviews;000
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
62SELECT matviewname as name FROM pg_matviews;000
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
64SELECT matviewname as name FROM pg_matviews;000
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
66SELECT matviewname as name FROM pg_matviews;000
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
68SELECT matviewname as name FROM pg_matviews;000
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
70SELECT matviewname as name FROM pg_matviews;000
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
72SELECT matviewname as name FROM pg_matviews;000
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
74SELECT matviewname as name FROM pg_matviews;000
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
76SELECT matviewname as name FROM pg_matviews;000
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
78SELECT matviewname as name FROM pg_matviews;000
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
80SELECT matviewname as name FROM pg_matviews;000
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
82SELECT matviewname as name FROM pg_matviews;000
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
84SELECT matviewname as name FROM pg_matviews;000
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
86SELECT matviewname as name FROM pg_matviews;000
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
88SELECT matviewname as name FROM pg_matviews;000
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
90SELECT matviewname as name FROM pg_matviews;000
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
92SELECT matviewname as name FROM pg_matviews;000
93SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
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 1000
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) ;33218029
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 113
98 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01' group by target_id) as a 113
99 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01' group by target_id) as a 116
100 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01' group by target_id) as a 1128
101 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01' group by target_id) as a 114
102 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01' group by target_id) as a 113
103 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01' group by target_id) as a 114
104 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01' group by target_id) as a 113
105 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01' group by target_id) as a 113
106 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01' group by target_id) as a 115
107 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01' group by target_id) as a 113
108 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01' group by target_id) as a 113
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 1112
110 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-11-01' and experiment_date >= '2011-10-01' group by target_id) as a 113
111 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01' group by target_id) as a 113
112 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01' group by target_id) as a 115
113 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01' group by target_id) as a 113
114 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01' group by target_id) as a 1113
115 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01' group by target_id) as a 115
116 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01' group by target_id) as a 113
117 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01' group by target_id) as a 1115
118 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-07-01' and experiment_date >= '2012-06-01' group by target_id) as a 113
119 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-08-01' and experiment_date >= '2012-07-01' group by target_id) as a 118
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 1113
121 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01' group by target_id) as a 115
122 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01' group by target_id) as a 113
123 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01' group by target_id) as a 114
124 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01' group by target_id) as a 113
125 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01' group by target_id) as a 113
126 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01' group by target_id) as a 113
127 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01' group by target_id) as a 113
128 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01' group by target_id) as a 113
129 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01' group by target_id) as a 113
130 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01' group by target_id) as a 115
131 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01' group by target_id) as a 114
132 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01' group by target_id) as a 115
133 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01' group by target_id) as a 113
134 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-11-01' and experiment_date >= '2013-10-01' group by target_id) as a 113
135 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01' group by target_id) as a 114
136 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01' group by target_id) as a 113
137 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01' group by target_id) as a 113
138 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01' group by target_id) as a 113
139 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01' group by target_id) as a 113
140 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01' group by target_id) as a 114
141 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-06-01' and experiment_date >= '2014-05-01' group by target_id) as a 113
142 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01' group by target_id) as a 114
143 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01' group by target_id) as a 113
144 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01' group by target_id) as a 113
145 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01' group by target_id) as a 113
146 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01' group by target_id) as a 113
147 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01' group by target_id) as a 113
148 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01' group by target_id) as a 113
149 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01' group by target_id) as a 113
150 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01' group by target_id) as a 113
151 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01' group by target_id) as a 113
152 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01' group by target_id) as a 113
153 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01' group by target_id) as a 113
154 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01' group by target_id) as a 113
155 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01' group by target_id) as a 113
156 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01' group by target_id) as a 113
157 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01' group by target_id) as a 113
158 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01' group by target_id) as a 113
159 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01' group by target_id) as a 113
160 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01' group by target_id) as a 113
161 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01' group by target_id) as a 113
162 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01' group by target_id) as a 113
163 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01' group by target_id) as a 113
164 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01' group by target_id) as a 113
165 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01' group by target_id) as a 113
166 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01' group by target_id) as a 113
167 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01' group by target_id) as a 113
168 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01' group by target_id) as a 113
169 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01' group by target_id) as a 113
170 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01' group by target_id) as a 113
171 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01' group by target_id) as a 113
172 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01' group by target_id) as a 113
173 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01' group by target_id) as a 113
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 113
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 113
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 113
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 113
178 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01' group by target_id) as a 113
179 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01' group by target_id) as a 113
180 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01' group by target_id) as a 113
181 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01' group by target_id) as a 113
182 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01' group by target_id) as a 113
183 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01' group by target_id) as a 113
184 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01' group by target_id) as a 113
185 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01' group by target_id) as a 113
186 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01' group by target_id) as a 113
187 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01' group by target_id) as a 113
188 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01' group by target_id) as a 113
189 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01' group by target_id) as a 113
190 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01' group by target_id) as a 113
191 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01' group by target_id) as a 113
192 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-09-01' and experiment_date >= '2018-08-01' group by target_id) as a 113
193 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01' group by target_id) as a 113
194 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01' group by target_id) as a 113
195 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01' group by target_id) as a 113
196 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01' group by target_id) as a 113
197 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01' group by target_id) as a 113
198 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01' group by target_id) as a 113
199 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01' group by target_id) as a 113
200 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01' group by target_id) as a 113
201 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01' group by target_id) as a 113
202 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01' group by target_id) as a 113
203 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01' group by target_id) as a 113
204 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01' group by target_id) as a 113
205 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01' group by target_id) as a 113
206 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01' group by target_id) as a 113
207 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01' group by target_id) as a 113
208 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01' group by target_id) as a 113
209 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01' group by target_id) as a 113
210 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01' group by target_id) as a 113
211 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01' group by target_id) as a 113
212 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01' group by target_id) as a 113
213 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01' group by target_id) as a 113
214 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01' group by target_id) as a 113
215 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01' group by target_id) as a 113
216 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01' group by target_id) as a 113
217 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01' group by target_id) as a 113
218 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01' group by target_id) as a 113
219 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01' group by target_id) as a 113
220 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01' group by target_id) as a 113
221 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01' group by target_id) as a 113
222 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01' group by target_id) as a 113
223 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01' group by target_id) as a 115
224 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01' group by target_id) as a 113
225 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01' group by target_id) as a 113
226 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01' group by target_id) as a 113
227 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01' group by target_id) as a 113
228 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01' group by target_id) as a 113
229 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01' group by target_id) as a 113
230 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01' group by target_id) as a 113
231 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01' group by target_id) as a 113
232 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01' group by target_id) as a 113
233 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01' group by target_id) as a 113
234 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01' group by target_id) as a 113
235 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01' group by target_id) as a 113
236 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01' group by target_id) as a 113
237 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01' group by target_id) as a 113
238 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01' group by target_id) as a 113
239 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01' group by target_id) as a 113
240 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01' group by target_id) as a 113
241drop table cumulative_targets;002
242commit001
243begin000
244create 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) ;7375015
245 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
246 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
247 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
248 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
249 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
250 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
251 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
252 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
253 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
254 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
255 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
256 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
257 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
258 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
259 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
260 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
261 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
262 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
263 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
264 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
265 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
266 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
267 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
268 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
269 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
270 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
271 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 1126
272 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01' group by target_id) as a 111
273 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
274 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
275 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
276 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
277 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
278 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
279 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
280 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
281 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
282 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
283 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
284 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
285 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
286 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
287 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
288 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
289 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
290 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
291 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
292 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
293 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
294 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
295 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
296 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
297 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
298 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
299 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
300 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
301 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
302 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
303 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
304 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
305 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
306 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
307 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
308 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
309 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
310 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
311 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
312 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
313 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
314 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
315 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
316 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
317 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
318 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
319 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
320 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
321 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01' group by target_id) as a 111
322 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01' group by target_id) as a 111
323 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
324 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
325 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
326 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
327 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
328 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
329 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
330 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
331 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
332 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
333 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
334 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
335 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
336 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
337 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
338 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
339 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
340 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
341 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
342 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
343 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
344 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
345 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
346 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
347 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
348 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01' group by target_id) as a 111
349 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01' group by target_id) as a 111
350 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01' group by target_id) as a 111
351 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01' group by target_id) as a 111
352 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01' group by target_id) as a 111
353 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01' group by target_id) as a 111
354 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01' group by target_id) as a 111
355 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01' group by target_id) as a 111
356 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01' group by target_id) as a 111
357 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01' group by target_id) as a 111
358 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01' group by target_id) as a 111
359 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01' group by target_id) as a 111
360 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01' group by target_id) as a 111
361 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01' group by target_id) as a 111
362 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01' group by target_id) as a 111
363 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01' group by target_id) as a 111
364 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01' group by target_id) as a 111
365 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01' group by target_id) as a 111
366 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01' group by target_id) as a 111
367 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01' group by target_id) as a 111
368 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01' group by target_id) as a 111
369 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01' group by target_id) as a 111
370 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01' group by target_id) as a 111
371 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01' group by target_id) as a 111
372 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01' group by target_id) as a 111
373 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01' group by target_id) as a 111
374 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01' group by target_id) as a 111
375 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01' group by target_id) as a 111
376 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01' group by target_id) as a 111
377 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-10-01' and experiment_date >= '2021-09-01' group by target_id) as a 111
378 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01' group by target_id) as a 111
379 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01' group by target_id) as a 111
380 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01' group by target_id) as a 111
381 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01' group by target_id) as a 111
382 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01' group by target_id) as a 111
383 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01' group by target_id) as a 111
384 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01' group by target_id) as a 111
385 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01' group by target_id) as a 111
386 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01' group by target_id) as a 111
387 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01' group by target_id) as a 111
388 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_targets_stopped where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01' group by target_id) as a 111
389drop table cumulative_targets_stopped;000
390commit001
391begin000
392create 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;29586044
393 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01' group by target_id) as a 114
394 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 112
395 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 113
396 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01' group by target_id) as a 114
397 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 112
398 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 112
399 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01' group by target_id) as a 113
400 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 112
401 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-06-01' and experiment_date >= '2011-05-01' group by target_id) as a 113
402 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01' group by target_id) as a 113
403 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01' group by target_id) as a 113
404 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 114
405 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 113
406 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 115
407 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2011-12-01' and experiment_date >= '2011-11-01' group by target_id) as a 116
408 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01' group by target_id) as a 113
409 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 115
410 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 118
411 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 114
412 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 116
413 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 115
414 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 114
415 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 117
416 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2012-09-01' and experiment_date >= '2012-08-01' group by target_id) as a 117
417 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01' group by target_id) as a 114
418 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01' group by target_id) as a 115
419 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01' group by target_id) as a 116
420 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01' group by target_id) as a 115
421 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01' group by target_id) as a 115
422 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01' group by target_id) as a 114
423 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 116
424 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01' group by target_id) as a 113
425 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 114
426 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-07-01' and experiment_date >= '2013-06-01' group by target_id) as a 116
427 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 117
428 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01' group by target_id) as a 116
429 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 114
430 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 114
431 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2013-12-01' and experiment_date >= '2013-11-01' group by target_id) as a 113
432 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-01-01' and experiment_date >= '2013-12-01' group by target_id) as a 113
433 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01' group by target_id) as a 114
434 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-03-01' and experiment_date >= '2014-02-01' group by target_id) as a 113
435 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-04-01' and experiment_date >= '2014-03-01' group by target_id) as a 113
436 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01' group by target_id) as a 113
437 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 113
438 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-07-01' and experiment_date >= '2014-06-01' group by target_id) as a 114
439 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-08-01' and experiment_date >= '2014-07-01' group by target_id) as a 113
440 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01' group by target_id) as a 113
441 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01' group by target_id) as a 113
442 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01' group by target_id) as a 113
443 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 113
444 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-01-01' and experiment_date >= '2014-12-01' group by target_id) as a 113
445 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-02-01' and experiment_date >= '2015-01-01' group by target_id) as a 113
446 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 113
447 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-04-01' and experiment_date >= '2015-03-01' group by target_id) as a 113
448 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-05-01' and experiment_date >= '2015-04-01' group by target_id) as a 113
449 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-06-01' and experiment_date >= '2015-05-01' group by target_id) as a 113
450 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-07-01' and experiment_date >= '2015-06-01' group by target_id) as a 113
451 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-08-01' and experiment_date >= '2015-07-01' group by target_id) as a 113
452 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01' group by target_id) as a 113
453 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 113
454 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01' group by target_id) as a 113
455 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01' group by target_id) as a 113
456 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01' group by target_id) as a 113
457 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01' group by target_id) as a 113
458 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01' group by target_id) as a 113
459 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-04-01' and experiment_date >= '2016-03-01' group by target_id) as a 113
460 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-05-01' and experiment_date >= '2016-04-01' group by target_id) as a 113
461 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01' group by target_id) as a 113
462 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01' group by target_id) as a 113
463 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01' group by target_id) as a 113
464 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-09-01' and experiment_date >= '2016-08-01' group by target_id) as a 113
465 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-10-01' and experiment_date >= '2016-09-01' group by target_id) as a 113
466 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-11-01' and experiment_date >= '2016-10-01' group by target_id) as a 113
467 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2016-12-01' and experiment_date >= '2016-11-01' group by target_id) as a 113
468 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-01-01' and experiment_date >= '2016-12-01' group by target_id) as a 113
469 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-02-01' and experiment_date >= '2017-01-01' group by target_id) as a 113
470 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01' group by target_id) as a 113
471 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01' group by target_id) as a 113
472 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01' group by target_id) as a 113
473 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01' group by target_id) as a 113
474 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01' group by target_id) as a 113
475 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01' group by target_id) as a 113
476 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01' group by target_id) as a 113
477 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 113
478 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01' group by target_id) as a 113
479 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01' group by target_id) as a 113
480 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01' group by target_id) as a 113
481 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01' group by target_id) as a 113
482 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01' group by target_id) as a 113
483 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-04-01' and experiment_date >= '2018-03-01' group by target_id) as a 113
484 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-05-01' and experiment_date >= '2018-04-01' group by target_id) as a 113
485 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-06-01' and experiment_date >= '2018-05-01' group by target_id) as a 113
486 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-07-01' and experiment_date >= '2018-06-01' group by target_id) as a 113
487 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-08-01' and experiment_date >= '2018-07-01' group by target_id) as a 113
488 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 113
489 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-10-01' and experiment_date >= '2018-09-01' group by target_id) as a 113
490 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-11-01' and experiment_date >= '2018-10-01' group by target_id) as a 113
491 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01' group by target_id) as a 113
492 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01' group by target_id) as a 113
493 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-02-01' and experiment_date >= '2019-01-01' group by target_id) as a 113
494 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01' group by target_id) as a 113
495 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01' group by target_id) as a 113
496 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01' group by target_id) as a 113
497 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01' group by target_id) as a 113
498 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01' group by target_id) as a 113
499 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01' group by target_id) as a 113
500 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01' group by target_id) as a 113
501 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01' group by target_id) as a 113
502 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01' group by target_id) as a 113
503 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01' group by target_id) as a 113
504 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01' group by target_id) as a 113
505 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01' group by target_id) as a 113
506 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01' group by target_id) as a 113
507 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01' group by target_id) as a 113
508 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01' group by target_id) as a 113
509 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01' group by target_id) as a 113
510 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01' group by target_id) as a 113
511 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01' group by target_id) as a 113
512 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01' group by target_id) as a 113
513 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01' group by target_id) as a 113
514 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01' group by target_id) as a 113
515 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01' group by target_id) as a 113
516 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01' group by target_id) as a 113
517 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01' group by target_id) as a 113
518 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01' group by target_id) as a 113
519 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01' group by target_id) as a 113
520 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-05-01' and experiment_date >= '2021-04-01' group by target_id) as a 113
521 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-06-01' and experiment_date >= '2021-05-01' group by target_id) as a 113
522 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01' group by target_id) as a 113
523 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-08-01' and experiment_date >= '2021-07-01' group by target_id) as a 113
524 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01' group by target_id) as a 113
525 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-10-01' and experiment_date >= '2021-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 where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01' group by target_id) as a 113
527 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01' group by target_id) as a 113
528 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01' group by target_id) as a 113
529 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-02-01' and experiment_date >= '2022-01-01' group by target_id) as a 113
530 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01' group by target_id) as a 113
531 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01' group by target_id) as a 113
532 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01' group by target_id) as a 113
533 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01' group by target_id) as a 113
534 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01' group by target_id) as a 113
535 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01' group by target_id) as a 113
536 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01' group by target_id) as a 113
537drop table cumulative_clones;000
538commit001
539begin000
540create 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;26688045
541 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01' group by target_id) as a 113
542 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2010-11-01' and experiment_date >= '2010-10-01' group by target_id) as a 112
543 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01' group by target_id) as a 113
544 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-01-01' and experiment_date >= '2010-12-01' group by target_id) as a 113
545 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01' group by target_id) as a 112
546 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-03-01' and experiment_date >= '2011-02-01' group by target_id) as a 112
547 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-04-01' and experiment_date >= '2011-03-01' group by target_id) as a 112
548 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-05-01' and experiment_date >= '2011-04-01' group by target_id) as a 112
549 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 112
550 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01' group by target_id) as a 112
551 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01' group by target_id) as a 113
552 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 114
553 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 113
554 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 115
555 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 115
556 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-01-01' and experiment_date >= '2011-12-01' group by target_id) as a 112
557 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-02-01' and experiment_date >= '2012-01-01' group by target_id) as a 115
558 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-03-01' and experiment_date >= '2012-02-01' group by target_id) as a 117
559 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-04-01' and experiment_date >= '2012-03-01' group by target_id) as a 114
560 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-05-01' and experiment_date >= '2012-04-01' group by target_id) as a 115
561 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-06-01' and experiment_date >= '2012-05-01' group by target_id) as a 115
562 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 114
563 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 116
564 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 117
565 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-10-01' and experiment_date >= '2012-09-01' group by target_id) as a 114
566 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-11-01' and experiment_date >= '2012-10-01' group by target_id) as a 114
567 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2012-12-01' and experiment_date >= '2012-11-01' group by target_id) as a 116
568 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-01-01' and experiment_date >= '2012-12-01' group by target_id) as a 115
569 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-02-01' and experiment_date >= '2013-01-01' group by target_id) as a 115
570 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-03-01' and experiment_date >= '2013-02-01' group by target_id) as a 114
571 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-04-01' and experiment_date >= '2013-03-01' group by target_id) as a 116
572 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-05-01' and experiment_date >= '2013-04-01' group by target_id) as a 113
573 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-06-01' and experiment_date >= '2013-05-01' group by target_id) as a 114
574 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 114
575 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-08-01' and experiment_date >= '2013-07-01' group by target_id) as a 115
576 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-09-01' and experiment_date >= '2013-08-01' group by target_id) as a 115
577 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2013-10-01' and experiment_date >= '2013-09-01' group by target_id) as a 114
578 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 113
579 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 113
580 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 112
581 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-02-01' and experiment_date >= '2014-01-01' group by target_id) as a 113
582 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 112
583 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 112
584 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-05-01' and experiment_date >= '2014-04-01' group by target_id) as a 113
585 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 112
586 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 113
587 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 112
588 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-09-01' and experiment_date >= '2014-08-01' group by target_id) as a 112
589 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-10-01' and experiment_date >= '2014-09-01' group by target_id) as a 112
590 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-11-01' and experiment_date >= '2014-10-01' group by target_id) as a 112
591 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2014-12-01' and experiment_date >= '2014-11-01' group by target_id) as a 112
592 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 113
593 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 112
594 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2015-03-01' and experiment_date >= '2015-02-01' group by target_id) as a 113
595 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 112
596 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 112
597 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 112
598 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 112
599 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 112
600 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2015-09-01' and experiment_date >= '2015-08-01' group by target_id) as a 112
601 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2015-10-01' and experiment_date >= '2015-09-01' group by target_id) as a 112
602 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2015-11-01' and experiment_date >= '2015-10-01' group by target_id) as a 112
603 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2015-12-01' and experiment_date >= '2015-11-01' group by target_id) as a 112
604 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-01-01' and experiment_date >= '2015-12-01' group by target_id) as a 112
605 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-02-01' and experiment_date >= '2016-01-01' group by target_id) as a 112
606 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-03-01' and experiment_date >= '2016-02-01' group by target_id) as a 112
607 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 112
608 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 112
609 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-06-01' and experiment_date >= '2016-05-01' group by target_id) as a 112
610 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-07-01' and experiment_date >= '2016-06-01' group by target_id) as a 112
611 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2016-08-01' and experiment_date >= '2016-07-01' group by target_id) as a 112
612 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 112
613 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 112
614 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 112
615 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 112
616 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 112
617 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 112
618 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-03-01' and experiment_date >= '2017-02-01' group by target_id) as a 112
619 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-04-01' and experiment_date >= '2017-03-01' group by target_id) as a 112
620 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-05-01' and experiment_date >= '2017-04-01' group by target_id) as a 112
621 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-06-01' and experiment_date >= '2017-05-01' group by target_id) as a 112
622 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-07-01' and experiment_date >= '2017-06-01' group by target_id) as a 112
623 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-08-01' and experiment_date >= '2017-07-01' group by target_id) as a 112
624 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-09-01' and experiment_date >= '2017-08-01' group by target_id) as a 112
625 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-10-01' and experiment_date >= '2017-09-01' group by target_id) as a 112
626 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-11-01' and experiment_date >= '2017-10-01' group by target_id) as a 112
627 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2017-12-01' and experiment_date >= '2017-11-01' group by target_id) as a 112
628 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2018-01-01' and experiment_date >= '2017-12-01' group by target_id) as a 112
629 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2018-02-01' and experiment_date >= '2018-01-01' group by target_id) as a 112
630 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2018-03-01' and experiment_date >= '2018-02-01' group by target_id) as a 112
631 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 112
632 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 112
633 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 112
634 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 112
635 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 112
636 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 112
637 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 112
638 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 112
639 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2018-12-01' and experiment_date >= '2018-11-01' group by target_id) as a 112
640 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-01-01' and experiment_date >= '2018-12-01' group by target_id) as a 112
641 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 112
642 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-03-01' and experiment_date >= '2019-02-01' group by target_id) as a 112
643 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-04-01' and experiment_date >= '2019-03-01' group by target_id) as a 112
644 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-05-01' and experiment_date >= '2019-04-01' group by target_id) as a 112
645 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-06-01' and experiment_date >= '2019-05-01' group by target_id) as a 112
646 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-07-01' and experiment_date >= '2019-06-01' group by target_id) as a 112
647 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-08-01' and experiment_date >= '2019-07-01' group by target_id) as a 112
648 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-09-01' and experiment_date >= '2019-08-01' group by target_id) as a 112
649 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-10-01' and experiment_date >= '2019-09-01' group by target_id) as a 112
650 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-11-01' and experiment_date >= '2019-10-01' group by target_id) as a 112
651 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2019-12-01' and experiment_date >= '2019-11-01' group by target_id) as a 112
652 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-01-01' and experiment_date >= '2019-12-01' group by target_id) as a 112
653 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-02-01' and experiment_date >= '2020-01-01' group by target_id) as a 112
654 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-03-01' and experiment_date >= '2020-02-01' group by target_id) as a 112
655 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-04-01' and experiment_date >= '2020-03-01' group by target_id) as a 112
656 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-05-01' and experiment_date >= '2020-04-01' group by target_id) as a 112
657 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-06-01' and experiment_date >= '2020-05-01' group by target_id) as a 112
658 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-07-01' and experiment_date >= '2020-06-01' group by target_id) as a 112
659 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-08-01' and experiment_date >= '2020-07-01' group by target_id) as a 112
660 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-09-01' and experiment_date >= '2020-08-01' group by target_id) as a 112
661 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-10-01' and experiment_date >= '2020-09-01' group by target_id) as a 112
662 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-11-01' and experiment_date >= '2020-10-01' group by target_id) as a 112
663 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2020-12-01' and experiment_date >= '2020-11-01' group by target_id) as a 112
664 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-01-01' and experiment_date >= '2020-12-01' group by target_id) as a 112
665 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-02-01' and experiment_date >= '2021-01-01' group by target_id) as a 112
666 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-03-01' and experiment_date >= '2021-02-01' group by target_id) as a 112
667 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-04-01' and experiment_date >= '2021-03-01' group by target_id) as a 112
668 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-05-01' and experiment_date >= '2021-04-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_success where experiment_date < '2021-06-01' and experiment_date >= '2021-05-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_success where experiment_date < '2021-07-01' and experiment_date >= '2021-06-01' group by target_id) as a 112
671 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-08-01' and experiment_date >= '2021-07-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_success where experiment_date < '2021-09-01' and experiment_date >= '2021-08-01' group by target_id) as a 112
673 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-10-01' and experiment_date >= '2021-09-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_success where experiment_date < '2021-11-01' and experiment_date >= '2021-10-01' group by target_id) as a 112
675 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2021-12-01' and experiment_date >= '2021-11-01' group by target_id) as a 112
676 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-01-01' and experiment_date >= '2021-12-01' group by target_id) as a 112
677 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-02-01' and experiment_date >= '2022-01-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_success where experiment_date < '2022-03-01' and experiment_date >= '2022-02-01' group by target_id) as a 112
679 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-04-01' and experiment_date >= '2022-03-01' group by target_id) as a 112
680 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-05-01' and experiment_date >= '2022-04-01' group by target_id) as a 112
681 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-06-01' and experiment_date >= '2022-05-01' group by target_id) as a 112
682 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-07-01' and experiment_date >= '2022-06-01' group by target_id) as a 112
683 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-08-01' and experiment_date >= '2022-07-01' group by target_id) as a 112
684 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_success where experiment_date < '2022-09-01' and experiment_date >= '2022-08-01' group by target_id) as a 112
685drop table cumulative_clones_success;000
686commit001
687begin000
688create 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;8576077
689 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2010-10-01' and experiment_date >= '2010-09-01' group by target_id) as a 112
690 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
691 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2010-12-01' and experiment_date >= '2010-11-01' group by target_id) as a 111
692 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
693 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2011-02-01' and experiment_date >= '2011-01-01' group by target_id) as a 111
694 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
695 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
696 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
697 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
698 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2011-07-01' and experiment_date >= '2011-06-01' group by target_id) as a 111
699 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2011-08-01' and experiment_date >= '2011-07-01' group by target_id) as a 111
700 select count(target_id), sum(count) from (select target_id, sum(count) as count from cumulative_clones_express where experiment_date < '2011-09-01' and experiment_date >= '2011-08-01' group by target_id) as a 111
(labdb) 2 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932934
2SELECT matviewname as name FROM pg_matviews;000
(psipubs) 12 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32324
2SELECT matviewname as name FROM pg_matviews;000
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
4SELECT matviewname as name FROM pg_matviews;000
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
6SELECT matviewname as name FROM pg_matviews;000
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
8SELECT matviewname as name FROM pg_matviews;000
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
10SELECT matviewname as name FROM pg_matviews;000
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
12SELECT matviewname as name FROM pg_matviews;000