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_batches 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.type = :type
    AND e.isMultiBatchEvent = 0
    AND COALESCE(e.endDate, e.startDate) >= CURDATE()
)
UNION ALL
  (
    SELECT
      e.*,
      b.id as nextBatchId,
      b.name as nextBatchName,
      COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
      b.endDate as nextBatchEndDate,
      b.priceInEuroCent as displayPrice,
      b.isFreeForKiCampus as displayFreeForKiCampus,
      COALESCE(
        NULLIF(b.landingPageTitle, ''),
        b.pitchTopic
      ) as batchTopic,
      COALESCE(
        NULLIF(b.landingPageSocialImage, ''),
        b.pitchImageLink
      ) as batchImageLink,
      b.pitchPartner as batchPartnerDescription
    FROM
      sp_event_events e
      INNER JOIN sp_batches b ON e.id = b.eventId
    WHERE
      e.status = 'publish'
      AND e.type = :type
      AND e.isMultiBatchEvent = 1
      AND b.status = 'active'
      AND COALESCE(b.startDate, b.pitchDate) >= 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_batches 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.type = 'makerthon'
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) >= CURDATE()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    b.priceInEuroCent as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.landingPageTitle, ''), b.pitchTopic) as batchTopic,
                    COALESCE(NULLIF(b.landingPageSocialImage, ''), b.pitchImageLink) as batchImageLink,
                    b.pitchPartner as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_batches b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.type = 'makerthon'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.startDate, b.pitchDate) >= CURDATE()
            )
            ORDER BY nextBatchDate ASC
            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 > :lastDayOfNextMonth
  AND e.status = :criteria0
  AND e.type = :criteria1
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 >  :lastDayOfNextMonth AND e.status = :criteria0 AND e.type = :criteria1 GROUP BY MONTH(e.startDate);

