Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.laufzeit AS laufzeit_4,
  t0.nachlaufzeit AS nachlaufzeit_5,
  t0.strasse AS strasse_6,
  t0.hausnummer AS hausnummer_7,
  t0.plz AS plz_8,
  t0.ort AS ort_9,
  t0.telefon AS telefon_10,
  t0.fax AS fax_11,
  t0.email AS email_12,
  t0.ansprechpartner AS ansprechpartner_13,
  t0.semester AS semester_14,
  t0.user_pro_semester AS user_pro_semester_15,
  t0.is_public AS is_public_16,
  t0.is_default AS is_default_17,
  t0.export AS export_18,
  t0.is_activated AS is_activated_19,
  t0.kundennummer AS kundennummer_20,
  t0.studierende AS studierende_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.created_by AS created_by_24,
  t0.updated_by AS updated_by_25,
  t26.id AS id_27,
  t26.kontoinhaber AS kontoinhaber_28,
  t26.bank AS bank_29,
  t26.iban AS iban_30,
  t26.bic AS bic_31,
  t26.created_at AS created_at_32,
  t26.updated_at AS updated_at_33,
  t26.organisation_id AS organisation_id_34
FROM
  organisationen t0
  LEFT JOIN organisationen_payment t26 ON t26.organisation_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.laufzeit AS laufzeit_4, t0.nachlaufzeit AS nachlaufzeit_5, t0.strasse AS strasse_6, t0.hausnummer AS hausnummer_7, t0.plz AS plz_8, t0.ort AS ort_9, t0.telefon AS telefon_10, t0.fax AS fax_11, t0.email AS email_12, t0.ansprechpartner AS ansprechpartner_13, t0.semester AS semester_14, t0.user_pro_semester AS user_pro_semester_15, t0.is_public AS is_public_16, t0.is_default AS is_default_17, t0.export AS export_18, t0.is_activated AS is_activated_19, t0.kundennummer AS kundennummer_20, t0.studierende AS studierende_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t26.id AS id_27, t26.kontoinhaber AS kontoinhaber_28, t26.bank AS bank_29, t26.iban AS iban_30, t26.bic AS bic_31, t26.created_at AS created_at_32, t26.updated_at AS updated_at_33, t26.organisation_id AS organisation_id_34 FROM organisationen t0 LEFT JOIN organisationen_payment t26 ON t26.organisation_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.role AS role_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_active AS is_active_6,
  t0.confirmed AS confirmed_7,
  t0.activated AS activated_8,
  t0.beginn AS beginn_9,
  t0.ende AS ende_10,
  t0.export AS export_11,
  t0.kundennummer AS kundennummer_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.organisation_id AS organisation_id_17,
  t18.id AS id_19,
  t18.name AS name_20,
  t18.description AS description_21,
  t18.laufzeit AS laufzeit_22,
  t18.nachlaufzeit AS nachlaufzeit_23,
  t18.strasse AS strasse_24,
  t18.hausnummer AS hausnummer_25,
  t18.plz AS plz_26,
  t18.ort AS ort_27,
  t18.telefon AS telefon_28,
  t18.fax AS fax_29,
  t18.email AS email_30,
  t18.ansprechpartner AS ansprechpartner_31,
  t18.semester AS semester_32,
  t18.user_pro_semester AS user_pro_semester_33,
  t18.is_public AS is_public_34,
  t18.is_default AS is_default_35,
  t18.export AS export_36,
  t18.is_activated AS is_activated_37,
  t18.kundennummer AS kundennummer_38,
  t18.studierende AS studierende_39,
  t18.created_at AS created_at_40,
  t18.updated_at AS updated_at_41,
  t18.created_by AS created_by_42,
  t18.updated_by AS updated_by_43,
  t0.semester_id AS semester_id_44,
  t45.id AS id_46,
  t45.kontoinhaber AS kontoinhaber_47,
  t45.bank AS bank_48,
  t45.iban AS iban_49,
  t45.bic AS bic_50,
  t45.user_id AS user_id_51,
  t52.id AS id_53,
  t52.vorname AS vorname_54,
  t52.nachname AS nachname_55,
  t52.anschrift AS anschrift_56,
  t52.plz AS plz_57,
  t52.ort AS ort_58,
  t52.telefon AS telefon_59,
  t52.fax AS fax_60,
  t52.anrede AS anrede_61,
  t52.user_id AS user_id_62,
  t0.locale_id AS locale_id_63
FROM
  user t0
  INNER JOIN organisationen t18 ON t0.organisation_id = t18.id
  LEFT JOIN user_payment t45 ON t45.user_id = t0.id
  LEFT JOIN user_profile t52 ON t52.user_id = t0.id

