Symfony Profiler

(
  SELECT
    e.*,
    NULL as nextBatchId,
    NULL as nextBatchName,
    e.startDate as nextBatchDate,
    e.endDate as nextBatchEndDate,
    COALESCE(
      (
        SELECT
          b2.priceInEuroCent
        FROM
          sp_event_dates b2
        WHERE
          b2.eventId = e.id
        ORDER BY
          b2.id DESC
        LIMIT
          1
      ), e.priceInEuroCent
    ) as displayPrice,
    e.isFreeForKICampus as displayFreeForKiCampus,
    NULL as batchTopic,
    NULL as batchImageLink,
    NULL as batchPartnerDescription
  FROM
    sp_event_events e
  WHERE
    e.status = 'publish'
    AND e.tags LIKE :queryString
    AND e.isMultiBatchEvent = 0
    AND COALESCE(e.endDate, e.startDate) < CURDATE()
    AND COALESCE(e.endDate, e.startDate) >= :pastWindowStart
)
UNION ALL
  (
    SELECT
      e.*,
      b.id as nextBatchId,
      b.name as nextBatchName,
      b.startDate as nextBatchDate,
      b.endDate as nextBatchEndDate,
      COALESCE(
        b.priceInEuroCent, e.priceInEuroCent
      ) as displayPrice,
      b.isFreeForKiCampus as displayFreeForKiCampus,
      COALESCE(
        NULLIF(b.title, ''),
        e.title
      ) as batchTopic,
      COALESCE(
        NULLIF(b.imagelink, ''),
        e.imagelink
      ) as batchImageLink,
      COALESCE(
        NULLIF(b.trainer, ''),
        e.trainer
      ) as batchPartnerDescription
    FROM
      sp_event_events e
      INNER JOIN sp_event_dates b ON e.id = b.eventId
    WHERE
      e.status = 'publish'
      AND e.tags LIKE :queryString
      AND e.isMultiBatchEvent = 1
      AND b.status = 'active'
      AND COALESCE(b.endDate, b.startDate) < CURDATE()
      AND COALESCE(b.endDate, b.startDate) >= :pastWindowStart
  )
ORDER BY
  nextBatchDate DESC
LIMIT
  :limit

(
                SELECT
                    e.*,
                    NULL as nextBatchId,
                    NULL as nextBatchName,
                    e.startDate as nextBatchDate,
                    e.endDate as nextBatchEndDate,
                    COALESCE((SELECT b2.priceInEuroCent FROM sp_event_dates b2 WHERE b2.eventId = e.id ORDER BY b2.id DESC LIMIT 1), e.priceInEuroCent) as displayPrice,
                    e.isFreeForKICampus as displayFreeForKiCampus,
                    NULL as batchTopic,
                    NULL as batchImageLink,
                    NULL as batchPartnerDescription
                FROM sp_event_events e
                WHERE e.status = 'publish' AND e.tags LIKE '%#datenschutz%'
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) < CURDATE() AND COALESCE(e.endDate, e.startDate) >= '2026-07-01'
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    b.startDate as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    COALESCE(b.priceInEuroCent, e.priceInEuroCent) as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.title, ''), e.title) as batchTopic,
                    COALESCE(NULLIF(b.imagelink, ''), e.imagelink) as batchImageLink,
                    COALESCE(NULLIF(b.trainer, ''), e.trainer) as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_event_dates b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.tags LIKE '%#datenschutz%'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.endDate, b.startDate) < CURDATE() AND COALESCE(b.endDate, b.startDate) >= '2026-07-01'
            )
            ORDER BY nextBatchDate DESC
            LIMIT 900
        ;