(
  SELECT
    e.*,
    NULL as nextBatchId,
    NULL as nextBatchName,
    e.startDate as nextBatchDate,
    e.endDate as nextBatchEndDate,
    COALESCE(
      (
        SELECT
          b2.priceInEuroCent
        FROM
          sp_batches 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.type = :type
    AND e.isMultiBatchEvent = 0
    AND COALESCE(e.endDate, e.startDate) < CURDATE()
)
UNION ALL
  (
    SELECT
      e.*,
      b.id as nextBatchId,
      b.name as nextBatchName,
      COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
      b.endDate as nextBatchEndDate,
      b.priceInEuroCent as displayPrice,
      b.isFreeForKiCampus as displayFreeForKiCampus,
      COALESCE(
        NULLIF(b.landingPageTitle, ''),
        b.pitchTopic
      ) as batchTopic,
      COALESCE(
        NULLIF(b.landingPageSocialImage, ''),
        b.pitchImageLink
      ) as batchImageLink,
      b.pitchPartner as batchPartnerDescription
    FROM
      sp_event_events e
      INNER JOIN sp_batches b ON e.id = b.eventId
    WHERE
      e.status = 'publish'
      AND e.type = :type
      AND e.isMultiBatchEvent = 1
      AND b.status = 'active'
      AND COALESCE(
        b.endDate, b.startDate, b.pitchDate
      ) < 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_batches 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.type = 'makerthon'
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) < CURDATE()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    b.priceInEuroCent as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.landingPageTitle, ''), b.pitchTopic) as batchTopic,
                    COALESCE(NULLIF(b.landingPageSocialImage, ''), b.pitchImageLink) as batchImageLink,
                    b.pitchPartner as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_batches b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.type = 'makerthon'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.endDate, b.startDate, b.pitchDate) < CURDATE()
            )
            ORDER BY nextBatchDate DESC
            LIMIT 900
        ;

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_.eventbriteId AS eventbriteId_1,
  s0_.googleCalendarEventId AS googleCalendarEventId_2,
  s0_.wpPostId AS wpPostId_3,
  s0_.title AS title_4,
  s0_.slug AS slug_5,
  s0_.lang AS lang_6,
  s0_.imagelink AS imagelink_7,
  s0_.videolink AS videolink_8,
  s0_.bgImagelink AS bgImagelink_9,
  s0_.tagline AS tagline_10,
  s0_.headerTextColor AS headerTextColor_11,
  s0_.spResponsiblePerson AS spResponsiblePerson_12,
  s0_.organization AS organization_13,
  s0_.organizerName AS organizerName_14,
  s0_.organizerEmail AS organizerEmail_15,
  s0_.venueName AS venueName_16,
  s0_.venueAddress AS venueAddress_17,
  s0_.ticketing AS ticketing_18,
  s0_.applicationUrl AS applicationUrl_19,
  s0_.alert AS alert_20,
  s0_.trainer AS trainer_21,
  s0_.speakers AS speakers_22,
  s0_.teaser AS teaser_23,
  s0_.navbar AS navbar_24,
  s0_.stripePriceId AS stripePriceId_25,
  s0_.stripeProductId AS stripeProductId_26,
  s0_.stripeAccount AS stripeAccount_27,
  s0_.priceInEuroCent AS priceInEuroCent_28,
  s0_.isTaxIncluded AS isTaxIncluded_29,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_30,
  s0_.isFreeForCommunity AS isFreeForCommunity_31,
  s0_.isSinglePage AS isSinglePage_32,
  s0_.isFormalLanguage AS isFormalLanguage_33,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_34,
  s0_.isFeatured AS isFeatured_35,
  s0_.capacity AS capacity_36,
  s0_.twigFile AS twigFile_37,
  s0_.additionalCss AS additionalCss_38,
  s0_.content AS content_39,
  s0_.contentTwig AS contentTwig_40,
  s0_.ctaContent AS ctaContent_41,
  s0_.postCtaContent AS postCtaContent_42,
  s0_.tags AS tags_43,
  s0_.seriesTag AS seriesTag_44,
  s0_.type AS type_45,
  s0_.location AS location_46,
  s0_.startDate AS startDate_47,
  s0_.endDate AS endDate_48,
  s0_.duration AS duration_49,
  s0_.status AS status_50,
  s0_.settings AS settings_51,
  s0_.displayStartDate AS displayStartDate_52,
  s0_.seoTitle AS seoTitle_53,
  s0_.seoKeyword AS seoKeyword_54,
  s0_.seoDescription AS seoDescription_55,
  s0_.navbar_en AS navbar_en_56,
  s0_.teaser_en AS teaser_en_57,
  s0_.content_en AS content_en_58,
  s0_.content_twig_en AS content_twig_en_59,
  s0_.post_cta_content_en AS post_cta_content_en_60,
  s0_.seo_title_en AS seo_title_en_61,
  s0_.seo_description_en AS seo_description_en_62,
  s0_.seo_keyword_en AS seo_keyword_en_63,
  s0_.has_english_version AS has_english_version_64,
  s0_.additional_js AS additional_js_65,
  s0_.metaPixelId AS metaPixelId_66,
  s0_.createDate AS createDate_67,
  s0_.lastChangeDate AS lastChangeDate_68,
  s0_.lastChangeUser AS lastChangeUser_69,
  s0_.publicId AS publicId_70,
  s0_.isExternalSubmission AS isExternalSubmission_71,
  s0_.createdBy AS createdBy_72,
  s0_.lastModified AS lastModified_73,
  s0_.createdAt AS createdAt_74,
  s0_.orgaNote AS orgaNote_75,
  s0_.history AS history_76,
  s0_.todoHistory AS todoHistory_77
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.status = 'publish' AND s0_.startDate >= '2026-04-16' 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_.slug AS slug_5,
  s0_.lang AS lang_6,
  s0_.imagelink AS imagelink_7,
  s0_.videolink AS videolink_8,
  s0_.bgImagelink AS bgImagelink_9,
  s0_.tagline AS tagline_10,
  s0_.headerTextColor AS headerTextColor_11,
  s0_.spResponsiblePerson AS spResponsiblePerson_12,
  s0_.organization AS organization_13,
  s0_.organizerName AS organizerName_14,
  s0_.organizerEmail AS organizerEmail_15,
  s0_.venueName AS venueName_16,
  s0_.venueAddress AS venueAddress_17,
  s0_.ticketing AS ticketing_18,
  s0_.applicationUrl AS applicationUrl_19,
  s0_.alert AS alert_20,
  s0_.trainer AS trainer_21,
  s0_.speakers AS speakers_22,
  s0_.teaser AS teaser_23,
  s0_.navbar AS navbar_24,
  s0_.stripePriceId AS stripePriceId_25,
  s0_.stripeProductId AS stripeProductId_26,
  s0_.stripeAccount AS stripeAccount_27,
  s0_.priceInEuroCent AS priceInEuroCent_28,
  s0_.isTaxIncluded AS isTaxIncluded_29,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_30,
  s0_.isFreeForCommunity AS isFreeForCommunity_31,
  s0_.isSinglePage AS isSinglePage_32,
  s0_.isFormalLanguage AS isFormalLanguage_33,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_34,
  s0_.isFeatured AS isFeatured_35,
  s0_.capacity AS capacity_36,
  s0_.twigFile AS twigFile_37,
  s0_.additionalCss AS additionalCss_38,
  s0_.content AS content_39,
  s0_.contentTwig AS contentTwig_40,
  s0_.ctaContent AS ctaContent_41,
  s0_.postCtaContent AS postCtaContent_42,
  s0_.tags AS tags_43,
  s0_.seriesTag AS seriesTag_44,
  s0_.type AS type_45,
  s0_.location AS location_46,
  s0_.startDate AS startDate_47,
  s0_.endDate AS endDate_48,
  s0_.duration AS duration_49,
  s0_.status AS status_50,
  s0_.settings AS settings_51,
  s0_.displayStartDate AS displayStartDate_52,
  s0_.seoTitle AS seoTitle_53,
  s0_.seoKeyword AS seoKeyword_54,
  s0_.seoDescription AS seoDescription_55,
  s0_.navbar_en AS navbar_en_56,
  s0_.teaser_en AS teaser_en_57,
  s0_.content_en AS content_en_58,
  s0_.content_twig_en AS content_twig_en_59,
  s0_.post_cta_content_en AS post_cta_content_en_60,
  s0_.seo_title_en AS seo_title_en_61,
  s0_.seo_description_en AS seo_description_en_62,
  s0_.seo_keyword_en AS seo_keyword_en_63,
  s0_.has_english_version AS has_english_version_64,
  s0_.additional_js AS additional_js_65,
  s0_.metaPixelId AS metaPixelId_66,
  s0_.createDate AS createDate_67,
  s0_.lastChangeDate AS lastChangeDate_68,
  s0_.lastChangeUser AS lastChangeUser_69,
  s0_.publicId AS publicId_70,
  s0_.isExternalSubmission AS isExternalSubmission_71,
  s0_.createdBy AS createdBy_72,
  s0_.lastModified AS lastModified_73,
  s0_.createdAt AS createdAt_74,
  s0_.orgaNote AS orgaNote_75,
  s0_.history AS history_76,
  s0_.todoHistory AS todoHistory_77
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.status = 'publish' AND s0_.startDate >= '2026-04-16' 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_.slug AS slug_5,
  s0_.lang AS lang_6,
  s0_.imagelink AS imagelink_7,
  s0_.videolink AS videolink_8,
  s0_.bgImagelink AS bgImagelink_9,
  s0_.tagline AS tagline_10,
  s0_.headerTextColor AS headerTextColor_11,
  s0_.spResponsiblePerson AS spResponsiblePerson_12,
  s0_.organization AS organization_13,
  s0_.organizerName AS organizerName_14,
  s0_.organizerEmail AS organizerEmail_15,
  s0_.venueName AS venueName_16,
  s0_.venueAddress AS venueAddress_17,
  s0_.ticketing AS ticketing_18,
  s0_.applicationUrl AS applicationUrl_19,
  s0_.alert AS alert_20,
  s0_.trainer AS trainer_21,
  s0_.speakers AS speakers_22,
  s0_.teaser AS teaser_23,
  s0_.navbar AS navbar_24,
  s0_.stripePriceId AS stripePriceId_25,
  s0_.stripeProductId AS stripeProductId_26,
  s0_.stripeAccount AS stripeAccount_27,
  s0_.priceInEuroCent AS priceInEuroCent_28,
  s0_.isTaxIncluded AS isTaxIncluded_29,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_30,
  s0_.isFreeForCommunity AS isFreeForCommunity_31,
  s0_.isSinglePage AS isSinglePage_32,
  s0_.isFormalLanguage AS isFormalLanguage_33,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_34,
  s0_.isFeatured AS isFeatured_35,
  s0_.capacity AS capacity_36,
  s0_.twigFile AS twigFile_37,
  s0_.additionalCss AS additionalCss_38,
  s0_.content AS content_39,
  s0_.contentTwig AS contentTwig_40,
  s0_.ctaContent AS ctaContent_41,
  s0_.postCtaContent AS postCtaContent_42,
  s0_.tags AS tags_43,
  s0_.seriesTag AS seriesTag_44,
  s0_.type AS type_45,
  s0_.location AS location_46,
  s0_.startDate AS startDate_47,
  s0_.endDate AS endDate_48,
  s0_.duration AS duration_49,
  s0_.status AS status_50,
  s0_.settings AS settings_51,
  s0_.displayStartDate AS displayStartDate_52,
  s0_.seoTitle AS seoTitle_53,
  s0_.seoKeyword AS seoKeyword_54,
  s0_.seoDescription AS seoDescription_55,
  s0_.navbar_en AS navbar_en_56,
  s0_.teaser_en AS teaser_en_57,
  s0_.content_en AS content_en_58,
  s0_.content_twig_en AS content_twig_en_59,
  s0_.post_cta_content_en AS post_cta_content_en_60,
  s0_.seo_title_en AS seo_title_en_61,
  s0_.seo_description_en AS seo_description_en_62,
  s0_.seo_keyword_en AS seo_keyword_en_63,
  s0_.has_english_version AS has_english_version_64,
  s0_.additional_js AS additional_js_65,
  s0_.metaPixelId AS metaPixelId_66,
  s0_.createDate AS createDate_67,
  s0_.lastChangeDate AS lastChangeDate_68,
  s0_.lastChangeUser AS lastChangeUser_69,
  s0_.publicId AS publicId_70,
  s0_.isExternalSubmission AS isExternalSubmission_71,
  s0_.createdBy AS createdBy_72,
  s0_.lastModified AS lastModified_73,
  s0_.createdAt AS createdAt_74,
  s0_.orgaNote AS orgaNote_75,
  s0_.history AS history_76,
  s0_.todoHistory AS todoHistory_77
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.startDate >= '2026-04-16' AND s0_.status = 'publish' AND s0_.status = 'publish' ORDER BY s0_.startDate ASC LIMIT 100;