SELECT t0.id AS id_1, t0.username AS username_2, t0.role AS role_3, t0.password AS password_4, t0.email AS email_5, t0.is_active AS is_active_6, t0.confirmed AS confirmed_7, t0.activated AS activated_8, t0.beginn AS beginn_9, t0.ende AS ende_10, t0.export AS export_11, t0.kundennummer AS kundennummer_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.organisation_id AS organisation_id_17, t18.id AS id_19, t18.name AS name_20, t18.description AS description_21, t18.laufzeit AS laufzeit_22, t18.nachlaufzeit AS nachlaufzeit_23, t18.strasse AS strasse_24, t18.hausnummer AS hausnummer_25, t18.plz AS plz_26, t18.ort AS ort_27, t18.telefon AS telefon_28, t18.fax AS fax_29, t18.email AS email_30, t18.ansprechpartner AS ansprechpartner_31, t18.semester AS semester_32, t18.user_pro_semester AS user_pro_semester_33, t18.is_public AS is_public_34, t18.is_default AS is_default_35, t18.export AS export_36, t18.is_activated AS is_activated_37, t18.kundennummer AS kundennummer_38, t18.studierende AS studierende_39, t18.created_at AS created_at_40, t18.updated_at AS updated_at_41, t18.created_by AS created_by_42, t18.updated_by AS updated_by_43, t0.semester_id AS semester_id_44, t45.id AS id_46, t45.kontoinhaber AS kontoinhaber_47, t45.bank AS bank_48, t45.iban AS iban_49, t45.bic AS bic_50, t45.user_id AS user_id_51, t52.id AS id_53, t52.vorname AS vorname_54, t52.nachname AS nachname_55, t52.anschrift AS anschrift_56, t52.plz AS plz_57, t52.ort AS ort_58, t52.telefon AS telefon_59, t52.fax AS fax_60, t52.anrede AS anrede_61, t52.user_id AS user_id_62, t0.locale_id AS locale_id_63 FROM user t0 INNER JOIN organisationen t18 ON t0.organisation_id = t18.id LEFT JOIN user_payment t45 ON t45.user_id = t0.id LEFT JOIN user_profile t52 ON t52.user_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.public AS public_2,
  t0.titel AS titel_3,
  t0.counter AS counter_4,
  t0.is_bewertet AS is_bewertet_5,
  t0.bewertung_gesehen AS bewertung_gesehen_6,
  t0.behandlung_von AS behandlung_von_7,
  t0.behandlung_bis AS behandlung_bis_8,
  t0.public_at AS public_at_9,
  t0.abgeschlossen_at AS abgeschlossen_at_10,
  t0.archiviert AS archiviert_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.user_id AS user_id_16,
  t0.fall_art_id AS fall_art_id_17,
  t18.id AS id_19,
  t18.befund_med AS befund_med_20,
  t18.befund_allg AS befund_allg_21,
  t18.befund_interoral AS befund_interoral_22,
  t18.kiefer_zaehne_fehlend AS kiefer_zaehne_fehlend_23,
  t18.kiefer_zaehne_amalgam AS kiefer_zaehne_amalgam_24,
  t18.kiefer_zaehne_komposit AS kiefer_zaehne_komposit_25,
  t18.kiefer_zaehne_krone AS kiefer_zaehne_krone_26,
  t18.kiefer_zaehne_karioes AS kiefer_zaehne_karioes_27,
  t18.kiefer_zaehne_wurzel AS kiefer_zaehne_wurzel_28,
  t18.kiefer_fuellungsuebergaenge AS kiefer_fuellungsuebergaenge_29,
  t18.kiefer_pusentleerung AS kiefer_pusentleerung_30,
  t18.kiefer_roetung_gingiva AS kiefer_roetung_gingiva_31,
  t18.kiefer_plaqueindex AS kiefer_plaqueindex_32,
  t18.kiefer_zahnlockerung AS kiefer_zahnlockerung_33,
  t18.kiefer_furkationsbefall AS kiefer_furkationsbefall_34,
  t18.kiefer_sulcusblutungsindex AS kiefer_sulcusblutungsindex_35,
  t18.kiefer_sondierungsbefund AS kiefer_sondierungsbefund_36,
  t18.fall_id AS fall_id_37,
  t38.id AS id_39,
  t38.bewertung AS bewertung_40,
  t38.punkte AS punkte_41,
  t38.created_at AS created_at_42,
  t38.updated_at AS updated_at_43,
  t38.created_by AS created_by_44,
  t38.updated_by AS updated_by_45,
  t38.fall_id AS fall_id_46,
  t38.user_id AS user_id_47,
  t48.id AS id_49,
  t48.description AS description_50,
  t48.fall_id AS fall_id_51,
  t52.id AS id_53,
  t52.name AS name_54,
  t52.alter_bei_vorstellung AS alter_bei_vorstellung_55,
  t52.geburtsdatum AS geburtsdatum_56,
  t52.behandlung_von AS behandlung_von_57,
  t52.behandlung_bis AS behandlung_bis_58,
  t52.vorname AS vorname_59,
  t52.fall_id AS fall_id_60,
  t61.id AS id_62,
  t61.kanaele AS kanaele_63,
  t61.created_at AS created_at_64,
  t61.updated_at AS updated_at_65,
  t61.created_by AS created_by_66,
  t61.updated_by AS updated_by_67,
  t61.fall_id AS fall_id_68,
  t69.id AS id_70,
  t69.datum AS datum_71,
  t69.spezielle_anamnese AS spezielle_anamnese_72,
  t69.allg_anamnese AS allg_anamnese_73,
  t69.erhaltungstherapie AS erhaltungstherapie_74,
  t69.diagnose AS diagnose_75,
  t69.created_at AS created_at_76,
  t69.updated_at AS updated_at_77,
  t69.created_by AS created_by_78,
  t69.updated_by AS updated_by_79,
  t69.fall_id AS fall_id_80,
  t81.id AS id_82,
  t81.datum AS datum_83,
  t81.zahn AS zahn_84,
  t81.beschwerden_seit AS beschwerden_seit_85,
  t81.art_der_beschwerden AS art_der_beschwerden_86,
  t81.schwellung_extraoral AS schwellung_extraoral_87,
  t81.sensibilitaetstest_art AS sensibilitaetstest_art_88,
  t81.sensibilitaetstest_ergebnis AS sensibilitaetstest_ergebnis_89,
  t81.perkussion AS perkussion_90,
  t81.sondierungstiefe_vestibulaer_m AS sondierungstiefe_vestibulaer_m_91,
  t81.sondierungstiefe_vestibulaer_f AS sondierungstiefe_vestibulaer_f_92,
  t81.sondierungstiefe_vestibulaer_d AS sondierungstiefe_vestibulaer_d_93,
  t81.sondierungstiefe_oral_m AS sondierungstiefe_oral_m_94,
  t81.sondierungstiefe_oral_f AS sondierungstiefe_oral_f_95,
  t81.sondierungstiefe_oral_d AS sondierungstiefe_oral_d_96,
  t81.created_at AS created_at_97,
  t81.updated_at AS updated_at_98,
  t81.created_by AS created_by_99,
  t81.updated_by AS updated_by_100,
  t81.umschlagfalte_id AS umschlagfalte_id_101,
  t81.lockerung_id AS lockerung_id_102,
  t81.fall_id AS fall_id_103,
  t104.id AS id_105,
  t104.datum AS datum_106,
  t104.has_allergie AS has_allergie_107,
  t104.text_allergie AS text_allergie_108,
  t104.has_asthma AS has_asthma_109,
  t104.text_asthma AS text_asthma_110,
  t104.has_anfallsleiden AS has_anfallsleiden_111,
  t104.text_anfallsleiden AS text_anfallsleiden_112,
  t104.has_depression AS has_depression_113,
  t104.text_depression AS text_depression_114,
  t104.has_diabetes AS has_diabetes_115,
  t104.text_diabetes AS text_diabetes_116,
  t104.has_blutgerinnung AS has_blutgerinnung_117,
  t104.text_blutgerinnung AS text_blutgerinnung_118,
  t104.has_bluterkrankung AS has_bluterkrankung_119,
  t104.text_bluterkrankung AS text_bluterkrankung_120,
  t104.has_herzkreislauf AS has_herzkreislauf_121,
  t104.text_herzkreislauf AS text_herzkreislauf_122,
  t104.has_herzinsuffizienz AS has_herzinsuffizienz_123,
  t104.text_herzinsuffizienz AS text_herzinsuffizienz_124,
  t104.has_koronare_herzkrankheit AS has_koronare_herzkrankheit_125,
  t104.text_koronare_herzkrankheit AS text_koronare_herzkrankheit_126,
  t104.has_herzinfarkt AS has_herzinfarkt_127,
  t104.text_herzinfarkt AS text_herzinfarkt_128,
  t104.has_herzrhythmusstoerung AS has_herzrhythmusstoerung_129,
  t104.text_herzrhythmusstoerung AS text_herzrhythmusstoerung_130,
  t104.has_herzschrittmacher AS has_herzschrittmacher_131,
  t104.text_herzschrittmacher AS text_herzschrittmacher_132,
  t104.has_herzklappenfehler AS has_herzklappenfehler_133,
  t104.text_herzklappenfehler AS text_herzklappenfehler_134,
  t104.has_erhoehter_blutdruck AS has_erhoehter_blutdruck_135,
  t104.text_erhoehter_blutdruck AS text_erhoehter_blutdruck_136,
  t104.has_niedriger_blutdruck AS has_niedriger_blutdruck_137,
  t104.text_niedriger_blutdruck AS text_niedriger_blutdruck_138,
  t104.has_erhoehte_blutfettwerte AS has_erhoehte_blutfettwerte_139,
  t104.text_erhoehte_blutfettwerte AS text_erhoehte_blutfettwerte_140,
  t104.has_schlaganfall AS has_schlaganfall_141,
  t104.text_schlaganfall AS text_schlaganfall_142,
  t104.has_infektionskrankheiten AS has_infektionskrankheiten_143,
  t104.text_infektionskrankheiten AS text_infektionskrankheiten_144,
  t104.has_hepatitis AS has_hepatitis_145,
  t104.text_hepatitis AS text_hepatitis_146,
  t104.has_tuberkulose AS has_tuberkulose_147,
  t104.text_tuberkulose AS text_tuberkulose_148,
  t104.has_hiv AS has_hiv_149,
  t104.text_hiv AS text_hiv_150,
  t104.has_atemwegserkrankungen AS has_atemwegserkrankungen_151,
  t104.text_atemwegserkrankungen AS text_atemwegserkrankungen_152,
  t104.has_glaukom AS has_glaukom_153,
  t104.text_glaukom AS text_glaukom_154,
  t104.has_lebererkrankungen AS has_lebererkrankungen_155,
  t104.text_lebererkrankungen AS text_lebererkrankungen_156,
  t104.has_magen_darm_erkrankungen AS has_magen_darm_erkrankungen_157,
  t104.text_magen_darm_erkrankungen AS text_magen_darm_erkrankungen_158,
  t104.has_nierenerkrankungen AS has_nierenerkrankungen_159,
  t104.text_nierenerkrankungen AS text_nierenerkrankungen_160,
  t104.has_chronische_niereninsuffiznenz AS has_chronische_niereninsuffiznenz_161,
  t104.text_chronische_niereninsuffizienz AS text_chronische_niereninsuffizienz_162,
  t104.has_dialyse AS has_dialyse_163,
  t104.text_dialyse AS text_dialyse_164,
  t104.has_osteoporose AS has_osteoporose_165,
  t104.text_osteoporose AS text_osteoporose_166,
  t104.has_gelenkrheuma AS has_gelenkrheuma_167,
  t104.text_gelenkrheuma AS text_gelenkrheuma_168,
  t104.has_schilddruesenfehlfunktion AS has_schilddruesenfehlfunktion_169,
  t104.text_schilddruesenfehlfunktion AS text_schilddruesenfehlfunktion_170,
  t104.has_tumorernkranungen AS has_tumorernkranungen_171,
  t104.text_tumorerkrankungen AS text_tumorerkrankungen_172,
  t104.has_fruehere_stationaere_behandlung AS has_fruehere_stationaere_behandlung_173,
  t104.text_fruehere_stationaere_behandlung AS text_fruehere_stationaere_behandlung_174,
  t104.has_schwangerschaft AS has_schwangerschaft_175,
  t104.text_schwangerschaft AS text_schwangerschaft_176,
  t104.has_zwischenfaelle_beim_zahnarzt AS has_zwischenfaelle_beim_zahnarzt_177,
  t104.text_zwischenfaelle_beim_zahnarzt AS text_zwischenfaelle_beim_zahnarzt_178,
  t104.is_zufrieden AS is_zufrieden_179,
  t104.is_kobehandlung AS is_kobehandlung_180,
  t104.is_zaehne_gewandert AS is_zaehne_gewandert_181,
  t104.is_mundgeruch AS is_mundgeruch_182,
  t104.is_locker_zaehne AS is_locker_zaehne_183,
  t104.is_parodontosebehandlung AS is_parodontosebehandlung_184,
  t104.is_blutendes_zahnfleisch AS is_blutendes_zahnfleisch_185,
  t104.is_zahnseide AS is_zahnseide_186,
  t104.is_raucher AS is_raucher_187,
  t104.rauchen_typ AS rauchen_typ_188,
  t104.rauchen_art AS rauchen_art_189,
  t104.rauchen_seit AS rauchen_seit_190,
  t104.rauchen_menge AS rauchen_menge_191,
  t104.rauchen_ende AS rauchen_ende_192,
  t104.medikamente AS medikamente_193,
  t104.is_kopfschmerzen AS is_kopfschmerzen_194,
  t104.has_covid19 AS has_covid19_195,
  t104.text_covid19 AS text_covid19_196,
  t104.created_at AS created_at_197,
  t104.updated_at AS updated_at_198,
  t104.created_by AS created_by_199,
  t104.updated_by AS updated_by_200,
  t104.fall_id AS fall_id_201
