============================================================================
USER COMMAND:
SELECT oc.PatientID, convert(oc.StartOfPeriod, date) AS periodstart, MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END) AS sofa_resp, MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END) AS sofa_cardio, MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END) AS sofa_liver, MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END) AS sofa_coag, MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END) AS sofa_cns, MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END) AS sofa_renal, MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END) AS sofa_total FROM #tmp_cohort10 AS c INNER JOIN oldcosara.oldcos_scores AS oc ON oc.PatientID = c.patientid GROUP BY oc.PatientID, convert(oc.StartOfPeriod, date) LIMIT 100

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT oc.PatientID, convert(oc.StartOfPeriod, date) AS periodstart, MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END) AS sofa_resp, MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END) AS sofa_cardio, MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END) AS sofa_liver, MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END) AS sofa_coag, MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END) AS sofa_cns, MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END) AS sofa_renal, MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END) AS sofa_total FROM #tmp_cohort10 AS c INNER JOIN oldcosara.oldcos_scores AS oc ON oc.PatientID = c.patientid GROUP BY oc.PatientID, convert(oc.StartOfPeriod, date) LIMIT 100

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT oc.PatientID, convert(oc.StartOfPeriod, date) AS periodstart, MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END) AS sofa_resp, MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END) AS sofa_cardio, MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END) AS sofa_liver, MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END) AS sofa_coag, MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END) AS sofa_cns, MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END) AS sofa_renal, MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END) AS sofa_total FROM #tmp_cohort10 AS c INNER JOIN oldcosara.oldcos_scores AS oc ON oc.PatientID = c.patientid GROUP BY oc.PatientID, convert(oc.StartOfPeriod, date) LIMIT 100