(
  SELECT
    e.*,
    NULL as nextBatchId,
    NULL as nextBatchName,
    e.startDate as nextBatchDate,
    e.endDate as nextBatchEndDate,
    COALESCE(
      (
        SELECT
          b2.priceInEuroCent
        FROM
          sp_event_dates b2
        WHERE
          b2.eventId = e.id
        ORDER BY
          b2.id DESC
        LIMIT
          1
      ), e.priceInEuroCent
    ) as displayPrice,
    e.isFreeForKICampus as displayFreeForKiCampus,
    NULL as batchTopic,
    NULL as batchImageLink,
    NULL as batchPartnerDescription
  FROM
    sp_event_events e
  WHERE
    e.status = 'publish'
    AND e.tags LIKE :queryString
    AND e.isMultiBatchEvent = 0
    AND COALESCE(e.endDate, e.startDate) >= CURDATE()
)
UNION ALL
  (
    SELECT
      e.*,
      b.id as nextBatchId,
      b.name as nextBatchName,
      b.startDate as nextBatchDate,
      b.endDate as nextBatchEndDate,
      COALESCE(
        b.priceInEuroCent, e.priceInEuroCent
      ) as displayPrice,
      b.isFreeForKiCampus as displayFreeForKiCampus,
      COALESCE(
        NULLIF(b.title, ''),
        e.title
      ) as batchTopic,
      COALESCE(
        NULLIF(b.imagelink, ''),
        e.imagelink
      ) as batchImageLink,
      COALESCE(
        NULLIF(b.trainer, ''),
        e.trainer
      ) as batchPartnerDescription
    FROM
      sp_event_events e
      INNER JOIN sp_event_dates b ON e.id = b.eventId
    WHERE
      e.status = 'publish'
      AND e.tags LIKE :queryString
      AND e.isMultiBatchEvent = 1
      AND b.status = 'active'
      AND b.startDate >= CURDATE()
  )
ORDER BY
  nextBatchDate ASC
LIMIT
  :limit

(
                SELECT
                    e.*,
                    NULL as nextBatchId,
                    NULL as nextBatchName,
                    e.startDate as nextBatchDate,
                    e.endDate as nextBatchEndDate,
                    COALESCE((SELECT b2.priceInEuroCent FROM sp_event_dates b2 WHERE b2.eventId = e.id ORDER BY b2.id DESC LIMIT 1), e.priceInEuroCent) as displayPrice,
                    e.isFreeForKICampus as displayFreeForKiCampus,
                    NULL as batchTopic,
                    NULL as batchImageLink,
                    NULL as batchPartnerDescription
                FROM sp_event_events e
                WHERE e.status = 'publish' AND e.tags LIKE '%#datenschutz%'
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) >= CURDATE()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    b.startDate as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    COALESCE(b.priceInEuroCent, e.priceInEuroCent) as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.title, ''), e.title) as batchTopic,
                    COALESCE(NULLIF(b.imagelink, ''), e.imagelink) as batchImageLink,
                    COALESCE(NULLIF(b.trainer, ''), e.trainer) as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_event_dates b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.tags LIKE '%#datenschutz%'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND b.startDate >= CURDATE()
            )
            ORDER BY nextBatchDate ASC
            LIMIT 900
        ;

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_.isFlagship AS isFlagship_38,
  s0_.capacity AS capacity_39,
  s0_.targetCapacity AS targetCapacity_40,
  s0_.twigFile AS twigFile_41,
  s0_.additionalCss AS additionalCss_42,
  s0_.content AS content_43,
  s0_.contentTwig AS contentTwig_44,
  s0_.content_blocks AS content_blocks_45,
  s0_.content_blocks_en AS content_blocks_en_46,
  s0_.ctaContent AS ctaContent_47,
  s0_.postCtaContent AS postCtaContent_48,
  s0_.tags AS tags_49,
  s0_.seriesTag AS seriesTag_50,
  s0_.feedbackFormId AS feedbackFormId_51,
  s0_.type AS type_52,
  s0_.location AS location_53,
  s0_.startDate AS startDate_54,
  s0_.endDate AS endDate_55,
  s0_.duration AS duration_56,
  s0_.status AS status_57,
  s0_.publishedAt AS publishedAt_58,
  s0_.publishedBy AS publishedBy_59,
  s0_.settings AS settings_60,
  s0_.displayStartDate AS displayStartDate_61,
  s0_.seoTitle AS seoTitle_62,
  s0_.seoKeyword AS seoKeyword_63,
  s0_.seoDescription AS seoDescription_64,
  s0_.navbar_en AS navbar_en_65,
  s0_.teaser_en AS teaser_en_66,
  s0_.content_en AS content_en_67,
  s0_.content_twig_en AS content_twig_en_68,
  s0_.post_cta_content_en AS post_cta_content_en_69,
  s0_.seo_title_en AS seo_title_en_70,
  s0_.seo_description_en AS seo_description_en_71,
  s0_.seo_keyword_en AS seo_keyword_en_72,
  s0_.has_english_version AS has_english_version_73,
  s0_.additional_js AS additional_js_74,
  s0_.metaPixelId AS metaPixelId_75,
  s0_.createDate AS createDate_76,
  s0_.lastChangeDate AS lastChangeDate_77,
  s0_.lastChangeUser AS lastChangeUser_78,
  s0_.publicId AS publicId_79,
  s0_.isExternalSubmission AS isExternalSubmission_80,
  s0_.createdBy AS createdBy_81,
  s0_.lastModified AS lastModified_82,
  s0_.createdAt AS createdAt_83,
  s0_.orgaNote AS orgaNote_84,
  s0_.calendarSyncedAt AS calendarSyncedAt_85,
  s0_.logisticsRoom AS logisticsRoom_86,
  s0_.logisticsCatering AS logisticsCatering_87,
  s0_.logisticsEquipment AS logisticsEquipment_88,
  s0_.logisticsHelpers AS logisticsHelpers_89,
  s0_.history AS history_90,
  s0_.todoHistory AS todoHistory_91