FROM
  fall t0
  LEFT JOIN fall_befund t18 ON t18.fall_id = t0.id
  LEFT JOIN fall_bewertung t38 ON t38.fall_id = t0.id
  LEFT JOIN fall_epikrise t48 ON t48.fall_id = t0.id
  LEFT JOIN fall_patient t52 ON t52.fall_id = t0.id
  LEFT JOIN endo_therapie t61 ON t61.fall_id = t0.id
  LEFT JOIN anamnese_prothetik t69 ON t69.fall_id = t0.id
  LEFT JOIN anamnese_endo t81 ON t81.fall_id = t0.id
  LEFT JOIN anamnese_paro t104 ON t104.fall_id = t0.id

SELECT t0.id AS id_1, t0.public AS public_2, t0.titel AS titel_3, t0.counter AS counter_4, t0.is_bewertet AS is_bewertet_5, t0.bewertung_gesehen AS bewertung_gesehen_6, t0.behandlung_von AS behandlung_von_7, t0.behandlung_bis AS behandlung_bis_8, t0.public_at AS public_at_9, t0.abgeschlossen_at AS abgeschlossen_at_10, t0.archiviert AS archiviert_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.user_id AS user_id_16, t0.fall_art_id AS fall_art_id_17, t18.id AS id_19, t18.befund_med AS befund_med_20, t18.befund_allg AS befund_allg_21, t18.befund_interoral AS befund_interoral_22, t18.kiefer_zaehne_fehlend AS kiefer_zaehne_fehlend_23, t18.kiefer_zaehne_amalgam AS kiefer_zaehne_amalgam_24, t18.kiefer_zaehne_komposit AS kiefer_zaehne_komposit_25, t18.kiefer_zaehne_krone AS kiefer_zaehne_krone_26, t18.kiefer_zaehne_karioes AS kiefer_zaehne_karioes_27, t18.kiefer_zaehne_wurzel AS kiefer_zaehne_wurzel_28, t18.kiefer_fuellungsuebergaenge AS kiefer_fuellungsuebergaenge_29, t18.kiefer_pusentleerung AS kiefer_pusentleerung_30, t18.kiefer_roetung_gingiva AS kiefer_roetung_gingiva_31, t18.kiefer_plaqueindex AS kiefer_plaqueindex_32, t18.kiefer_zahnlockerung AS kiefer_zahnlockerung_33, t18.kiefer_furkationsbefall AS kiefer_furkationsbefall_34, t18.kiefer_sulcusblutungsindex AS kiefer_sulcusblutungsindex_35, t18.kiefer_sondierungsbefund AS kiefer_sondierungsbefund_36, t18.fall_id AS fall_id_37, t38.id AS id_39, t38.bewertung AS bewertung_40, t38.punkte AS punkte_41, t38.created_at AS created_at_42, t38.updated_at AS updated_at_43, t38.created_by AS created_by_44, t38.updated_by AS updated_by_45, t38.fall_id AS fall_id_46, t38.user_id AS user_id_47, t48.id AS id_49, t48.description AS description_50, t48.fall_id AS fall_id_51, t52.id AS id_53, t52.name AS name_54, t52.alter_bei_vorstellung AS alter_bei_vorstellung_55, t52.geburtsdatum AS geburtsdatum_56, t52.behandlung_von AS behandlung_von_57, t52.behandlung_bis AS behandlung_bis_58, t52.vorname AS vorname_59, t52.fall_id AS fall_id_60, t61.id AS id_62, t61.kanaele AS kanaele_63, t61.created_at AS created_at_64, t61.updated_at AS updated_at_65, t61.created_by AS created_by_66, t61.updated_by AS updated_by_67, t61.fall_id AS fall_id_68, t69.id AS id_70, t69.datum AS datum_71, t69.spezielle_anamnese AS spezielle_anamnese_72, t69.allg_anamnese AS allg_anamnese_73, t69.erhaltungstherapie AS erhaltungstherapie_74, t69.diagnose AS diagnose_75, t69.created_at AS created_at_76, t69.updated_at AS updated_at_77, t69.created_by AS created_by_78, t69.updated_by AS updated_by_79, t69.fall_id AS fall_id_80, t81.id AS id_82, t81.datum AS datum_83, t81.zahn AS zahn_84, t81.beschwerden_seit AS beschwerden_seit_85, t81.art_der_beschwerden AS art_der_beschwerden_86, t81.schwellung_extraoral AS schwellung_extraoral_87, t81.sensibilitaetstest_art AS sensibilitaetstest_art_88, t81.sensibilitaetstest_ergebnis AS sensibilitaetstest_ergebnis_89, t81.perkussion AS perkussion_90, t81.sondierungstiefe_vestibulaer_m AS sondierungstiefe_vestibulaer_m_91, t81.sondierungstiefe_vestibulaer_f AS sondierungstiefe_vestibulaer_f_92, t81.sondierungstiefe_vestibulaer_d AS sondierungstiefe_vestibulaer_d_93, t81.sondierungstiefe_oral_m AS sondierungstiefe_oral_m_94, t81.sondierungstiefe_oral_f AS sondierungstiefe_oral_f_95, t81.sondierungstiefe_oral_d AS sondierungstiefe_oral_d_96, t81.created_at AS created_at_97, t81.updated_at AS updated_at_98, t81.created_by AS created_by_99, t81.updated_by AS updated_by_100, t81.umschlagfalte_id AS umschlagfalte_id_101, t81.lockerung_id AS lockerung_id_102, t81.fall_id AS fall_id_103, t104.id AS id_105, t104.datum AS datum_106, t104.has_allergie AS has_allergie_107, t104.text_allergie AS text_allergie_108, t104.has_asthma AS has_asthma_109, t104.text_asthma AS text_asthma_110, t104.has_anfallsleiden AS has_anfallsleiden_111, t104.text_anfallsleiden AS text_anfallsleiden_112, t104.has_depression AS has_depression_113, t104.text_depression AS text_depression_114, t104.has_diabetes AS has_diabetes_115, t104.text_diabetes AS text_diabetes_116, t104.has_blutgerinnung AS has_blutgerinnung_117, t104.text_blutgerinnung AS text_blutgerinnung_118, t104.has_bluterkrankung AS has_bluterkrankung_119, t104.text_bluterkrankung AS text_bluterkrankung_120, t104.has_herzkreislauf AS has_herzkreislauf_121, t104.text_herzkreislauf AS text_herzkreislauf_122, t104.has_herzinsuffizienz AS has_herzinsuffizienz_123, t104.text_herzinsuffizienz AS text_herzinsuffizienz_124, t104.has_koronare_herzkrankheit AS has_koronare_herzkrankheit_125, t104.text_koronare_herzkrankheit AS text_koronare_herzkrankheit_126, t104.has_herzinfarkt AS has_herzinfarkt_127, t104.text_herzinfarkt AS text_herzinfarkt_128, t104.has_herzrhythmusstoerung AS has_herzrhythmusstoerung_129, t104.text_herzrhythmusstoerung AS text_herzrhythmusstoerung_130, t104.has_herzschrittmacher AS has_herzschrittmacher_131, t104.text_herzschrittmacher AS text_herzschrittmacher_132, t104.has_herzklappenfehler AS has_herzklappenfehler_133, t104.text_herzklappenfehler AS text_herzklappenfehler_134, t104.has_erhoehter_blutdruck AS has_erhoehter_blutdruck_135, t104.text_erhoehter_blutdruck AS text_erhoehter_blutdruck_136, t104.has_niedriger_blutdruck AS has_niedriger_blutdruck_137, t104.text_niedriger_blutdruck AS text_niedriger_blutdruck_138, t104.has_erhoehte_blutfettwerte AS has_erhoehte_blutfettwerte_139, t104.text_erhoehte_blutfettwerte AS text_erhoehte_blutfettwerte_140, t104.has_schlaganfall AS has_schlaganfall_141, t104.text_schlaganfall AS text_schlaganfall_142, t104.has_infektionskrankheiten AS has_infektionskrankheiten_143, t104.text_infektionskrankheiten AS text_infektionskrankheiten_144, t104.has_hepatitis AS has_hepatitis_145, t104.text_hepatitis AS text_hepatitis_146, t104.has_tuberkulose AS has_tuberkulose_147, t104.text_tuberkulose AS text_tuberkulose_148, t104.has_hiv AS has_hiv_149, t104.text_hiv AS text_hiv_150, t104.has_atemwegserkrankungen AS has_atemwegserkrankungen_151, t104.text_atemwegserkrankungen AS text_atemwegserkrankungen_152, t104.has_glaukom AS has_glaukom_153, t104.text_glaukom AS text_glaukom_154, t104.has_lebererkrankungen AS has_lebererkrankungen_155, t104.text_lebererkrankungen AS text_lebererkrankungen_156, t104.has_magen_darm_erkrankungen AS has_magen_darm_erkrankungen_157, t104.text_magen_darm_erkrankungen AS text_magen_darm_erkrankungen_158, t104.has_nierenerkrankungen AS has_nierenerkrankungen_159, t104.text_nierenerkrankungen AS text_nierenerkrankungen_160, t104.has_chronische_niereninsuffiznenz AS has_chronische_niereninsuffiznenz_161, t104.text_chronische_niereninsuffizienz AS text_chronische_niereninsuffizienz_162, t104.has_dialyse AS has_dialyse_163, t104.text_dialyse AS text_dialyse_164, t104.has_osteoporose AS has_osteoporose_165, t104.text_osteoporose AS text_osteoporose_166, t104.has_gelenkrheuma AS has_gelenkrheuma_167, t104.text_gelenkrheuma AS text_gelenkrheuma_168, t104.has_schilddruesenfehlfunktion AS has_schilddruesenfehlfunktion_169, t104.text_schilddruesenfehlfunktion AS text_schilddruesenfehlfunktion_170, t104.has_tumorernkranungen AS has_tumorernkranungen_171, t104.text_tumorerkrankungen AS text_tumorerkrankungen_172, t104.has_fruehere_stationaere_behandlung AS has_fruehere_stationaere_behandlung_173, t104.text_fruehere_stationaere_behandlung AS text_fruehere_stationaere_behandlung_174, t104.has_schwangerschaft AS has_schwangerschaft_175, t104.text_schwangerschaft AS text_schwangerschaft_176, t104.has_zwischenfaelle_beim_zahnarzt AS has_zwischenfaelle_beim_zahnarzt_177, t104.text_zwischenfaelle_beim_zahnarzt AS text_zwischenfaelle_beim_zahnarzt_178, t104.is_zufrieden AS is_zufrieden_179, t104.is_kobehandlung AS is_kobehandlung_180, t104.is_zaehne_gewandert AS is_zaehne_gewandert_181, t104.is_mundgeruch AS is_mundgeruch_182, t104.is_locker_zaehne AS is_locker_zaehne_183, t104.is_parodontosebehandlung AS is_parodontosebehandlung_184, t104.is_blutendes_zahnfleisch AS is_blutendes_zahnfleisch_185, t104.is_zahnseide AS is_zahnseide_186, t104.is_raucher AS is_raucher_187, t104.rauchen_typ AS rauchen_typ_188, t104.rauchen_art AS rauchen_art_189, t104.rauchen_seit AS rauchen_seit_190, t104.rauchen_menge AS rauchen_menge_191, t104.rauchen_ende AS rauchen_ende_192, t104.medikamente AS medikamente_193, t104.is_kopfschmerzen AS is_kopfschmerzen_194, t104.has_covid19 AS has_covid19_195, t104.text_covid19 AS text_covid19_196, t104.created_at AS created_at_197, t104.updated_at AS updated_at_198, t104.created_by AS created_by_199, t104.updated_by AS updated_by_200, t104.fall_id AS fall_id_201 FROM fall t0 LEFT JOIN fall_befund t18 ON t18.fall_id = t0.id LEFT JOIN fall_bewertung t38 ON t38.fall_id = t0.id LEFT JOIN fall_epikrise t48 ON t48.fall_id = t0.id LEFT JOIN fall_patient t52 ON t52.fall_id = t0.id LEFT JOIN endo_therapie t61 ON t61.fall_id = t0.id LEFT JOIN anamnese_prothetik t69 ON t69.fall_id = t0.id LEFT JOIN anamnese_endo t81 ON t81.fall_id = t0.id LEFT JOIN anamnese_paro t104 ON t104.fall_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2,
  t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3,
  t0.initialbehandlung AS initialbehandlung_4,
  t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5,
  t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6,
  t0.koronales_drittel AS koronales_drittel_7,
  t0.mittleres_drittel AS mittleres_drittel_8,
  t0.apikales_drittel AS apikales_drittel_9,
  t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10,
  t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11,
  t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12,
  t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13,
  t0.komp_at AS komp_at_14,
  t0.komp_symptome AS komp_symptome_15,
  t0.komp_therapie AS komp_therapie_16,
  t0.wkf_date AS wkf_date_17,
  t0.wkf_sealer AS wkf_sealer_18,
  t0.wkf_bemerkungen AS wkf_bemerkungen_19,
  t0.is_userfilled AS is_userfilled_20,
  t0.therapie_id AS therapie_id_21,
  t0.komp_kanal_id AS komp_kanal_id_22,
  t0.komp_art_id AS komp_art_id_23,
  t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24
