============================================================================ USER COMMAND: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.patient_admission AS pa INNER JOIN cosara2_5.patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') ---------------------------------------------------------------------------- OPTIMIZE: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.patient_admission AS pa INNER JOIN cosara2_5.patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.patient_admission AS pa INNER JOIN cosara2_5.patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') CANONICAL PLAN: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16]}) Source(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16]}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[pa.patientid, pa.admissiontime, pa.dischargetime, pa.admissionid]}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=[pa.patientid, pa.admissiontime, pa.dischargetime, pa.admissionid]}) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.patientid, p.birthdate]}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate]}) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lo.patientid, lo.labordernumber, lo.inserttime]}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=[lo.patientid, lo.labordernumber, lo.inserttime]}) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob')}) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.lab_sample AS ls]) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=lcase(lc.culturename) NOT LIKE '%volgt%'}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=length(lc.culturename) > 1}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=lc.culturename IS NOT NULL}) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p]) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob')}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk'))}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls]) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Access(groups=[cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Access(groups=[cosara2_5.lab_sample AS ls]) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls]) Access(groups=[cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=null}) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=null}) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=null}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls]) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls]) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls]) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename]}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts]}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime]}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate]}) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime]}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid]}) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid]}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime]}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=3.001339E7, EST_COL_STATS={pa.admissionid=[2051.5718, 2051.5718, 0.0], pa.admissiontime=[162.0, 12980.0, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], lc.culturename=[70.1503, 70.1503, -1.0]}}) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=3.001339E7, EST_COL_STATS={pa.admissionid=[2051.5718, 2051.5718, 0.0], pa.admissiontime=[162.0, 12980.0, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], lc.culturename=[70.1503, 70.1503, -1.0]}}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=9.0040168E7, EST_COL_STATS={p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.admissionid=[6154.715, 6154.715, 0.0], ls.sampletime=[34.871593, 608.014, -1.0], ...}}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], EST_CARDINALITY=9.0040168E7, EST_COL_STATS={p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.admissionid=[6154.715, 6154.715, 0.0], ls.sampletime=[34.871593, 608.014, -1.0], ...}}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true, EST_CARDINALITY=32962.758, EST_COL_STATS={lc.specimennumber=[181.55649, 16481.379, -1.0], lc.sampleinsertts=[181.55649, 16481.379, -1.0], lc.culturename=[479.44412, 479.44412, -1.0]}}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts], EST_COL_STATS={lc.culturename=[1847.0, 1847.0, -1.0], lc.specimennumber=[357.0, 63492.5, -1.0], lc.sampleinsertts=[357.0, 63492.5, -1.0]}, EST_CARDINALITY=126985.0}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=434176.5, EST_COL_STATS={ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0], p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], ...}}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate], EST_COL_STATS={p.patientid=[20864.0, 20864.0, 0.0], p.birthdate=[145.0, 10432.0, -1.0]}, EST_CARDINALITY=20864.0}) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=434176.5, EST_COL_STATS={lo.patientid=[1367.7142, 1367.7142, -1.0], pa.patientid=[4946.5317, 4946.5317, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0], ...}}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid], EST_COL_STATS={pa.dischargetime=[162.0, 12980.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.patientid=[20864.0, 20864.0, -1.0], pa.admissionid=[25960.0, 25960.0, 0.0]}, EST_CARDINALITY=25960.0}) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime], EST_CARDINALITY=1570260.6, EST_COL_STATS={ls.sampletime=[34.871593, 608.014, -1.0], lo.patientid=[4946.5317, 4946.5317, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0]}}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid], EST_COL_STATS={lo.labordernumber=[612.0, 187208.0, -1.0], lo.inserttime=[612.0, 187208.0, -1.0], lo.patientid=[20864.0, 20864.0, -1.0]}, EST_CARDINALITY=374416.0}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true, EST_CARDINALITY=1216.028, EST_COL_STATS={ls.labordernumber=[34.871593, 608.014, -1.0], ls.orderinsertts=[34.871593, 608.014, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ...}}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], EST_COL_STATS={ls.material=[1847.0, 1847.0, -1.0], ls.labordernumber=[610.0, 185764.0, -1.0], ls.orderinsertts=[610.0, 185764.0, -1.0], ls.sampletime=[610.0, 185764.0, -1.0], ...}, EST_CARDINALITY=371528.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls]) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=3.001339E7, EST_COL_STATS={pa.admissionid=[2051.5718, 2051.5718, 0.0], pa.admissiontime=[162.0, 12980.0, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], lc.culturename=[70.1503, 70.1503, -1.0]}}) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=9.0040168E7, EST_COL_STATS={p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.admissionid=[6154.715, 6154.715, 0.0], ls.sampletime=[34.871593, 608.014, -1.0], ...}}) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], EST_CARDINALITY=9.0040168E7, EST_COL_STATS={p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.admissionid=[6154.715, 6154.715, 0.0], ls.sampletime=[34.871593, 608.014, -1.0], ...}}) Select(groups=[cosara2_5.lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true, EST_CARDINALITY=32962.758, EST_COL_STATS={lc.specimennumber=[181.55649, 16481.379, -1.0], lc.sampleinsertts=[181.55649, 16481.379, -1.0], lc.culturename=[479.44412, 479.44412, -1.0]}}) Source(groups=[cosara2_5.lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts], EST_COL_STATS={lc.culturename=[1847.0, 1847.0, -1.0], lc.specimennumber=[357.0, 63492.5, -1.0], lc.sampleinsertts=[357.0, 63492.5, -1.0]}, EST_CARDINALITY=126985.0}) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=434176.5, EST_COL_STATS={ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0], p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], ...}}) Source(groups=[cosara2_5.patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate], EST_COL_STATS={p.patientid=[20864.0, 20864.0, 0.0], p.birthdate=[145.0, 10432.0, -1.0]}, EST_CARDINALITY=20864.0}) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=434176.5, EST_COL_STATS={lo.patientid=[1367.7142, 1367.7142, -1.0], pa.patientid=[4946.5317, 4946.5317, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0], ...}}) Source(groups=[cosara2_5.patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid], EST_COL_STATS={pa.dischargetime=[162.0, 12980.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.patientid=[20864.0, 20864.0, -1.0], pa.admissionid=[25960.0, 25960.0, 0.0]}, EST_CARDINALITY=25960.0}) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime], EST_CARDINALITY=1570260.6, EST_COL_STATS={ls.sampletime=[34.871593, 608.014, -1.0], lo.patientid=[4946.5317, 4946.5317, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ls.inserttime=[34.871593, 608.014, -1.0]}}) Source(groups=[cosara2_5.lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid], EST_COL_STATS={lo.labordernumber=[612.0, 187208.0, -1.0], lo.inserttime=[612.0, 187208.0, -1.0], lo.patientid=[20864.0, 20864.0, -1.0]}, EST_CARDINALITY=374416.0}) Select(groups=[cosara2_5.lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true, EST_CARDINALITY=1216.028, EST_COL_STATS={ls.labordernumber=[34.871593, 608.014, -1.0], ls.orderinsertts=[34.871593, 608.014, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], ls.specimennumber=[34.871593, 608.014, -1.0], ...}}) Source(groups=[cosara2_5.lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], EST_COL_STATS={ls.material=[1847.0, 1847.0, -1.0], ls.labordernumber=[610.0, 185764.0, -1.0], ls.orderinsertts=[610.0, 185764.0, -1.0], ls.sampletime=[610.0, 185764.0, -1.0], ...}, EST_CARDINALITY=371528.0}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls]) Join(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc]) Select(groups=[cosara2_5.lab_culture AS lc]) Source(groups=[cosara2_5.lab_culture AS lc]) Join(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient AS p]) Source(groups=[cosara2_5.patient AS p]) Join(groups=[cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls, cosara2_5.patient_admission AS pa]) Source(groups=[cosara2_5.patient_admission AS pa]) Join(groups=[cosara2_5.lab_sample AS ls, cosara2_5.lab_order AS lo]) Source(groups=[cosara2_5.lab_order AS lo]) Select(groups=[cosara2_5.lab_sample AS ls]) Source(groups=[cosara2_5.lab_sample AS ls]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[cosara2_5.patient_admission AS pa, cosara2_5.lab_sample AS ls, cosara2_5.lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=3.001339E7, EST_COL_STATS={pa.admissionid=[2051.5718, 2051.5718, 0.0], pa.admissiontime=[162.0, 12980.0, -1.0], ls.sampletime=[34.871593, 608.014, -1.0], lc.culturename=[70.1503, 70.1503, -1.0]}}) Select(groups=[cosara2_5.patient AS p, cosara2_5.patient_admission AS pa]) Access(groups=[cosara2_5.lab_culture AS lc, cosara2_5.patient AS p, cosara2_5.patient_admission AS pa, cosara2_5.lab_order AS lo, cosara2_5.lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=tid:2190aa264f3a-d07f6b5f-00000000, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=9.0040168E7, EST_COL_STATS={p.birthdate=[145.0, 10432.0, -1.0], pa.admissiontime=[162.0, 12980.0, -1.0], pa.admissionid=[6154.715, 6154.715, 0.0], ls.sampletime=[34.871593, 608.014, -1.0], ...}, ATOMIC_REQUEST=SELECT p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename FROM cosara2_5.lab_culture AS lc LEFT OUTER JOIN (cosara2_5.patient AS p INNER JOIN (cosara2_5.patient_admission AS pa INNER JOIN (cosara2_5.lab_order AS lo INNER JOIN cosara2_5.lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime) ON ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime) AND lo.patientid = pa.patientid) ON p.patientid = pa.patientid) ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') WHERE (lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk'))}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] [pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] SelectNode(1) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16 AccessNode(2) output=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename] SELECT g_1.birthdate, g_2.admissiontime, g_2.admissionid, g_4.sampletime, g_0.culturename FROM cosara2_5.lab_culture AS g_0 LEFT OUTER JOIN (cosara2_5.patient AS g_1 INNER JOIN (cosara2_5.patient_admission AS g_2 INNER JOIN (cosara2_5.lab_order AS g_3 INNER JOIN cosara2_5.lab_sample AS g_4 ON g_4.labordernumber = g_3.labordernumber AND g_4.orderinsertts = g_3.inserttime) ON g_4.sampletime <= g_2.dischargetime AND g_4.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, g_2.admissiontime) AND g_3.patientid = g_2.patientid) ON g_1.patientid = g_2.patientid) ON g_0.specimennumber = g_4.specimennumber AND g_0.sampleinsertts = g_4.inserttime AND g_4.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') WHERE (g_0.culturename IS NOT NULL) AND (length(g_0.culturename) > 1) AND (lcase(g_0.culturename) NOT LIKE '%volgt%') AND (g_0.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')) ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] [pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] SelectNode(1) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16 AccessNode(2) output=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename] SELECT g_1.birthdate, g_2.admissiontime, g_2.admissionid, g_4.sampletime, g_0.culturename FROM cosara2_5.lab_culture AS g_0 LEFT OUTER JOIN (cosara2_5.patient AS g_1 INNER JOIN (cosara2_5.patient_admission AS g_2 INNER JOIN (cosara2_5.lab_order AS g_3 INNER JOIN cosara2_5.lab_sample AS g_4 ON g_4.labordernumber = g_3.labordernumber AND g_4.orderinsertts = g_3.inserttime) ON g_4.sampletime <= g_2.dischargetime AND g_4.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, g_2.admissiontime) AND g_3.patientid = g_2.patientid) ON g_1.patientid = g_2.patientid) ON g_0.specimennumber = g_4.specimennumber AND g_0.sampleinsertts = g_4.inserttime AND g_4.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') WHERE (g_0.culturename IS NOT NULL) AND (length(g_0.culturename) > 1) AND (lcase(g_0.culturename) NOT LIKE '%volgt%') AND (g_0.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')) ============================================================================