FROM
  sp_event_events s0_
WHERE
  s0_.startDate >= ?
  AND s0_.status = 'publish'
  AND s0_.status = 'publish'
ORDER BY
  s0_.startDate ASC
LIMIT
  100

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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.startDate >= '2026-08-07' AND s0_.status = 'publish' AND s0_.status = 'publish' ORDER BY s0_.startDate ASC LIMIT 100;

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_.isFlagship AS isFlagship_38,
  s0_.capacity AS capacity_39,
  s0_.targetCapacity AS targetCapacity_40,
  s0_.twigFile AS twigFile_41,
  s0_.additionalCss AS additionalCss_42,
  s0_.content AS content_43,
  s0_.contentTwig AS contentTwig_44,
  s0_.content_blocks AS content_blocks_45,
  s0_.content_blocks_en AS content_blocks_en_46,
  s0_.ctaContent AS ctaContent_47,
  s0_.postCtaContent AS postCtaContent_48,
  s0_.tags AS tags_49,
  s0_.seriesTag AS seriesTag_50,
  s0_.feedbackFormId AS feedbackFormId_51,
  s0_.type AS type_52,
  s0_.location AS location_53,
  s0_.startDate AS startDate_54,
  s0_.endDate AS endDate_55,
  s0_.duration AS duration_56,
  s0_.status AS status_57,
  s0_.publishedAt AS publishedAt_58,
  s0_.publishedBy AS publishedBy_59,
  s0_.settings AS settings_60,
  s0_.displayStartDate AS displayStartDate_61,
  s0_.seoTitle AS seoTitle_62,
  s0_.seoKeyword AS seoKeyword_63,
  s0_.seoDescription AS seoDescription_64,
  s0_.navbar_en AS navbar_en_65,
  s0_.teaser_en AS teaser_en_66,
  s0_.content_en AS content_en_67,
  s0_.content_twig_en AS content_twig_en_68,
  s0_.post_cta_content_en AS post_cta_content_en_69,
  s0_.seo_title_en AS seo_title_en_70,
  s0_.seo_description_en AS seo_description_en_71,
  s0_.seo_keyword_en AS seo_keyword_en_72,
  s0_.has_english_version AS has_english_version_73,
  s0_.additional_js AS additional_js_74,
  s0_.metaPixelId AS metaPixelId_75,
  s0_.createDate AS createDate_76,
  s0_.lastChangeDate AS lastChangeDate_77,
  s0_.lastChangeUser AS lastChangeUser_78,
  s0_.publicId AS publicId_79,
  s0_.isExternalSubmission AS isExternalSubmission_80,
  s0_.createdBy AS createdBy_81,
  s0_.lastModified AS lastModified_82,
  s0_.createdAt AS createdAt_83,
  s0_.orgaNote AS orgaNote_84,
  s0_.calendarSyncedAt AS calendarSyncedAt_85,
  s0_.logisticsRoom AS logisticsRoom_86,
  s0_.logisticsCatering AS logisticsCatering_87,
  s0_.logisticsEquipment AS logisticsEquipment_88,
  s0_.logisticsHelpers AS logisticsHelpers_89,
  s0_.history AS history_90,
  s0_.todoHistory AS todoHistory_91