FROM
  endo_therapie_bogen t0
WHERE
  t0.therapie_id = ?

SELECT t0.id AS id_1, t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2, t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3, t0.initialbehandlung AS initialbehandlung_4, t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5, t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6, t0.koronales_drittel AS koronales_drittel_7, t0.mittleres_drittel AS mittleres_drittel_8, t0.apikales_drittel AS apikales_drittel_9, t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10, t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11, t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12, t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13, t0.komp_at AS komp_at_14, t0.komp_symptome AS komp_symptome_15, t0.komp_therapie AS komp_therapie_16, t0.wkf_date AS wkf_date_17, t0.wkf_sealer AS wkf_sealer_18, t0.wkf_bemerkungen AS wkf_bemerkungen_19, t0.is_userfilled AS is_userfilled_20, t0.therapie_id AS therapie_id_21, t0.komp_kanal_id AS komp_kanal_id_22, t0.komp_art_id AS komp_art_id_23, t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24 FROM endo_therapie_bogen t0 WHERE t0.therapie_id = 0x5FCB678D685511EE9C53B42E996A43E7;

SELECT
  t0.id AS id_1,
  t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2,
  t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3,
  t0.initialbehandlung AS initialbehandlung_4,
  t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5,
  t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6,
  t0.koronales_drittel AS koronales_drittel_7,
  t0.mittleres_drittel AS mittleres_drittel_8,
  t0.apikales_drittel AS apikales_drittel_9,
  t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10,
  t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11,
  t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12,
  t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13,
  t0.komp_at AS komp_at_14,
  t0.komp_symptome AS komp_symptome_15,
  t0.komp_therapie AS komp_therapie_16,
  t0.wkf_date AS wkf_date_17,
  t0.wkf_sealer AS wkf_sealer_18,
  t0.wkf_bemerkungen AS wkf_bemerkungen_19,
  t0.is_userfilled AS is_userfilled_20,
  t0.therapie_id AS therapie_id_21,
  t0.komp_kanal_id AS komp_kanal_id_22,
  t0.komp_art_id AS komp_art_id_23,
  t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24
