| 1 |
7.69 ms |
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.tags LIKE ? AND s0_.startDate >= ? ORDER BY s0_.startDate ASC
Parameters: [
"%#kommunikation%"
"2026-06-11"
]
SELECT
s0_.id AS id_0,
s0_.eventbriteId AS eventbriteId_1,
s0_.googleCalendarEventId AS googleCalendarEventId_2,
s0_.wpPostId AS wpPostId_3,
s0_.title AS title_4,
s0_.title_en AS title_en_5,
s0_.slug AS slug_6,
s0_.lang AS lang_7,
s0_.imagelink AS imagelink_8,
s0_.videolink AS videolink_9,
s0_.bgImagelink AS bgImagelink_10,
s0_.tagline AS tagline_11,
s0_.headerTextColor AS headerTextColor_12,
s0_.spResponsiblePerson AS spResponsiblePerson_13,
s0_.organization AS organization_14,
s0_.organizerName AS organizerName_15,
s0_.organizerEmail AS organizerEmail_16,
s0_.venueName AS venueName_17,
s0_.venueAddress AS venueAddress_18,
s0_.showFullVenue AS showFullVenue_19,
s0_.ticketing AS ticketing_20,
s0_.applicationUrl AS applicationUrl_21,
s0_.alert AS alert_22,
s0_.trainer AS trainer_23,
s0_.speakers AS speakers_24,
s0_.teaser AS teaser_25,
s0_.navbar AS navbar_26,
s0_.stripePriceId AS stripePriceId_27,
s0_.stripeProductId AS stripeProductId_28,
s0_.stripeAccount AS stripeAccount_29,
s0_.priceInEuroCent AS priceInEuroCent_30,
s0_.isTaxIncluded AS isTaxIncluded_31,
s0_.isFreeForKiCampus AS isFreeForKiCampus_32,
s0_.isFreeForCommunity AS isFreeForCommunity_33,
s0_.isSinglePage AS isSinglePage_34,
s0_.isFormalLanguage AS isFormalLanguage_35,
s0_.isMultiBatchEvent AS isMultiBatchEvent_36,
s0_.isFeatured AS isFeatured_37,
s0_.capacity AS capacity_38,
s0_.targetCapacity AS targetCapacity_39,
s0_.twigFile AS twigFile_40,
s0_.additionalCss AS additionalCss_41,
s0_.content AS content_42,
s0_.contentTwig AS contentTwig_43,
s0_.ctaContent AS ctaContent_44,
s0_.postCtaContent AS postCtaContent_45,
s0_.tags AS tags_46,
s0_.seriesTag AS seriesTag_47,
s0_.feedbackFormId AS feedbackFormId_48,
s0_.type AS type_49,
s0_.location AS location_50,
s0_.startDate AS startDate_51,
s0_.endDate AS endDate_52,
s0_.duration AS duration_53,
s0_.status AS status_54,
s0_.settings AS settings_55,
s0_.displayStartDate AS displayStartDate_56,
s0_.seoTitle AS seoTitle_57,
s0_.seoKeyword AS seoKeyword_58,
s0_.seoDescription AS seoDescription_59,
s0_.navbar_en AS navbar_en_60,
s0_.teaser_en AS teaser_en_61,
s0_.content_en AS content_en_62,
s0_.content_twig_en AS content_twig_en_63,
s0_.post_cta_content_en AS post_cta_content_en_64,
s0_.seo_title_en AS seo_title_en_65,
s0_.seo_description_en AS seo_description_en_66,
s0_.seo_keyword_en AS seo_keyword_en_67,
s0_.has_english_version AS has_english_version_68,
s0_.additional_js AS additional_js_69,
s0_.metaPixelId AS metaPixelId_70,
s0_.createDate AS createDate_71,
s0_.lastChangeDate AS lastChangeDate_72,
s0_.lastChangeUser AS lastChangeUser_73,
s0_.publicId AS publicId_74,
s0_.isExternalSubmission AS isExternalSubmission_75,
s0_.createdBy AS createdBy_76,
s0_.lastModified AS lastModified_77,
s0_.createdAt AS createdAt_78,
s0_.orgaNote AS orgaNote_79,
s0_.calendarSyncedAt AS calendarSyncedAt_80,
s0_.logisticsRoom AS logisticsRoom_81,
s0_.logisticsCatering AS logisticsCatering_82,
s0_.logisticsEquipment AS logisticsEquipment_83,
s0_.logisticsHelpers AS logisticsHelpers_84,
s0_.history AS history_85,
s0_.todoHistory AS todoHistory_86
FROM
sp_event_events s0_
WHERE
s0_.tags LIKE ?
AND s0_.startDate >= ?
ORDER BY
s0_.startDate ASC
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.tags LIKE '%#kommunikation%' AND s0_.startDate >= '2026-06-11' ORDER BY s0_.startDate ASC;
|