FROM
  sp_event_events s0_
WHERE
  s0_.status = 'publish'
  AND s0_.startDate >= ?
  AND s0_.type = ?
ORDER BY
  s0_.startDate ASC
LIMIT
  1

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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.status = 'publish' AND s0_.startDate >= '2026-08-07' AND s0_.type = 'Konferenz' ORDER BY s0_.startDate ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.eventbriteId AS eventbriteId_2,
  t0.googleCalendarEventId AS googleCalendarEventId_3,
  t0.wpPostId AS wpPostId_4,
  t0.title AS title_5,
  t0.title_en AS title_en_6,
  t0.slug AS slug_7,
  t0.lang AS lang_8,
  t0.imagelink AS imagelink_9,
  t0.videolink AS videolink_10,
  t0.bgImagelink AS bgImagelink_11,
  t0.tagline AS tagline_12,
  t0.headerTextColor AS headerTextColor_13,
  t0.spResponsiblePerson AS spResponsiblePerson_14,
  t0.organization AS organization_15,
  t0.organizerName AS organizerName_16,
  t0.organizerEmail AS organizerEmail_17,
  t0.venueName AS venueName_18,
  t0.venueAddress AS venueAddress_19,
  t0.showFullVenue AS showFullVenue_20,
  t0.ticketing AS ticketing_21,
  t0.applicationUrl AS applicationUrl_22,
  t0.alert AS alert_23,
  t0.trainer AS trainer_24,
  t0.speakers AS speakers_25,
  t0.teaser AS teaser_26,
  t0.navbar AS navbar_27,
  t0.stripePriceId AS stripePriceId_28,
  t0.stripeProductId AS stripeProductId_29,
  t0.stripeAccount AS stripeAccount_30,
  t0.priceInEuroCent AS priceInEuroCent_31,
  t0.isTaxIncluded AS isTaxIncluded_32,
  t0.isFreeForKiCampus AS isFreeForKiCampus_33,
  t0.isFreeForCommunity AS isFreeForCommunity_34,
  t0.isSinglePage AS isSinglePage_35,
  t0.isFormalLanguage AS isFormalLanguage_36,
  t0.isMultiBatchEvent AS isMultiBatchEvent_37,
  t0.isFeatured AS isFeatured_38,
  t0.isFlagship AS isFlagship_39,
  t0.capacity AS capacity_40,
  t0.targetCapacity AS targetCapacity_41,
  t0.twigFile AS twigFile_42,
  t0.additionalCss AS additionalCss_43,
  t0.content AS content_44,
  t0.contentTwig AS contentTwig_45,
  t0.content_blocks AS content_blocks_46,
  t0.content_blocks_en AS content_blocks_en_47,
  t0.ctaContent AS ctaContent_48,
  t0.postCtaContent AS postCtaContent_49,
  t0.tags AS tags_50,
  t0.seriesTag AS seriesTag_51,
  t0.feedbackFormId AS feedbackFormId_52,
  t0.type AS type_53,
  t0.location AS location_54,
  t0.startDate AS startDate_55,
  t0.endDate AS endDate_56,
  t0.duration AS duration_57,
  t0.status AS status_58,
  t0.publishedAt AS publishedAt_59,
  t0.publishedBy AS publishedBy_60,
  t0.settings AS settings_61,
  t0.displayStartDate AS displayStartDate_62,
  t0.seoTitle AS seoTitle_63,
  t0.seoKeyword AS seoKeyword_64,
  t0.seoDescription AS seoDescription_65,
  t0.navbar_en AS navbar_en_66,
  t0.teaser_en AS teaser_en_67,
  t0.content_en AS content_en_68,
  t0.content_twig_en AS content_twig_en_69,
  t0.post_cta_content_en AS post_cta_content_en_70,
  t0.seo_title_en AS seo_title_en_71,
  t0.seo_description_en AS seo_description_en_72,
  t0.seo_keyword_en AS seo_keyword_en_73,
  t0.has_english_version AS has_english_version_74,
  t0.additional_js AS additional_js_75,
  t0.metaPixelId AS metaPixelId_76,
  t0.createDate AS createDate_77,
  t0.lastChangeDate AS lastChangeDate_78,
  t0.lastChangeUser AS lastChangeUser_79,
  t0.publicId AS publicId_80,
  t0.isExternalSubmission AS isExternalSubmission_81,
  t0.createdBy AS createdBy_82,
  t0.lastModified AS lastModified_83,
  t0.createdAt AS createdAt_84,
  t0.orgaNote AS orgaNote_85,
  t0.calendarSyncedAt AS calendarSyncedAt_86,
  t0.logisticsRoom AS logisticsRoom_87,
  t0.logisticsCatering AS logisticsCatering_88,
  t0.logisticsEquipment AS logisticsEquipment_89,
  t0.logisticsHelpers AS logisticsHelpers_90,
  t0.history AS history_91,
  t0.todoHistory AS todoHistory_92
