Symfony Profiler

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
    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,
      b.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,
                    b.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()
)
UNION ALL
  (
    SELECT
      e.*,
      b.id as nextBatchId,
      b.name as nextBatchName,
      b.startDate as nextBatchDate,
      b.endDate as nextBatchEndDate,
      b.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()
  )
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()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    b.startDate as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    b.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()
            )
            ORDER BY nextBatchDate DESC
            LIMIT 900
        ;

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-07-31' 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.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
  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;

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_.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_.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_.status = 'publish' AND s0_.startDate >= '2026-06-11' AND s0_.type = 'Konferenz' 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_.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_.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_.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_.status = 'publish' AND s0_.startDate >= '2026-06-11' AND s0_.type = 'Workshop' 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_.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_.startDate >= ?
  AND s0_.status = 'publish'
  AND s0_.status = 'publish'
ORDER BY
  s0_.startDate ASC
LIMIT
  100