| 1 |
0.41 ms |
SELECT t0.titel AS titel_1, t0.kuerzel AS kuerzel_2, t0.img_logo AS img_logo_3, t0.adresse AS adresse_4, t0.visdp AS visdp_5, t0.rubriken AS rubriken_6, t0.zielgruppen AS zielgruppen_7, t0.twigListe AS twigListe_8, t0.twigDetail AS twigDetail_9, t0.ownTwigListe AS ownTwigListe_10, t0.ownTwigDetail AS ownTwigDetail_11, t0.dfxLess AS dfxLess_12, t0.dfxCss AS dfxCss_13, t0.ownCss AS ownCss_14, t0.ownLess AS ownLess_15, t0.lengthTeaser AS lengthTeaser_16, t0.maxLengthLead AS maxLengthLead_17, t0.maxLengthBeschreibung AS maxLengthBeschreibung_18, t0.itemsListe AS itemsListe_19, t0.dfxWidth AS dfxWidth_20, t0.dfxAlign AS dfxAlign_21, t0.imgWidth AS imgWidth_22, t0.imgHeight AS imgHeight_23, t0.imgPrevWidth AS imgPrevWidth_24, t0.imgPrevHeight AS imgPrevHeight_25, t0.imgLightboxWidth AS imgLightboxWidth_26, t0.imgLightboxHeight AS imgLightboxHeight_27, t0.navListe AS navListe_28, t0.navDetail AS navDetail_29, t0.navWidth AS navWidth_30, t0.archivTage AS archivTage_31, t0.navPos AS navPos_32, t0.filterKalender AS filterKalender_33, t0.filterRubrik AS filterRubrik_34, t0.filterZielgruppe AS filterZielgruppe_35, t0.filterDatum AS filterDatum_36, t0.filterSuche AS filterSuche_37, t0.filterNat AS filterNat_38, t0.filterPlzarea AS filterPlzarea_39, t0.filterUmkreis AS filterUmkreis_40, t0.filterOrt AS filterOrt_41, t0.filterRegion AS filterRegion_42, t0.filterLocation AS filterLocation_43, t0.filterVeranstalter AS filterVeranstalter_44, t0.filterDozenten AS filterDozenten_45, t0.feldSubtitel AS feldSubtitel_46, t0.feldLead AS feldLead_47, t0.feldBeschreibung AS feldBeschreibung_48, t0.feldEintritt AS feldEintritt_49, t0.feldImg AS feldImg_50, t0.feldGalerie AS feldGalerie_51, t0.feldVideo AS feldVideo_52, t0.imgListe AS imgListe_53, t0.feldPdf AS feldPdf_54, t0.feldMedia AS feldMedia_55, t0.feldNat AS feldNat_56, t0.feldRegion AS feldRegion_57, t0.feldPlz AS feldPlz_58, t0.feldOrt AS feldOrt_59, t0.feldOrtdb AS feldOrtdb_60, t0.feldKarten AS feldKarten_61, t0.feldAnmeldung AS feldAnmeldung_62, t0.feldPlatzlimit AS feldPlatzlimit_63, t0.showPlatzlimit AS showPlatzlimit_64, t0.feldLocation AS feldLocation_65, t0.feldVeranstalter AS feldVeranstalter_66, t0.feldDozenten AS feldDozenten_67, t0.feldLink AS feldLink_68, t0.feldTicketlink AS feldTicketlink_69, t0.feldOnlinetermin AS feldOnlinetermin_70, t0.showPlz AS showPlz_71, t0.showOrt AS showOrt_72, t0.showLokal AS showLokal_73, t0.showStrasse AS showStrasse_74, t0.allowInputAll AS allowInputAll_75, t0.allowPubAll AS allowPubAll_76, t0.allowPubMetaAll AS allowPubMetaAll_77, t0.allowPubGroupAll AS allowPubGroupAll_78, t0.PubMetaAll AS PubMetaAll_79, t0.PubGroupAll AS PubGroupAll_80, t0.InheritMeta AS InheritMeta_81, t0.InheritGroup AS InheritGroup_82, t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_83, t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_84, t0.infoToAdmin AS infoToAdmin_85, t0.sprache AS sprache_86, t0.allowSocial AS allowSocial_87, t0.allowRemind AS allowRemind_88, t0.allowMail AS allowMail_89, t0.allowExport AS allowExport_90, t0.allowPrint AS allowPrint_91, t0.useIcons AS useIcons_92, t0.useMap AS useMap_93, t0.useRss AS useRss_94, t0.dfxTpl AS dfxTpl_95, t0.dfxTplVersion AS dfxTplVersion_96, t0.dfxTplDetail AS dfxTplDetail_97, t0.zwueDatum AS zwueDatum_98, t0.dfxFarbe AS dfxFarbe_99, t0.dfxFarbeEigen AS dfxFarbeEigen_100, t0.dfxFarbeRaster AS dfxFarbeRaster_101, t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_102, t0.bgDatefix AS bgDatefix_103, t0.bgNav AS bgNav_104, t0.trennzeichen AS trennzeichen_105, t0.dfxFontType AS dfxFontType_106, t0.dfxFontSize AS dfxFontSize_107, t0.dfxFontColor AS dfxFontColor_108, t0.ownFont AS ownFont_109, t0.paginationTop AS paginationTop_110, t0.paginationBottom AS paginationBottom_111, t0.dfxRadius AS dfxRadius_112, t0.isMeta AS isMeta_113, t0.isGroup AS isGroup_114, t0.toGroup AS toGroup_115, t0.frontendUrl AS frontendUrl_116, t0.datenschutzUrl AS datenschutzUrl_117, t0.impressumUrl AS impressumUrl_118, t0.frontendZeichensatz AS frontendZeichensatz_119, t0.backendZeichensatz AS backendZeichensatz_120, t0.frontendDoctype AS frontendDoctype_121, t0.id AS id_122, t0.user_id AS user_id_123 FROM pool_dfx_konf t0 WHERE t0.id = ?
SELECT
t0.titel AS titel_1,
t0.kuerzel AS kuerzel_2,
t0.img_logo AS img_logo_3,
t0.adresse AS adresse_4,
t0.visdp AS visdp_5,
t0.rubriken AS rubriken_6,
t0.zielgruppen AS zielgruppen_7,
t0.twigListe AS twigListe_8,
t0.twigDetail AS twigDetail_9,
t0.ownTwigListe AS ownTwigListe_10,
t0.ownTwigDetail AS ownTwigDetail_11,
t0.dfxLess AS dfxLess_12,
t0.dfxCss AS dfxCss_13,
t0.ownCss AS ownCss_14,
t0.ownLess AS ownLess_15,
t0.lengthTeaser AS lengthTeaser_16,
t0.maxLengthLead AS maxLengthLead_17,
t0.maxLengthBeschreibung AS maxLengthBeschreibung_18,
t0.itemsListe AS itemsListe_19,
t0.dfxWidth AS dfxWidth_20,
t0.dfxAlign AS dfxAlign_21,
t0.imgWidth AS imgWidth_22,
t0.imgHeight AS imgHeight_23,
t0.imgPrevWidth AS imgPrevWidth_24,
t0.imgPrevHeight AS imgPrevHeight_25,
t0.imgLightboxWidth AS imgLightboxWidth_26,
t0.imgLightboxHeight AS imgLightboxHeight_27,
t0.navListe AS navListe_28,
t0.navDetail AS navDetail_29,
t0.navWidth AS navWidth_30,
t0.archivTage AS archivTage_31,
t0.navPos AS navPos_32,
t0.filterKalender AS filterKalender_33,
t0.filterRubrik AS filterRubrik_34,
t0.filterZielgruppe AS filterZielgruppe_35,
t0.filterDatum AS filterDatum_36,
t0.filterSuche AS filterSuche_37,
t0.filterNat AS filterNat_38,
t0.filterPlzarea AS filterPlzarea_39,
t0.filterUmkreis AS filterUmkreis_40,
t0.filterOrt AS filterOrt_41,
t0.filterRegion AS filterRegion_42,
t0.filterLocation AS filterLocation_43,
t0.filterVeranstalter AS filterVeranstalter_44,
t0.filterDozenten AS filterDozenten_45,
t0.feldSubtitel AS feldSubtitel_46,
t0.feldLead AS feldLead_47,
t0.feldBeschreibung AS feldBeschreibung_48,
t0.feldEintritt AS feldEintritt_49,
t0.feldImg AS feldImg_50,
t0.feldGalerie AS feldGalerie_51,
t0.feldVideo AS feldVideo_52,
t0.imgListe AS imgListe_53,
t0.feldPdf AS feldPdf_54,
t0.feldMedia AS feldMedia_55,
t0.feldNat AS feldNat_56,
t0.feldRegion AS feldRegion_57,
t0.feldPlz AS feldPlz_58,
t0.feldOrt AS feldOrt_59,
t0.feldOrtdb AS feldOrtdb_60,
t0.feldKarten AS feldKarten_61,
t0.feldAnmeldung AS feldAnmeldung_62,
t0.feldPlatzlimit AS feldPlatzlimit_63,
t0.showPlatzlimit AS showPlatzlimit_64,
t0.feldLocation AS feldLocation_65,
t0.feldVeranstalter AS feldVeranstalter_66,
t0.feldDozenten AS feldDozenten_67,
t0.feldLink AS feldLink_68,
t0.feldTicketlink AS feldTicketlink_69,
t0.feldOnlinetermin AS feldOnlinetermin_70,
t0.showPlz AS showPlz_71,
t0.showOrt AS showOrt_72,
t0.showLokal AS showLokal_73,
t0.showStrasse AS showStrasse_74,
t0.allowInputAll AS allowInputAll_75,
t0.allowPubAll AS allowPubAll_76,
t0.allowPubMetaAll AS allowPubMetaAll_77,
t0.allowPubGroupAll AS allowPubGroupAll_78,
t0.PubMetaAll AS PubMetaAll_79,
t0.PubGroupAll AS PubGroupAll_80,
t0.InheritMeta AS InheritMeta_81,
t0.InheritGroup AS InheritGroup_82,
t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_83,
t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_84,
t0.infoToAdmin AS infoToAdmin_85,
t0.sprache AS sprache_86,
t0.allowSocial AS allowSocial_87,
t0.allowRemind AS allowRemind_88,
t0.allowMail AS allowMail_89,
t0.allowExport AS allowExport_90,
t0.allowPrint AS allowPrint_91,
t0.useIcons AS useIcons_92,
t0.useMap AS useMap_93,
t0.useRss AS useRss_94,
t0.dfxTpl AS dfxTpl_95,
t0.dfxTplVersion AS dfxTplVersion_96,
t0.dfxTplDetail AS dfxTplDetail_97,
t0.zwueDatum AS zwueDatum_98,
t0.dfxFarbe AS dfxFarbe_99,
t0.dfxFarbeEigen AS dfxFarbeEigen_100,
t0.dfxFarbeRaster AS dfxFarbeRaster_101,
t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_102,
t0.bgDatefix AS bgDatefix_103,
t0.bgNav AS bgNav_104,
t0.trennzeichen AS trennzeichen_105,
t0.dfxFontType AS dfxFontType_106,
t0.dfxFontSize AS dfxFontSize_107,
t0.dfxFontColor AS dfxFontColor_108,
t0.ownFont AS ownFont_109,
t0.paginationTop AS paginationTop_110,
t0.paginationBottom AS paginationBottom_111,
t0.dfxRadius AS dfxRadius_112,
t0.isMeta AS isMeta_113,
t0.isGroup AS isGroup_114,
t0.toGroup AS toGroup_115,
t0.frontendUrl AS frontendUrl_116,
t0.datenschutzUrl AS datenschutzUrl_117,
t0.impressumUrl AS impressumUrl_118,
t0.frontendZeichensatz AS frontendZeichensatz_119,
t0.backendZeichensatz AS backendZeichensatz_120,
t0.frontendDoctype AS frontendDoctype_121,
t0.id AS id_122,
t0.user_id AS user_id_123
FROM
pool_dfx_konf t0
WHERE
t0.id = ?
SELECT t0.titel AS titel_1, t0.kuerzel AS kuerzel_2, t0.img_logo AS img_logo_3, t0.adresse AS adresse_4, t0.visdp AS visdp_5, t0.rubriken AS rubriken_6, t0.zielgruppen AS zielgruppen_7, t0.twigListe AS twigListe_8, t0.twigDetail AS twigDetail_9, t0.ownTwigListe AS ownTwigListe_10, t0.ownTwigDetail AS ownTwigDetail_11, t0.dfxLess AS dfxLess_12, t0.dfxCss AS dfxCss_13, t0.ownCss AS ownCss_14, t0.ownLess AS ownLess_15, t0.lengthTeaser AS lengthTeaser_16, t0.maxLengthLead AS maxLengthLead_17, t0.maxLengthBeschreibung AS maxLengthBeschreibung_18, t0.itemsListe AS itemsListe_19, t0.dfxWidth AS dfxWidth_20, t0.dfxAlign AS dfxAlign_21, t0.imgWidth AS imgWidth_22, t0.imgHeight AS imgHeight_23, t0.imgPrevWidth AS imgPrevWidth_24, t0.imgPrevHeight AS imgPrevHeight_25, t0.imgLightboxWidth AS imgLightboxWidth_26, t0.imgLightboxHeight AS imgLightboxHeight_27, t0.navListe AS navListe_28, t0.navDetail AS navDetail_29, t0.navWidth AS navWidth_30, t0.archivTage AS archivTage_31, t0.navPos AS navPos_32, t0.filterKalender AS filterKalender_33, t0.filterRubrik AS filterRubrik_34, t0.filterZielgruppe AS filterZielgruppe_35, t0.filterDatum AS filterDatum_36, t0.filterSuche AS filterSuche_37, t0.filterNat AS filterNat_38, t0.filterPlzarea AS filterPlzarea_39, t0.filterUmkreis AS filterUmkreis_40, t0.filterOrt AS filterOrt_41, t0.filterRegion AS filterRegion_42, t0.filterLocation AS filterLocation_43, t0.filterVeranstalter AS filterVeranstalter_44, t0.filterDozenten AS filterDozenten_45, t0.feldSubtitel AS feldSubtitel_46, t0.feldLead AS feldLead_47, t0.feldBeschreibung AS feldBeschreibung_48, t0.feldEintritt AS feldEintritt_49, t0.feldImg AS feldImg_50, t0.feldGalerie AS feldGalerie_51, t0.feldVideo AS feldVideo_52, t0.imgListe AS imgListe_53, t0.feldPdf AS feldPdf_54, t0.feldMedia AS feldMedia_55, t0.feldNat AS feldNat_56, t0.feldRegion AS feldRegion_57, t0.feldPlz AS feldPlz_58, t0.feldOrt AS feldOrt_59, t0.feldOrtdb AS feldOrtdb_60, t0.feldKarten AS feldKarten_61, t0.feldAnmeldung AS feldAnmeldung_62, t0.feldPlatzlimit AS feldPlatzlimit_63, t0.showPlatzlimit AS showPlatzlimit_64, t0.feldLocation AS feldLocation_65, t0.feldVeranstalter AS feldVeranstalter_66, t0.feldDozenten AS feldDozenten_67, t0.feldLink AS feldLink_68, t0.feldTicketlink AS feldTicketlink_69, t0.feldOnlinetermin AS feldOnlinetermin_70, t0.showPlz AS showPlz_71, t0.showOrt AS showOrt_72, t0.showLokal AS showLokal_73, t0.showStrasse AS showStrasse_74, t0.allowInputAll AS allowInputAll_75, t0.allowPubAll AS allowPubAll_76, t0.allowPubMetaAll AS allowPubMetaAll_77, t0.allowPubGroupAll AS allowPubGroupAll_78, t0.PubMetaAll AS PubMetaAll_79, t0.PubGroupAll AS PubGroupAll_80, t0.InheritMeta AS InheritMeta_81, t0.InheritGroup AS InheritGroup_82, t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_83, t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_84, t0.infoToAdmin AS infoToAdmin_85, t0.sprache AS sprache_86, t0.allowSocial AS allowSocial_87, t0.allowRemind AS allowRemind_88, t0.allowMail AS allowMail_89, t0.allowExport AS allowExport_90, t0.allowPrint AS allowPrint_91, t0.useIcons AS useIcons_92, t0.useMap AS useMap_93, t0.useRss AS useRss_94, t0.dfxTpl AS dfxTpl_95, t0.dfxTplVersion AS dfxTplVersion_96, t0.dfxTplDetail AS dfxTplDetail_97, t0.zwueDatum AS zwueDatum_98, t0.dfxFarbe AS dfxFarbe_99, t0.dfxFarbeEigen AS dfxFarbeEigen_100, t0.dfxFarbeRaster AS dfxFarbeRaster_101, t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_102, t0.bgDatefix AS bgDatefix_103, t0.bgNav AS bgNav_104, t0.trennzeichen AS trennzeichen_105, t0.dfxFontType AS dfxFontType_106, t0.dfxFontSize AS dfxFontSize_107, t0.dfxFontColor AS dfxFontColor_108, t0.ownFont AS ownFont_109, t0.paginationTop AS paginationTop_110, t0.paginationBottom AS paginationBottom_111, t0.dfxRadius AS dfxRadius_112, t0.isMeta AS isMeta_113, t0.isGroup AS isGroup_114, t0.toGroup AS toGroup_115, t0.frontendUrl AS frontendUrl_116, t0.datenschutzUrl AS datenschutzUrl_117, t0.impressumUrl AS impressumUrl_118, t0.frontendZeichensatz AS frontendZeichensatz_119, t0.backendZeichensatz AS backendZeichensatz_120, t0.frontendDoctype AS frontendDoctype_121, t0.id AS id_122, t0.user_id AS user_id_123 FROM pool_dfx_konf t0 WHERE t0.id = 1;
|
| 2 |
4.68 ms |
SELECT p0_.datum AS datum_0, p0_.datum_von AS datum_von_1, p0_.datumSerie AS datumSerie_2, p0_.zeit AS zeit_3, p0_.zeit_bis AS zeit_bis_4, p0_.nat AS nat_5, p0_.plz AS plz_6, p0_.ort AS ort_7, p0_.lokal AS lokal_8, p0_.lokal_strasse AS lokal_strasse_9, p0_.lg AS lg_10, p0_.bg AS bg_11, p0_.veranstalter AS veranstalter_12, p0_.eintritt AS eintritt_13, p0_.rubrik AS rubrik_14, p0_.zielgruppe AS zielgruppe_15, p0_.titel AS titel_16, p0_.subtitel AS subtitel_17, p0_.lead AS lead_18, p0_.beschreibung AS beschreibung_19, p0_.status AS status_20, p0_.link AS link_21, p0_.linktext AS linktext_22, p0_.ticketlink AS ticketlink_23, p0_.ticketlinktext AS ticketlinktext_24, p0_.konferenzlink AS konferenzlink_25, p0_.konferenzlinktext AS konferenzlinktext_26, p0_.pdf AS pdf_27, p0_.pdfSerie AS pdfSerie_28, p0_.pdflinktext AS pdflinktext_29, p0_.media AS media_30, p0_.mediaSerie AS mediaSerie_31, p0_.medialinktext AS medialinktext_32, p0_.mediatyp AS mediatyp_33, p0_.img AS img_34, p0_.imgSerie AS imgSerie_35, p0_.img2 AS img2_36, p0_.imgSerie2 AS imgSerie2_37, p0_.img3 AS img3_38, p0_.imgSerie3 AS imgSerie3_39, p0_.img4 AS img4_40, p0_.imgSerie4 AS imgSerie4_41, p0_.img5 AS img5_42, p0_.imgSerie5 AS imgSerie5_43, p0_.imgtext AS imgtext_44, p0_.imgcopyright AS imgcopyright_45, p0_.imgcopycheck AS imgcopycheck_46, p0_.imgtext2 AS imgtext2_47, p0_.imgcopyright2 AS imgcopyright2_48, p0_.imgcopycheck2 AS imgcopycheck2_49, p0_.video AS video_50, p0_.mail AS mail_51, p0_.mail_typ AS mail_typ_52, p0_.pub AS pub_53, p0_.pub_meta AS pub_meta_54, p0_.pub_group AS pub_group_55, p0_.code AS code_56, p0_.init AS init_57, p0_.autor AS autor_58, p0_.online AS online_59, p0_.counter AS counter_60, p0_.nl AS nl_61, p0_.nl_sent AS nl_sent_62, p0_.serie AS serie_63, p0_.plaetze_gesamt AS plaetze_gesamt_64, p0_.plaetze_aktuell AS plaetze_aktuell_65, p0_.karten_tpl AS karten_tpl_66, p0_.karten_kat AS karten_kat_67, p0_.anmeldeschluss AS anmeldeschluss_68, p0_.archiv AS archiv_69, p0_.exportflag AS exportflag_70, p0_.filter_1 AS filter_1_71, p0_.filter_2 AS filter_2_72, p0_.filter_3 AS filter_3_73, p0_.filter_4 AS filter_4_74, p0_.filter_5 AS filter_5_75, p0_.filter_6 AS filter_6_76, p0_.filter_7 AS filter_7_77, p0_.filter_8 AS filter_8_78, p0_.filter_9 AS filter_9_79, p0_.filter_10 AS filter_10_80, p0_.filter_11 AS filter_11_81, p0_.filter_12 AS filter_12_82, p0_.filter_13 AS filter_13_83, p0_.filter_14 AS filter_14_84, p0_.filter_15 AS filter_15_85, p0_.text_1 AS text_1_86, p0_.text_2 AS text_2_87, p0_.text_3 AS text_3_88, p0_.text_4 AS text_4_89, p0_.text_5 AS text_5_90, p0_.text_6 AS text_6_91, p0_.text_7 AS text_7_92, p0_.text_8 AS text_8_93, p0_.text_9 AS text_9_94, p0_.text_10 AS text_10_95, p0_.textbox_1 AS textbox_1_96, p0_.textbox_2 AS textbox_2_97, p0_.options_radio AS options_radio_98, p0_.options_menue AS options_menue_99, p0_.options_checkboxes AS options_checkboxes_100, p0_.options_menue_multi AS options_menue_multi_101, p0_.datum_3 AS datum_3_102, p0_.datenschutz AS datenschutz_103, p0_.datum_input AS datum_input_104, p0_.datum_modified AS datum_modified_105, p0_.id AS id_106, p0_.user_id AS user_id_107, p0_.id_location AS id_location_108, p0_.id_veranstalter AS id_veranstalter_109, p0_.id_ort AS id_ort_110, p0_.id_region AS id_region_111, p0_.kalender_id AS kalender_id_112 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id IN (?) AND p0_.pub = 1 AND p0_.datum >= CURRENT_DATE ORDER BY p0_.datum_von ASC, p0_.zeit ASC
SELECT
p0_.datum AS datum_0,
p0_.datum_von AS datum_von_1,
p0_.datumSerie AS datumSerie_2,
p0_.zeit AS zeit_3,
p0_.zeit_bis AS zeit_bis_4,
p0_.nat AS nat_5,
p0_.plz AS plz_6,
p0_.ort AS ort_7,
p0_.lokal AS lokal_8,
p0_.lokal_strasse AS lokal_strasse_9,
p0_.lg AS lg_10,
p0_.bg AS bg_11,
p0_.veranstalter AS veranstalter_12,
p0_.eintritt AS eintritt_13,
p0_.rubrik AS rubrik_14,
p0_.zielgruppe AS zielgruppe_15,
p0_.titel AS titel_16,
p0_.subtitel AS subtitel_17,
p0_.lead AS lead_18,
p0_.beschreibung AS beschreibung_19,
p0_.status AS status_20,
p0_.link AS link_21,
p0_.linktext AS linktext_22,
p0_.ticketlink AS ticketlink_23,
p0_.ticketlinktext AS ticketlinktext_24,
p0_.konferenzlink AS konferenzlink_25,
p0_.konferenzlinktext AS konferenzlinktext_26,
p0_.pdf AS pdf_27,
p0_.pdfSerie AS pdfSerie_28,
p0_.pdflinktext AS pdflinktext_29,
p0_.media AS media_30,
p0_.mediaSerie AS mediaSerie_31,
p0_.medialinktext AS medialinktext_32,
p0_.mediatyp AS mediatyp_33,
p0_.img AS img_34,
p0_.imgSerie AS imgSerie_35,
p0_.img2 AS img2_36,
p0_.imgSerie2 AS imgSerie2_37,
p0_.img3 AS img3_38,
p0_.imgSerie3 AS imgSerie3_39,
p0_.img4 AS img4_40,
p0_.imgSerie4 AS imgSerie4_41,
p0_.img5 AS img5_42,
p0_.imgSerie5 AS imgSerie5_43,
p0_.imgtext AS imgtext_44,
p0_.imgcopyright AS imgcopyright_45,
p0_.imgcopycheck AS imgcopycheck_46,
p0_.imgtext2 AS imgtext2_47,
p0_.imgcopyright2 AS imgcopyright2_48,
p0_.imgcopycheck2 AS imgcopycheck2_49,
p0_.video AS video_50,
p0_.mail AS mail_51,
p0_.mail_typ AS mail_typ_52,
p0_.pub AS pub_53,
p0_.pub_meta AS pub_meta_54,
p0_.pub_group AS pub_group_55,
p0_.code AS code_56,
p0_.init AS init_57,
p0_.autor AS autor_58,
p0_.online AS online_59,
p0_.counter AS counter_60,
p0_.nl AS nl_61,
p0_.nl_sent AS nl_sent_62,
p0_.serie AS serie_63,
p0_.plaetze_gesamt AS plaetze_gesamt_64,
p0_.plaetze_aktuell AS plaetze_aktuell_65,
p0_.karten_tpl AS karten_tpl_66,
p0_.karten_kat AS karten_kat_67,
p0_.anmeldeschluss AS anmeldeschluss_68,
p0_.archiv AS archiv_69,
p0_.exportflag AS exportflag_70,
p0_.filter_1 AS filter_1_71,
p0_.filter_2 AS filter_2_72,
p0_.filter_3 AS filter_3_73,
p0_.filter_4 AS filter_4_74,
p0_.filter_5 AS filter_5_75,
p0_.filter_6 AS filter_6_76,
p0_.filter_7 AS filter_7_77,
p0_.filter_8 AS filter_8_78,
p0_.filter_9 AS filter_9_79,
p0_.filter_10 AS filter_10_80,
p0_.filter_11 AS filter_11_81,
p0_.filter_12 AS filter_12_82,
p0_.filter_13 AS filter_13_83,
p0_.filter_14 AS filter_14_84,
p0_.filter_15 AS filter_15_85,
p0_.text_1 AS text_1_86,
p0_.text_2 AS text_2_87,
p0_.text_3 AS text_3_88,
p0_.text_4 AS text_4_89,
p0_.text_5 AS text_5_90,
p0_.text_6 AS text_6_91,
p0_.text_7 AS text_7_92,
p0_.text_8 AS text_8_93,
p0_.text_9 AS text_9_94,
p0_.text_10 AS text_10_95,
p0_.textbox_1 AS textbox_1_96,
p0_.textbox_2 AS textbox_2_97,
p0_.options_radio AS options_radio_98,
p0_.options_menue AS options_menue_99,
p0_.options_checkboxes AS options_checkboxes_100,
p0_.options_menue_multi AS options_menue_multi_101,
p0_.datum_3 AS datum_3_102,
p0_.datenschutz AS datenschutz_103,
p0_.datum_input AS datum_input_104,
p0_.datum_modified AS datum_modified_105,
p0_.id AS id_106,
p0_.user_id AS user_id_107,
p0_.id_location AS id_location_108,
p0_.id_veranstalter AS id_veranstalter_109,
p0_.id_ort AS id_ort_110,
p0_.id_region AS id_region_111,
p0_.kalender_id AS kalender_id_112
FROM
pool_dfx_termine p0_
WHERE
p0_.kalender_id IN (?)
AND p0_.pub = 1
AND p0_.datum >= CURRENT_DATE
ORDER BY
p0_.datum_von ASC,
p0_.zeit ASC
SELECT p0_.datum AS datum_0, p0_.datum_von AS datum_von_1, p0_.datumSerie AS datumSerie_2, p0_.zeit AS zeit_3, p0_.zeit_bis AS zeit_bis_4, p0_.nat AS nat_5, p0_.plz AS plz_6, p0_.ort AS ort_7, p0_.lokal AS lokal_8, p0_.lokal_strasse AS lokal_strasse_9, p0_.lg AS lg_10, p0_.bg AS bg_11, p0_.veranstalter AS veranstalter_12, p0_.eintritt AS eintritt_13, p0_.rubrik AS rubrik_14, p0_.zielgruppe AS zielgruppe_15, p0_.titel AS titel_16, p0_.subtitel AS subtitel_17, p0_.lead AS lead_18, p0_.beschreibung AS beschreibung_19, p0_.status AS status_20, p0_.link AS link_21, p0_.linktext AS linktext_22, p0_.ticketlink AS ticketlink_23, p0_.ticketlinktext AS ticketlinktext_24, p0_.konferenzlink AS konferenzlink_25, p0_.konferenzlinktext AS konferenzlinktext_26, p0_.pdf AS pdf_27, p0_.pdfSerie AS pdfSerie_28, p0_.pdflinktext AS pdflinktext_29, p0_.media AS media_30, p0_.mediaSerie AS mediaSerie_31, p0_.medialinktext AS medialinktext_32, p0_.mediatyp AS mediatyp_33, p0_.img AS img_34, p0_.imgSerie AS imgSerie_35, p0_.img2 AS img2_36, p0_.imgSerie2 AS imgSerie2_37, p0_.img3 AS img3_38, p0_.imgSerie3 AS imgSerie3_39, p0_.img4 AS img4_40, p0_.imgSerie4 AS imgSerie4_41, p0_.img5 AS img5_42, p0_.imgSerie5 AS imgSerie5_43, p0_.imgtext AS imgtext_44, p0_.imgcopyright AS imgcopyright_45, p0_.imgcopycheck AS imgcopycheck_46, p0_.imgtext2 AS imgtext2_47, p0_.imgcopyright2 AS imgcopyright2_48, p0_.imgcopycheck2 AS imgcopycheck2_49, p0_.video AS video_50, p0_.mail AS mail_51, p0_.mail_typ AS mail_typ_52, p0_.pub AS pub_53, p0_.pub_meta AS pub_meta_54, p0_.pub_group AS pub_group_55, p0_.code AS code_56, p0_.init AS init_57, p0_.autor AS autor_58, p0_.online AS online_59, p0_.counter AS counter_60, p0_.nl AS nl_61, p0_.nl_sent AS nl_sent_62, p0_.serie AS serie_63, p0_.plaetze_gesamt AS plaetze_gesamt_64, p0_.plaetze_aktuell AS plaetze_aktuell_65, p0_.karten_tpl AS karten_tpl_66, p0_.karten_kat AS karten_kat_67, p0_.anmeldeschluss AS anmeldeschluss_68, p0_.archiv AS archiv_69, p0_.exportflag AS exportflag_70, p0_.filter_1 AS filter_1_71, p0_.filter_2 AS filter_2_72, p0_.filter_3 AS filter_3_73, p0_.filter_4 AS filter_4_74, p0_.filter_5 AS filter_5_75, p0_.filter_6 AS filter_6_76, p0_.filter_7 AS filter_7_77, p0_.filter_8 AS filter_8_78, p0_.filter_9 AS filter_9_79, p0_.filter_10 AS filter_10_80, p0_.filter_11 AS filter_11_81, p0_.filter_12 AS filter_12_82, p0_.filter_13 AS filter_13_83, p0_.filter_14 AS filter_14_84, p0_.filter_15 AS filter_15_85, p0_.text_1 AS text_1_86, p0_.text_2 AS text_2_87, p0_.text_3 AS text_3_88, p0_.text_4 AS text_4_89, p0_.text_5 AS text_5_90, p0_.text_6 AS text_6_91, p0_.text_7 AS text_7_92, p0_.text_8 AS text_8_93, p0_.text_9 AS text_9_94, p0_.text_10 AS text_10_95, p0_.textbox_1 AS textbox_1_96, p0_.textbox_2 AS textbox_2_97, p0_.options_radio AS options_radio_98, p0_.options_menue AS options_menue_99, p0_.options_checkboxes AS options_checkboxes_100, p0_.options_menue_multi AS options_menue_multi_101, p0_.datum_3 AS datum_3_102, p0_.datenschutz AS datenschutz_103, p0_.datum_input AS datum_input_104, p0_.datum_modified AS datum_modified_105, p0_.id AS id_106, p0_.user_id AS user_id_107, p0_.id_location AS id_location_108, p0_.id_veranstalter AS id_veranstalter_109, p0_.id_ort AS id_ort_110, p0_.id_region AS id_region_111, p0_.kalender_id AS kalender_id_112 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id IN (1) AND p0_.pub = 1 AND p0_.datum >= CURRENT_DATE ORDER BY p0_.datum_von ASC, p0_.zeit ASC;
|