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()
)
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 '%#talk%'
                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 '%#talk%'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND b.startDate >= CURDATE()
            )
            ORDER BY nextBatchDate ASC
            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()
    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 '%#talk%'
                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 '%#talk%'
                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
  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.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.isUsedInWordPress = ?
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.isUsedInWordPress = 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;

SELECT
  MONTH(e.startDate) as month,
  YEAR(e.startDate) as year,
  COUNT(
    MONTH(e.startDate)
  ) as total
FROM
  sp_event_events e
WHERE
  e.startDate > ?
  AND e.status = ?
GROUP BY
  MONTH(e.startDate)

SELECT MONTH(e.startDate) as month, YEAR(e.startDate) as year, COUNT(MONTH(e.startDate)) as total
          FROM sp_event_events e
          WHERE e.startDate >  '2026-09-30' AND e.status = 'publish' GROUP BY MONTH(e.startDate);

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.isModul = ?
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.isModul = 1 ORDER BY t0.tag ASC;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.teaser AS teaser_2,
  s0_.buttonLabel AS buttonLabel_3,
  s0_.targetUrl AS targetUrl_4,
  s0_.imageUrl AS imageUrl_5,
  s0_.label AS label_6,
  s0_.slotPosition AS slotPosition_7,
  s0_.isActive AS isActive_8,
  s0_.createdAt AS createdAt_9,
  s0_.updatedAt AS updatedAt_10
FROM
  sp_event_promo_card s0_
WHERE
  s0_.isActive = ?
ORDER BY
  s0_.slotPosition ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.teaser AS teaser_2, s0_.buttonLabel AS buttonLabel_3, s0_.targetUrl AS targetUrl_4, s0_.imageUrl AS imageUrl_5, s0_.label AS label_6, s0_.slotPosition AS slotPosition_7, s0_.isActive AS isActive_8, s0_.createdAt AS createdAt_9, s0_.updatedAt AS updatedAt_10 FROM sp_event_promo_card s0_ WHERE s0_.isActive = 1 ORDER BY s0_.slotPosition ASC, s0_.id ASC;