FROM
  endo_therapie_bogen t0
WHERE
  t0.therapie_id = ?

SELECT t0.id AS id_1, t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2, t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3, t0.initialbehandlung AS initialbehandlung_4, t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5, t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6, t0.koronales_drittel AS koronales_drittel_7, t0.mittleres_drittel AS mittleres_drittel_8, t0.apikales_drittel AS apikales_drittel_9, t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10, t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11, t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12, t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13, t0.komp_at AS komp_at_14, t0.komp_symptome AS komp_symptome_15, t0.komp_therapie AS komp_therapie_16, t0.wkf_date AS wkf_date_17, t0.wkf_sealer AS wkf_sealer_18, t0.wkf_bemerkungen AS wkf_bemerkungen_19, t0.is_userfilled AS is_userfilled_20, t0.therapie_id AS therapie_id_21, t0.komp_kanal_id AS komp_kanal_id_22, t0.komp_art_id AS komp_art_id_23, t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24 FROM endo_therapie_bogen t0 WHERE t0.therapie_id = 0x610FBDE662E811EE9B54B42E996A43E7;

SELECT
  t0.id AS id_1,
  t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2,
  t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3,
  t0.initialbehandlung AS initialbehandlung_4,
  t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5,
  t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6,
  t0.koronales_drittel AS koronales_drittel_7,
  t0.mittleres_drittel AS mittleres_drittel_8,
  t0.apikales_drittel AS apikales_drittel_9,
  t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10,
  t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11,
  t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12,
  t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13,
  t0.komp_at AS komp_at_14,
  t0.komp_symptome AS komp_symptome_15,
  t0.komp_therapie AS komp_therapie_16,
  t0.wkf_date AS wkf_date_17,
  t0.wkf_sealer AS wkf_sealer_18,
  t0.wkf_bemerkungen AS wkf_bemerkungen_19,
  t0.is_userfilled AS is_userfilled_20,
  t0.therapie_id AS therapie_id_21,
  t0.komp_kanal_id AS komp_kanal_id_22,
  t0.komp_art_id AS komp_art_id_23,
  t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24
FROM
  endo_therapie_bogen t0
WHERE
  t0.therapie_id = ?

SELECT t0.id AS id_1, t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2, t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3, t0.initialbehandlung AS initialbehandlung_4, t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5, t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6, t0.koronales_drittel AS koronales_drittel_7, t0.mittleres_drittel AS mittleres_drittel_8, t0.apikales_drittel AS apikales_drittel_9, t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10, t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11, t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12, t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13, t0.komp_at AS komp_at_14, t0.komp_symptome AS komp_symptome_15, t0.komp_therapie AS komp_therapie_16, t0.wkf_date AS wkf_date_17, t0.wkf_sealer AS wkf_sealer_18, t0.wkf_bemerkungen AS wkf_bemerkungen_19, t0.is_userfilled AS is_userfilled_20, t0.therapie_id AS therapie_id_21, t0.komp_kanal_id AS komp_kanal_id_22, t0.komp_art_id AS komp_art_id_23, t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24 FROM endo_therapie_bogen t0 WHERE t0.therapie_id = 0x92F0E16D6AD611EE9C53B42E996A43E7;