============================================================================ USER COMMAND: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS l INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts WHERE l.infectionid = 880 ---------------------------------------------------------------------------- OPTIMIZE: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS l INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts WHERE l.infectionid = 880 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS l INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts WHERE l.infectionid = 880 CANONICAL PLAN: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.id, l.infectionid]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime]}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype]}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.id, l.infectionid]}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_links AS l]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING CopyCriteria AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING ChooseDependent AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=[l.id, l.infectionid], IS_COPIED=true}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.infectionid, l.id]}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=182908.86, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_CARDINALITY=182908.86, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true, EST_CARDINALITY=182908.86, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true, EST_CARDINALITY=95580.85, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true, EST_CARDINALITY=10874.37, EST_COL_STATS={cl.sampleinsertts=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, IS_COPIED=true, EST_CARDINALITY=1476.1964, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.infectionid = 880, OUTPUT_COLS=[l.id, l.infectionid], IS_COPIED=true, EST_CARDINALITY=218.18182, EST_COL_STATS={l.id=[-1.0, -1.0], l.infectionid=[-1.0, -1.0]}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.infectionid, l.id], EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0]}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.linkid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.specimennumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.sampletime=[-1.0, -1.0]}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.sampleinsertts=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING MergeCriteria AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=182908.86, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS l INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts WHERE l.infectionid = 880}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.infectionid, g_0.id, g_1.linkcultureid, g_1.responsibleculture, g_1.culturealternative, g_2.sampleinsertts, g_2.specimennumber, g_2.culturenumber, g_2.culturename, g_2.quotation, g_3.material, g_3.sampletime, g_4.culturenumber, g_4.antibiogrampart, g_4.resisttype, g_1.antibiogramculturenr, g_1.antibiogramspecimennr, g_1.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS g_0 INNER JOIN cosara2.cos2_link_culture AS g_1 ON g_1.linkid = g_0.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS g_2 ON g_2.culturenumber = g_1.culturenr AND g_2.specimennumber = g_1.culturespecimennr AND g_2.sampleinsertts = g_1.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_3 ON g_3.inserttime = g_2.sampleinsertts AND g_3.specimennumber = g_2.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_4 ON g_4.specimennumber = g_2.specimennumber AND g_4.culturenumber = g_2.culturenumber AND g_4.sampleinsertts = g_2.sampleinsertts WHERE g_0.infectionid = 880 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.infectionid, g_0.id, g_1.linkcultureid, g_1.responsibleculture, g_1.culturealternative, g_2.sampleinsertts, g_2.specimennumber, g_2.culturenumber, g_2.culturename, g_2.quotation, g_3.material, g_3.sampletime, g_4.culturenumber, g_4.antibiogrampart, g_4.resisttype, g_1.antibiogramculturenr, g_1.antibiogramspecimennr, g_1.antibiogramsampleinsertts FROM (((cosara2.cos2_links AS g_0 INNER JOIN cosara2.cos2_link_culture AS g_1 ON g_1.linkid = g_0.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS g_2 ON g_2.culturenumber = g_1.culturenr AND g_2.specimennumber = g_1.culturespecimennr AND g_2.sampleinsertts = g_1.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_3 ON g_3.inserttime = g_2.sampleinsertts AND g_3.specimennumber = g_2.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_4 ON g_4.specimennumber = g_2.specimennumber AND g_4.culturenumber = g_2.culturenumber AND g_4.sampleinsertts = g_2.sampleinsertts WHERE g_0.infectionid = 880 ============================================================================