FROM
  sp_event_events t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.id = 7104;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.label AS label_3,
  t0.domain AS domain_4,
  t0.description AS description_5,
  t0.sqlSelect AS sqlSelect_6,
  t0.zapierWebhook AS zapierWebhook_7,
  t0.isFavorite AS isFavorite_8,
  t0.isModul AS isModul_9,
  t0.isThema AS isThema_10,
  t0.isEditableByUser AS isEditableByUser_11,
  t0.isUsedInWordPress AS isUsedInWordPress_12,
  t0.wpEntitiesCount AS wpEntitiesCount_13,
  t0.entitiesCount AS entitiesCount_14,
  t0.history AS history_15,
  t0.createdAt AS createdAt_16,
  t0.lastModified AS lastModified_17
FROM
  sp_tags t0
WHERE
  t0.domain = ?
  AND t0.isEditableByUser = ?
ORDER BY
  t0.tag ASC

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = 'event' AND t0.isEditableByUser = 1 ORDER BY t0.tag ASC;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.label AS label_3,
  t0.domain AS domain_4,
  t0.description AS description_5,
  t0.sqlSelect AS sqlSelect_6,
  t0.zapierWebhook AS zapierWebhook_7,
  t0.isFavorite AS isFavorite_8,
  t0.isModul AS isModul_9,
  t0.isThema AS isThema_10,
  t0.isEditableByUser AS isEditableByUser_11,
  t0.isUsedInWordPress AS isUsedInWordPress_12,
  t0.wpEntitiesCount AS wpEntitiesCount_13,
  t0.entitiesCount AS entitiesCount_14,
  t0.history AS history_15,
  t0.createdAt AS createdAt_16,
  t0.lastModified AS lastModified_17
FROM
  sp_tags t0
WHERE
  t0.domain = ?
  AND t0.isThema = ?
ORDER BY
  t0.tag ASC

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = 'event' AND t0.isThema = 1 ORDER BY t0.tag ASC;