CANONICAL PLAN: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]})
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}})
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Source(groups=[#tmp_cohort10 AS c])
        Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING PlaceAccess

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]})
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}})
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__})
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278})
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING PushNonJoinCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=null})
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, OUTPUT_COLS=null})
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid], OUTPUT_COLS=null})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=null})
        Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null})
          Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid], OUTPUT_COLS=null})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null})
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null})
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING CopyCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid], OUTPUT_COLS=null, IS_COPIED=true})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=null})
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, OUTPUT_COLS=null})
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid], OUTPUT_COLS=null, IS_COPIED=true})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=null})
        Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null})
          Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PlanJoins

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, OUTPUT_COLS=null})
      Select(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID = c.patientid, EST_SELECTIVITY=0.037})
        Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
          Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
            Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=null, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
          Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
            Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null, EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PushSelectCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp0.gcol0=oc.PatientID, anon_grp0.gcol1=convert(oc.StartOfPeriod, date), anon_grp0.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp0.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp0.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp0.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp0.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp0.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp0.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, OUTPUT_COLS=null})
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING RaiseAccess

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING PlanOuterJoins

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[oc.PatientID = c.patientid]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING ChooseJoinStrategy

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[oc.PatientID = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[oc.PatientID], NON_EQUI_JOIN_CRITERIA=[]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING ChooseDependent

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, oldcosara.oldcos_scores AS oc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[oc.PatientID = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[oc.PatientID], NON_EQUI_JOIN_CRITERIA=[]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc])
          Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING PushAggregates

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=null})
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=null})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[]})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}})
            Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null, EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING ChooseDependent

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp1, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id2})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=null, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
        Select(groups=[anon_grp1], props={SELECT_CRITERIA=anon_grp1.gcol0 IN (<dependent values>), IS_DEPENDENT_SET=true})
          Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
            Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null, EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PushSelectCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp1, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id2})
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0})
            Select(groups=[oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null, EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=null})
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=null})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=null})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=null, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0, OUTPUT_COLS=null})
            Select(groups=[oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=null, EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING AssignOutputElements

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]})
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6]})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[c.patientid], EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=[c.patientid], EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]})
            Select(groups=[oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"]})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"], EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PushLimit

AFTER: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], SOURCE_HINT=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6]})
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6]})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1])
        Access(groups=[#tmp_cohort10 AS c])
          Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
            Select(groups=[oldcosara.oldcos_scores AS oc])
              Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING CalculateCost

AFTER: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], SOURCE_HINT=null, EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS PatientID=[100.0, 1.0], anon_grp0.gcol1 AS periodstart=[100.0, 1.0], anon_grp0.agg0 AS sofa_resp=[100.0, 1.0], anon_grp0.agg1 AS sofa_cardio=[100.0, 1.0], ...}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6], EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0=[100.0, 0.0], anon_grp0.gcol1=[100.0, 0.0], anon_grp0.agg0=[100.0, 0.0], anon_grp0.agg1=[100.0, 0.0], ...}})
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6], EST_CARDINALITY=-1.0})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[c.patientid], EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=[c.patientid], EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]})
            Select(groups=[oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"], EST_CARDINALITY=-1.0})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"], EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING ImplementJoinStrategy

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    Group(groups=[anon_grp1, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], IS_LEFT_DISTINCT=true, IS_SEMI_DEP=true, SORT_RIGHT=SORT})
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[c.patientid], EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}})
          Sort(groups=[], props={SORT_ORDER=ORDER BY c.patientid, OUTPUT_COLS=[c.patientid]})
            Source(groups=[#tmp_cohort10 AS c], props={OUTPUT_COLS=[c.patientid], EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=10.0})
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={GROUP_COLS=[oc.PatientID, convert(oc.StartOfPeriod, date)], SYMBOL_MAP={anon_grp1.gcol0=oc.PatientID, anon_grp1.gcol1=convert(oc.StartOfPeriod, date), anon_grp1.agg0=MAX(CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END), anon_grp1.agg1=MAX(CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END), anon_grp1.agg2=MAX(CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END), anon_grp1.agg3=MAX(CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END), anon_grp1.agg4=MAX(CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END), anon_grp1.agg5=MAX(CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END), anon_grp1.agg6=MAX(CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END)}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]})
            Select(groups=[oldcosara.oldcos_scores AS oc], props={SELECT_CRITERIA=oc.PatientID IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"], EST_CARDINALITY=-1.0})
              Source(groups=[oldcosara.oldcos_scores AS oc], props={OUTPUT_COLS=[oc.PatientID, oc.StartOfPeriod, oc.VariableID, oc."Value"], EST_COL_STATS={oc.PatientID=[-1.0, -1.0], oc.VariableID=[-1.0, -1.0], oc.StartOfPeriod=[-1.0, -1.0], oc.EndOfPeriod=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING MergeCriteria

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    Group(groups=[anon_grp1, anon_grp0])
      Join(groups=[#tmp_cohort10 AS c, anon_grp1])
        Access(groups=[#tmp_cohort10 AS c])
          Sort(groups=[])
            Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
            Select(groups=[oldcosara.oldcos_scores AS oc])
              Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING PlanSorts

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6], EST_CARDINALITY=-1.0})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp1.gcol0 = c.patientid], LEFT_EXPRESSIONS=[c.patientid], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], IS_LEFT_DISTINCT=true, IS_SEMI_DEP=true, SORT_RIGHT=SORT})
        Access(groups=[#tmp_cohort10 AS c])
          Sort(groups=[])
            Source(groups=[#tmp_cohort10 AS c])
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
          Group(groups=[oldcosara.oldcos_scores AS oc, anon_grp1])
            Select(groups=[oldcosara.oldcos_scores AS oc])
              Source(groups=[oldcosara.oldcos_scores AS oc])


============================================================================
EXECUTING CollapseSource

AFTER: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total], SOURCE_HINT=null, EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS PatientID=[100.0, 1.0], anon_grp0.gcol1 AS periodstart=[100.0, 1.0], anon_grp0.agg0 AS sofa_resp=[100.0, 1.0], anon_grp0.agg1 AS sofa_cardio=[100.0, 1.0], ...}})
  TupleLimit(groups=[])
    Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol0, anon_grp1.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6], EST_CARDINALITY=-1.0})
      Join(groups=[#tmp_cohort10 AS c, anon_grp1])
        Access(groups=[#tmp_cohort10 AS c], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[c.patientid], EST_CARDINALITY=10.0, EST_COL_STATS={c.patientid=[-1.0, -1.0], c.age=[-1.0, -1.0], c.sex=[-1.0, -1.0], c.patgroup=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT c.patientid FROM #tmp_cohort10 AS c ORDER BY c.patientid})
        Access(groups=[oldcosara.oldcos_scores AS oc, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=oldcosara, nameInSource=null, uuid=mmuuid:c9d363f4-512c-4638-8e07-81a29adeb278, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT X.PatientID AS gcol0, X.expr2 AS gcol1, MAX(X.expr3), MAX(X.expr4), MAX(X.expr5), MAX(X.expr6), MAX(X.expr7), MAX(X.expr8), MAX(X.expr9) FROM (SELECT oc.PatientID, convert(oc.StartOfPeriod, date) AS expr2, CASE WHEN oc.VariableID = 10001001 THEN oc."Value" END AS expr3, CASE WHEN oc.VariableID = 10001002 THEN oc."Value" END AS expr4, CASE WHEN oc.VariableID = 10001003 THEN oc."Value" END AS expr5, CASE WHEN oc.VariableID = 10001004 THEN oc."Value" END AS expr6, CASE WHEN oc.VariableID = 10001005 THEN oc."Value" END AS expr7, CASE WHEN oc.VariableID = 10001006 THEN oc."Value" END AS expr8, CASE WHEN oc.VariableID = 30010000 THEN oc."Value" END AS expr9 FROM oldcosara.oldcos_scores AS oc WHERE oc.PatientID IN (<dependent values>)) AS X GROUP BY X.PatientID, X.expr2})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN = 
ProjectNode(2) output=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total] [anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]
  LimitNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6] limit 100
    GroupingNode(4) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6] [anon_grp1.gcol0, anon_grp1.gcol1]{anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}
      JoinNode(5) [Dependent] [ENHANCED SORT JOIN [SEMI] (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[c.patientid=anon_grp1.gcol0] output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]
        AccessNode(6) output=[c.patientid] SELECT #tmp_cohort10.patientid FROM #tmp_cohort10 ORDER BY #tmp_cohort10.patientid
        DependentAccessNode(7) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6] SELECT v_0.c_0, v_0.c_1, MAX(v_0.c_2), MAX(v_0.c_3), MAX(v_0.c_4), MAX(v_0.c_5), MAX(v_0.c_6), MAX(v_0.c_7), MAX(v_0.c_8) FROM (SELECT g_0.PatientID AS c_0, convert(g_0.StartOfPeriod, date) AS c_1, CASE WHEN g_0.VariableID = 10001001 THEN g_0."Value" END AS c_2, CASE WHEN g_0.VariableID = 10001002 THEN g_0."Value" END AS c_3, CASE WHEN g_0.VariableID = 10001003 THEN g_0."Value" END AS c_4, CASE WHEN g_0.VariableID = 10001004 THEN g_0."Value" END AS c_5, CASE WHEN g_0.VariableID = 10001005 THEN g_0."Value" END AS c_6, CASE WHEN g_0.VariableID = 10001006 THEN g_0."Value" END AS c_7, CASE WHEN g_0.VariableID = 30010000 THEN g_0."Value" END AS c_8 FROM oldcosara.oldcos_scores AS g_0 WHERE g_0.PatientID IN (<dependent values>)) AS v_0 GROUP BY v_0.c_0, v_0.c_1

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(2) output=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total] [anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS periodstart, anon_grp0.agg0 AS sofa_resp, anon_grp0.agg1 AS sofa_cardio, anon_grp0.agg2 AS sofa_liver, anon_grp0.agg3 AS sofa_coag, anon_grp0.agg4 AS sofa_cns, anon_grp0.agg5 AS sofa_renal, anon_grp0.agg6 AS sofa_total]
  LimitNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6] limit 100
    GroupingNode(4) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.agg1, anon_grp0.agg2, anon_grp0.agg3, anon_grp0.agg4, anon_grp0.agg5, anon_grp0.agg6] [anon_grp1.gcol0, anon_grp1.gcol1]{anon_grp0.gcol0=anon_grp1.gcol0, anon_grp0.gcol1=anon_grp1.gcol1, anon_grp0.agg0=MAX(anon_grp1.agg0), anon_grp0.agg1=MAX(anon_grp1.agg1), anon_grp0.agg2=MAX(anon_grp1.agg2), anon_grp0.agg3=MAX(anon_grp1.agg3), anon_grp0.agg4=MAX(anon_grp1.agg4), anon_grp0.agg5=MAX(anon_grp1.agg5), anon_grp0.agg6=MAX(anon_grp1.agg6)}
      JoinNode(5) [Dependent] [ENHANCED SORT JOIN [SEMI] (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[c.patientid=anon_grp1.gcol0] output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6]
        AccessNode(6) output=[c.patientid] SELECT #tmp_cohort10.patientid FROM #tmp_cohort10 ORDER BY #tmp_cohort10.patientid
        DependentAccessNode(7) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.agg1, anon_grp1.agg2, anon_grp1.agg3, anon_grp1.agg4, anon_grp1.agg5, anon_grp1.agg6] SELECT v_0.c_0, v_0.c_1, MAX(v_0.c_2), MAX(v_0.c_3), MAX(v_0.c_4), MAX(v_0.c_5), MAX(v_0.c_6), MAX(v_0.c_7), MAX(v_0.c_8) FROM (SELECT g_0.PatientID AS c_0, convert(g_0.StartOfPeriod, date) AS c_1, CASE WHEN g_0.VariableID = 10001001 THEN g_0."Value" END AS c_2, CASE WHEN g_0.VariableID = 10001002 THEN g_0."Value" END AS c_3, CASE WHEN g_0.VariableID = 10001003 THEN g_0."Value" END AS c_4, CASE WHEN g_0.VariableID = 10001004 THEN g_0."Value" END AS c_5, CASE WHEN g_0.VariableID = 10001005 THEN g_0."Value" END AS c_6, CASE WHEN g_0.VariableID = 10001006 THEN g_0."Value" END AS c_7, CASE WHEN g_0.VariableID = 30010000 THEN g_0."Value" END AS c_8 FROM oldcosara.oldcos_scores AS g_0 WHERE g_0.PatientID IN (<dependent values>)) AS v_0 GROUP BY v_0.c_0, v_0.c_1

============================================================================