sql>trace select r.runcatid, f.band, f.datapoints, f.avg_f_peak, f.avg_weight_f_peak
more>  from runningcatalog_fluxes f,
more>       temp_associations ta,
more>       runningcatalog r
more> where ta.kind = 3
more>   and ta.runcat_id = f.runcat_id
more>   and r.first_xtrsrc_id = ta.xtrsrc_id
more>   and ta.xtrsrc_id not in (select tx.min_id
more>                              from (select tb.runcat_id, min(tb.xtrsrc_id) as min_id
more>                                      from temp_associations tb
more>                                     where tb.kind = 3
more>                                  group by tb.runcat_id) tx);
+-------+------------------------------------------------------------------------------------------------------------------+
| ticks | stmt                                                                                                             |
+=======+==================================================================================================================+
|     6 | X_115:bat[:oid,:int]  := nil:bat[:oid,:int];                                                                     |
|     3 | X_131:bat[:oid,:int]  := nil:bat[:oid,:int];                                                                     |
|     2 | X_139:bat[:oid,:int]  := nil:bat[:oid,:int];                                                                     |
|     1 | X_152:bat[:oid,:dbl]  := nil:bat[:oid,:dbl];                                                                     |
|     1 | X_160:bat[:oid,:dbl]  := nil:bat[:oid,:dbl];                                                                     |
|     3 | X_4 := sql.mvc();                                                                                                |
|    10 | X_46:bat[:oid,:int] =<tmp_7626>[2] := sql.bind(X_4=0,"sys","temp_associations","kind",0);                        |
|    15 | X_48=<tmp_6612>[2] := algebra.uselect(X_46=<tmp_7626>:bat[:oid,:int][2],A0=3);                                   |
|     5 | X_89=<tmp_7427>[2] := algebra.uselect(X_46=nil:bat[:oid,:int],A1=3);                                             |
|     3 | X_141:bat[:oid,:dbl] =<tmp_6255>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_f_peak",1);             |
|    23 | X_154:bat[:oid,:dbl] =<tmp_6255>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_weight_f_peak",1);      |
|     3 | X_147:bat[:oid,:dbl] =<tmp_7524>[5] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_f_peak",0);             |
|     4 | X_133:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","datapoints",1);             |
|     4 | X_134:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","datapoints",2);             |
|     3 | X_135:bat[:oid,:int] =<tmp_7470>[5] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","datapoints",0);             |
|     7 | X_155:bat[:oid,:dbl] =<tmp_6254>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_weight_f_peak",2);      |
|     5 | X_117:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","band",1);                   |
|     3 | X_121:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","band",2);                   |
|     3 | X_123:bat[:oid,:int] =<tmp_7445>[5] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","band",0);                   |
|     4 | X_6:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","runningcatalog","runcatid",1);                        |
|     2 | X_10:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","runningcatalog","runcatid",2);                       |
|     9 | X_156:bat[:oid,:dbl] =<tmp_7167>[5] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_weight_f_peak",0);      |
|    11 | X_157=<tmp_7374>[5] := algebra.kdifference(X_156=nil:bat[:oid,:dbl],X_155=<tmp_6254>:bat[:oid,:dbl][0]);         |
|     5 | X_125=<tmp_5371>[5] := algebra.kdifference(X_123=nil:bat[:oid,:int],X_121=<tmp_6242>:bat[:oid,:int][0]);         |
|     3 | X_12:bat[:oid,:int] =<tmp_7245>[5] := sql.bind(X_4=0,"sys","runningcatalog","runcatid",0);                       |
|    10 | X_136=<tmp_7537>[5] := algebra.kdifference(X_135=nil:bat[:oid,:int],X_134=<tmp_6242>:bat[:oid,:int][0]);         |
|     2 | X_145:bat[:oid,:dbl] =<tmp_6254>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","avg_f_peak",2);             |
|    18 | X_149=<tmp_5371>[5] := algebra.kdifference(X_147=nil:bat[:oid,:dbl],X_145=<tmp_6254>:bat[:oid,:dbl][0]);         |
|     8 | X_137=<tmp_5361>[5] := algebra.kunion(X_136=nil,X_134=nil:bat[:oid,:int]);                                       |
|    13 | X_126=<tmp_7113>[5] := algebra.kunion(X_125=nil,X_121=nil:bat[:oid,:int]);                                       |
|    43 | X_138=<tmp_7537>[5] := algebra.kunion(X_137=nil,X_133=nil:bat[:oid,:int]);                                       |
|    10 | X_14=<tmp_7374>[5] := algebra.kdifference(X_12=nil:bat[:oid,:int],X_10=<tmp_6242>:bat[:oid,:int][0]);            |
|    25 | X_150=<tmp_7113>[5] := algebra.kunion(X_149=nil,X_145=nil:bat[:oid,:dbl]);                                       |
|     8 | X_127=<tmp_5361>[5] := algebra.kunion(X_126=nil,X_117=nil:bat[:oid,:int]);                                       |
|    14 | X_15=<tmp_7113>[5] := algebra.kunion(X_14=nil,X_10=nil:bat[:oid,:int]);                                          |
|     4 | X_18:bat[:oid,:oid] =<tmp_6245>[0] := sql.bind_dbat(X_4=0,"sys","runningcatalog",1);                             |
|    23 | X_151=<tmp_5371>[5] := algebra.kunion(X_150=nil,X_141=nil:bat[:oid,:dbl]);                                       |
|     6 | X_20:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","runningcatalog","first_xtrsrc_id",1);                |
|     3 | X_21:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","runningcatalog","first_xtrsrc_id",2);                |
|     4 | X_19=<tmpr_6245>[0] := bat.reverse(X_18=nil:bat[:oid,:oid]);                                                     |
|    14 | X_158=<tmp_6760>[5] := algebra.kunion(X_157=nil,X_155=nil:bat[:oid,:dbl]);                                       |
|    26 | X_16=<tmp_7374>[5] := algebra.kunion(X_15=nil,X_6=nil:bat[:oid,:int]);                                           |
|     3 | X_22:bat[:oid,:int] =<tmp_7514>[5] := sql.bind(X_4=0,"sys","runningcatalog","first_xtrsrc_id",0);                |
|     5 | X_29:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",1);                   |
|     3 | X_31:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",2);                   |
|     4 | X_56:bat[:oid,:oid] =<tmp_6245>[0] := sql.bind_dbat(X_4=0,"sys","runningcatalog_fluxes",1);                      |
|    24 | X_23=<tmp_6760>[5] := algebra.kdifference(X_22=nil:bat[:oid,:int],X_21=<tmp_6242>:bat[:oid,:int][0]);            |
|     4 | X_32:bat[:oid,:int] =<tmp_5324>[2] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",0);                   |
|     7 | X_34=<tmp_7750>[2] := algebra.kdifference(X_32=nil:bat[:oid,:int],X_31=<tmp_6242>:bat[:oid,:int][0]);            |
|     2 | X_59=<tmpr_6245>[0] := bat.reverse(X_56=nil:bat[:oid,:oid]);                                                     |
|     5 | X_60:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","runcat_id",1);               |
|    58 | X_159=<tmp_7113>[5] := algebra.kunion(X_158=nil,X_154=nil:bat[:oid,:dbl]);                                       |
|    32 | X_24=<tmp_7604>[5] := algebra.kunion(X_23=nil,X_21=nil:bat[:oid,:int]);                                          |
|   129 | X_35=<tmp_6760>[2] := algebra.kunion(X_34=nil,X_31=nil:bat[:oid,:int]);                                          |
|     3 | X_62:bat[:oid,:int] =<tmp_7623>[5] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","runcat_id",0);               |
|    17 | X_25=<tmp_7431>[5] := algebra.kunion(X_24=nil,X_20=nil:bat[:oid,:int]);                                          |
|     9 | X_26=<tmp_6760>[5] := algebra.kdifference(X_25=nil,X_19=nil);                                                    |
|     2 | X_27=<tmpr_6760>[5] := bat.reverse(X_26=nil);                                                                    |
|     3 | X_71:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","temp_associations","runcat_id",2);                   |
|     3 | X_73:bat[:oid,:int] =<tmp_6771>[2] := sql.bind(X_4=0,"sys","temp_associations","runcat_id",0);                   |
|     5 | X_75=<tmp_7431>[2] := algebra.kdifference(X_73=nil:bat[:oid,:int],X_71=<tmp_6242>:bat[:oid,:int][0]);            |
|     5 | X_68:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","temp_associations","runcat_id",1);                   |
|    12 | X_36=<tmp_7604>[2] := algebra.kunion(X_35=nil,X_29=nil:bat[:oid,:int]);                                          |
|     5 | X_61:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","runningcatalog_fluxes","runcat_id",2);               |
|     3 | X_38:bat[:oid,:oid] =<tmp_6245>[0] := sql.bind_dbat(X_4=0,"sys","temp_associations",1);                          |
|    25 | X_76=<tmp_7750>[2] := algebra.kunion(X_75=nil,X_71=nil:bat[:oid,:int]);                                          |
|     5 | X_41:bat[:oid,:int] =<tmp_6243>[0] := sql.bind(X_4=0,"sys","temp_associations","kind",1);                        |
|     6 | X_63=<tmp_7431>[5] := algebra.kdifference(X_62=nil:bat[:oid,:int],X_61=<tmp_6242>:bat[:oid,:int][0]);            |
|    28 | X_42=<tmp_7464>[0] := algebra.uselect(X_41=<tmp_6243>:bat[:oid,:int][0],A0=3);                                   |
|    24 | X_77=<tmp_7736>[2] := algebra.kunion(X_76=nil,X_68=nil:bat[:oid,:int]);                                          |
|     2 | X_40=<tmpr_6245>[0] := bat.reverse(X_38=nil:bat[:oid,:oid]);                                                     |
|     4 | X_43:bat[:oid,:int] =<tmp_6242>[0] := sql.bind(X_4=0,"sys","temp_associations","kind",2);                        |
|    22 | X_87=<tmp_7125>[0] := algebra.uselect(X_41=nil:bat[:oid,:int],A1=3);                                             |
|    18 | X_64=<tmp_7750>[5] := algebra.kunion(X_63=nil,X_61=nil:bat[:oid,:int]);                                          |
|    34 | X_45=<tmp_7461>[0] := algebra.uselect(X_43=<tmp_6242>:bat[:oid,:int][0],A0=3);                                   |
|    15 | X_90=<tmp_7502>[2] := algebra.kdifference(X_89=nil,X_43=<tmp_6242>:bat[:oid,:int][0]);                           |
|    22 | X_65=<tmp_7753>[5] := algebra.kunion(X_64=nil,X_60=nil:bat[:oid,:int]);                                          |
|     8 | X_49=<tmp_7431>[2] := algebra.kdifference(X_48=nil,X_43=<tmp_6242>:bat[:oid,:int][0]);                           |
|    23 | X_66=<tmp_7750>[5] := algebra.kdifference(X_65=nil,X_59=nil);                                                    |
|    38 | X_88=<tmp_7450>[0] := algebra.uselect(X_43=nil:bat[:oid,:int],A1=3);                                             |
|     3 | X_67=<tmpr_7750>[5] := bat.reverse(X_66=nil);                                                                    |
|    34 | X_50=<tmp_7042>[2] := algebra.kunion(X_49=nil,X_45=nil);                                                         |
|    33 | X_91=<tmp_7461>[2] := algebra.kunion(X_90=nil,X_88=nil);                                                         |
|    34 | X_51=<tmp_7450>[2] := algebra.kunion(X_50=nil,X_42=nil);                                                         |
|    22 | X_92=<tmp_7464>[2] := algebra.kunion(X_91=nil,X_87=nil);                                                         |
|    19 | X_52=<tmp_7125>[2] := algebra.kdifference(X_51=nil,X_40=<tmpr_6245>[0]);                                         |
|     9 | X_93=<tmp_7450>[2] := algebra.kdifference(X_92=nil,X_40=nil);                                                    |
|    10 | X_53=<tmp_7464>[2] := algebra.markT(X_52=nil,0@0:oid);                                                           |
|    19 | X_94=<tmp_7125>[2] := algebra.markT(X_93=nil,0@0:oid);                                                           |
|     2 | X_54=<tmpr_7464>[2] := bat.reverse(X_53=nil);                                                                    |
|     3 | X_95=<tmpr_7125>[2] := bat.reverse(X_94=nil);                                                                    |
|    47 | X_78=<tmp_7461>[2] := algebra.leftjoin(X_54=<tmpr_7464>[2],X_77=<tmp_7736>[2]);                                  |
|    15 | X_79=<tmp_6700>[2] := algebra.join(X_78=nil,X_67=nil);                                                           |
|     5 | X_80=<tmp_7750>[2] := algebra.markT(X_79=<tmp_6700>[2],0@0:oid);                                                 |
|     3 | X_128=<tmpr_6700>[2] := bat.reverse(X_79=nil);                                                                   |
|     4 | X_81=<tmpr_7750>[2] := bat.reverse(X_80=nil);                                                                    |
|     4 | X_129=<tmp_7461>[2] := algebra.markT(X_128=nil,0@0:oid);                                                         |
|     2 | X_130=<tmpr_7461>[2] := bat.reverse(X_129=nil);                                                                  |
|    64 | X_82:bat[:oid,:int] =<tmp_7502>[2] := algebra.leftjoinPath(X_81=nil,X_54=nil,X_36=<tmp_7604>[2]);                |
|    15 | X_100=<tmp_7750>[2] := algebra.leftjoin(X_95=<tmpr_7125>[2],X_36=nil);                                           |
|    11 | X_83=<tmp_6715>[0] := algebra.join(X_82=<tmp_7502>:bat[:oid,:int][2],X_27=nil);                                  |
|    51 | X_96=<tmp_7604>[2] := algebra.leftjoin(X_95=nil,X_77=nil);                                                       |
|     6 | X_107=<tmp_7125>[0] := algebra.markT(X_83=<tmp_6715>[0],0@0:oid);                                                |
|    42 | (ext161=<tmp_7736>[1],grp159=<tmp_6574>[2]) := group.done(X_96=nil);                                             |
|     3 | X_84=<tmpr_6715>[0] := bat.reverse(X_83=nil);                                                                    |
|     4 | X_108=<tmpr_7125>[0] := bat.reverse(X_107=nil);                                                                  |
|    36 | X_99=<tmp_6666>[1] := bat.mirror(ext161=nil);                                                                    |
|     5 | X_85=<tmp_7736>[0] := algebra.markT(X_84=nil,0@0:oid);                                                           |
|    19 | X_109=<tmp_7162>[0] := algebra.leftjoin(X_108=<tmpr_7125>[0],X_82=nil:bat[:oid,:int]);                           |
|    37 | X_101:bat[:oid,:int] =<tmp_7502>[1] := aggr.min(X_100=nil,grp159=nil,X_99=nil);                                  |
|     2 | X_86=<tmpr_7736>[0] := bat.reverse(X_85=nil);                                                                    |
|    37 | (ext179=<tmp_7604>[1],grp177) := group.done(X_101=<tmp_7502>:bat[:oid,:int][1]);                                 |
|     8 | X_104=<tmp_7750>[1] := bat.mirror(ext179=nil);                                                                   |
|    15 | X_105=<tmp_7756>[1] := algebra.leftjoin(X_104=nil,X_101=nil:bat[:oid,:int]);                                     |
|     2 | X_106=<tmpr_7756>[1] := bat.reverse(X_105=nil);                                                                  |
|     7 | X_110=<tmp_7502>[0] := algebra.join(X_109=<tmp_7162>[0],X_106=nil);                                              |
|     5 | X_111=<tmp_7750>[0] := algebra.markT(X_110=nil,0@0:oid);                                                         |
|     5 | X_112=<tmp_7502>[0] := algebra.kdifference(X_109=nil,X_111=nil);                                                 |
|     6 | X_113=<tmp_7750>[0] := algebra.markT(X_112=nil,0@0:oid);                                                         |
|     2 | X_114=<tmpr_7750>[0] := bat.reverse(X_113=nil);                                                                  |
|    11 | X_115:bat[:oid,:int] =<tmp_7162>[0] := algebra.leftjoinPath(X_114=<tmpr_7750>[0],X_86=nil,X_16=nil);             |
|     7 | X_213=<tmp_6574>[0] := algebra.leftjoin(X_114=nil,X_108=nil);                                                    |
|     9 | X_131:bat[:oid,:int] =<tmp_7756>[0] := algebra.leftjoinPath(X_213=<tmp_6574>[0],X_130=<tmpr_7461>[2],X_127=nil); |
|    24 | X_139:bat[:oid,:int] =<tmp_7277>[0] := algebra.leftjoinPath(X_213=<tmp_6574>[0],X_130=<tmpr_7461>[2],X_138=nil); |
|    31 | X_152:bat[:oid,:dbl] =<tmp_6675>[0] := algebra.leftjoinPath(X_213=<tmp_6574>[0],X_130=<tmpr_7461>[2],X_151=nil); |
|    13 | X_160:bat[:oid,:dbl] =<tmp_7462>[0] := algebra.leftjoinPath(X_213=nil,X_130=nil,X_159=nil);                      |
|  5621 | barrier X_214 := language.dataflow();                                                                            |
|     6 | X_161 := sql.resultSet(5,1,X_115=<tmp_7162>:bat[:oid,:int][0]);                                                  |
|     5 | sql.rsColumn(X_161=6,"sys.r","runcatid","int",32,0,X_115=nil:bat[:oid,:int]);                                    |
|     4 | sql.rsColumn(X_161=6,"sys.f","band","int",32,0,X_131=nil:bat[:oid,:int]);                                        |
|     4 | sql.rsColumn(X_161=6,"sys.f","datapoints","int",32,0,X_139=nil:bat[:oid,:int]);                                  |
|     4 | sql.rsColumn(X_161=6,"sys.f","avg_f_peak","double",53,0,X_152=nil:bat[:oid,:dbl]);                               |
|     3 | sql.rsColumn(X_161=6,"sys.f","avg_weight_f_peak","double",53,0,X_160=nil:bat[:oid,:dbl]);                        |
|     2 | X_180 := io.stdout();                                                                                            |
|    26 | sql.exportResult(X_180=="7822720":streams,X_161=6);                                                              |
|    12 | end s6_1;                                                                                                        |
|    34 | function user.s6_1(A0=3,A1=3);                                                                                   |
| 11620 | X_5:void  := user.s6_1(3,3);                                                                                     |