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 = 'community-event'
                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 = 'community-event'
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.startDate, b.pitchDate) >= CURDATE()
            )
            ORDER BY nextBatchDate ASC
            LIMIT 900
        ;

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.slug AS slug_6,
  t0.lang AS lang_7,
  t0.imagelink AS imagelink_8,
  t0.videolink AS videolink_9,
  t0.bgImagelink AS bgImagelink_10,
  t0.tagline AS tagline_11,
  t0.headerTextColor AS headerTextColor_12,
  t0.spResponsiblePerson AS spResponsiblePerson_13,
  t0.organization AS organization_14,
  t0.organizerName AS organizerName_15,
  t0.organizerEmail AS organizerEmail_16,
  t0.venueName AS venueName_17,
  t0.venueAddress AS venueAddress_18,
  t0.ticketing AS ticketing_19,
  t0.applicationUrl AS applicationUrl_20,
  t0.alert AS alert_21,
  t0.trainer AS trainer_22,
  t0.speakers AS speakers_23,
  t0.teaser AS teaser_24,
  t0.navbar AS navbar_25,
  t0.stripePriceId AS stripePriceId_26,
  t0.stripeProductId AS stripeProductId_27,
  t0.stripeAccount AS stripeAccount_28,
  t0.priceInEuroCent AS priceInEuroCent_29,
  t0.isTaxIncluded AS isTaxIncluded_30,
  t0.isFreeForKiCampus AS isFreeForKiCampus_31,
  t0.isFreeForCommunity AS isFreeForCommunity_32,
  t0.isSinglePage AS isSinglePage_33,
  t0.isFormalLanguage AS isFormalLanguage_34,
  t0.isMultiBatchEvent AS isMultiBatchEvent_35,
  t0.isFeatured AS isFeatured_36,
  t0.capacity AS capacity_37,
  t0.twigFile AS twigFile_38,
  t0.additionalCss AS additionalCss_39,
  t0.content AS content_40,
  t0.contentTwig AS contentTwig_41,
  t0.ctaContent AS ctaContent_42,
  t0.postCtaContent AS postCtaContent_43,
  t0.tags AS tags_44,
  t0.seriesTag AS seriesTag_45,
  t0.type AS type_46,
  t0.location AS location_47,
  t0.startDate AS startDate_48,
  t0.endDate AS endDate_49,
  t0.duration AS duration_50,
  t0.status AS status_51,
  t0.settings AS settings_52,
  t0.displayStartDate AS displayStartDate_53,
  t0.seoTitle AS seoTitle_54,
  t0.seoKeyword AS seoKeyword_55,
  t0.seoDescription AS seoDescription_56,
  t0.navbar_en AS navbar_en_57,
  t0.teaser_en AS teaser_en_58,
  t0.content_en AS content_en_59,
  t0.content_twig_en AS content_twig_en_60,
  t0.post_cta_content_en AS post_cta_content_en_61,
  t0.seo_title_en AS seo_title_en_62,
  t0.seo_description_en AS seo_description_en_63,
  t0.seo_keyword_en AS seo_keyword_en_64,
  t0.has_english_version AS has_english_version_65,
  t0.additional_js AS additional_js_66,
  t0.metaPixelId AS metaPixelId_67,
  t0.createDate AS createDate_68,
  t0.lastChangeDate AS lastChangeDate_69,
  t0.lastChangeUser AS lastChangeUser_70,
  t0.publicId AS publicId_71,
  t0.isExternalSubmission AS isExternalSubmission_72,
  t0.createdBy AS createdBy_73,
  t0.lastModified AS lastModified_74,
  t0.createdAt AS createdAt_75,
  t0.orgaNote AS orgaNote_76,
  t0.history AS history_77,
  t0.todoHistory AS todoHistory_78
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.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = 6949;

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.slug AS slug_6,
  t0.lang AS lang_7,
  t0.imagelink AS imagelink_8,
  t0.videolink AS videolink_9,
  t0.bgImagelink AS bgImagelink_10,
  t0.tagline AS tagline_11,
  t0.headerTextColor AS headerTextColor_12,
  t0.spResponsiblePerson AS spResponsiblePerson_13,
  t0.organization AS organization_14,
  t0.organizerName AS organizerName_15,
  t0.organizerEmail AS organizerEmail_16,
  t0.venueName AS venueName_17,
  t0.venueAddress AS venueAddress_18,
  t0.ticketing AS ticketing_19,
  t0.applicationUrl AS applicationUrl_20,
  t0.alert AS alert_21,
  t0.trainer AS trainer_22,
  t0.speakers AS speakers_23,
  t0.teaser AS teaser_24,
  t0.navbar AS navbar_25,
  t0.stripePriceId AS stripePriceId_26,
  t0.stripeProductId AS stripeProductId_27,
  t0.stripeAccount AS stripeAccount_28,
  t0.priceInEuroCent AS priceInEuroCent_29,
  t0.isTaxIncluded AS isTaxIncluded_30,
  t0.isFreeForKiCampus AS isFreeForKiCampus_31,
  t0.isFreeForCommunity AS isFreeForCommunity_32,
  t0.isSinglePage AS isSinglePage_33,
  t0.isFormalLanguage AS isFormalLanguage_34,
  t0.isMultiBatchEvent AS isMultiBatchEvent_35,
  t0.isFeatured AS isFeatured_36,
  t0.capacity AS capacity_37,
  t0.twigFile AS twigFile_38,
  t0.additionalCss AS additionalCss_39,
  t0.content AS content_40,
  t0.contentTwig AS contentTwig_41,
  t0.ctaContent AS ctaContent_42,
  t0.postCtaContent AS postCtaContent_43,
  t0.tags AS tags_44,
  t0.seriesTag AS seriesTag_45,
  t0.type AS type_46,
  t0.location AS location_47,
  t0.startDate AS startDate_48,
  t0.endDate AS endDate_49,
  t0.duration AS duration_50,
  t0.status AS status_51,
  t0.settings AS settings_52,
  t0.displayStartDate AS displayStartDate_53,
  t0.seoTitle AS seoTitle_54,
  t0.seoKeyword AS seoKeyword_55,
  t0.seoDescription AS seoDescription_56,
  t0.navbar_en AS navbar_en_57,
  t0.teaser_en AS teaser_en_58,
  t0.content_en AS content_en_59,
  t0.content_twig_en AS content_twig_en_60,
  t0.post_cta_content_en AS post_cta_content_en_61,
  t0.seo_title_en AS seo_title_en_62,
  t0.seo_description_en AS seo_description_en_63,
  t0.seo_keyword_en AS seo_keyword_en_64,
  t0.has_english_version AS has_english_version_65,
  t0.additional_js AS additional_js_66,
  t0.metaPixelId AS metaPixelId_67,
  t0.createDate AS createDate_68,
  t0.lastChangeDate AS lastChangeDate_69,
  t0.lastChangeUser AS lastChangeUser_70,
  t0.publicId AS publicId_71,
  t0.isExternalSubmission AS isExternalSubmission_72,
  t0.createdBy AS createdBy_73,
  t0.lastModified AS lastModified_74,
  t0.createdAt AS createdAt_75,
  t0.orgaNote AS orgaNote_76,
  t0.history AS history_77,
  t0.todoHistory AS todoHistory_78
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.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = 6942;

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.slug AS slug_6,
  t0.lang AS lang_7,
  t0.imagelink AS imagelink_8,
  t0.videolink AS videolink_9,
  t0.bgImagelink AS bgImagelink_10,
  t0.tagline AS tagline_11,
  t0.headerTextColor AS headerTextColor_12,
  t0.spResponsiblePerson AS spResponsiblePerson_13,
  t0.organization AS organization_14,
  t0.organizerName AS organizerName_15,
  t0.organizerEmail AS organizerEmail_16,
  t0.venueName AS venueName_17,
  t0.venueAddress AS venueAddress_18,
  t0.ticketing AS ticketing_19,
  t0.applicationUrl AS applicationUrl_20,
  t0.alert AS alert_21,
  t0.trainer AS trainer_22,
  t0.speakers AS speakers_23,
  t0.teaser AS teaser_24,
  t0.navbar AS navbar_25,
  t0.stripePriceId AS stripePriceId_26,
  t0.stripeProductId AS stripeProductId_27,
  t0.stripeAccount AS stripeAccount_28,
  t0.priceInEuroCent AS priceInEuroCent_29,
  t0.isTaxIncluded AS isTaxIncluded_30,
  t0.isFreeForKiCampus AS isFreeForKiCampus_31,
  t0.isFreeForCommunity AS isFreeForCommunity_32,
  t0.isSinglePage AS isSinglePage_33,
  t0.isFormalLanguage AS isFormalLanguage_34,
  t0.isMultiBatchEvent AS isMultiBatchEvent_35,
  t0.isFeatured AS isFeatured_36,
  t0.capacity AS capacity_37,
  t0.twigFile AS twigFile_38,
  t0.additionalCss AS additionalCss_39,
  t0.content AS content_40,
  t0.contentTwig AS contentTwig_41,
  t0.ctaContent AS ctaContent_42,
  t0.postCtaContent AS postCtaContent_43,
  t0.tags AS tags_44,
  t0.seriesTag AS seriesTag_45,
  t0.type AS type_46,
  t0.location AS location_47,
  t0.startDate AS startDate_48,
  t0.endDate AS endDate_49,
  t0.duration AS duration_50,
  t0.status AS status_51,
  t0.settings AS settings_52,
  t0.displayStartDate AS displayStartDate_53,
  t0.seoTitle AS seoTitle_54,
  t0.seoKeyword AS seoKeyword_55,
  t0.seoDescription AS seoDescription_56,
  t0.navbar_en AS navbar_en_57,
  t0.teaser_en AS teaser_en_58,
  t0.content_en AS content_en_59,
  t0.content_twig_en AS content_twig_en_60,
  t0.post_cta_content_en AS post_cta_content_en_61,
  t0.seo_title_en AS seo_title_en_62,
  t0.seo_description_en AS seo_description_en_63,
  t0.seo_keyword_en AS seo_keyword_en_64,
  t0.has_english_version AS has_english_version_65,
  t0.additional_js AS additional_js_66,
  t0.metaPixelId AS metaPixelId_67,
  t0.createDate AS createDate_68,
  t0.lastChangeDate AS lastChangeDate_69,
  t0.lastChangeUser AS lastChangeUser_70,
  t0.publicId AS publicId_71,
  t0.isExternalSubmission AS isExternalSubmission_72,
  t0.createdBy AS createdBy_73,
  t0.lastModified AS lastModified_74,
  t0.createdAt AS createdAt_75,
  t0.orgaNote AS orgaNote_76,
  t0.history AS history_77,
  t0.todoHistory AS todoHistory_78
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.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = 6948;

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.slug AS slug_6,
  t0.lang AS lang_7,
  t0.imagelink AS imagelink_8,
  t0.videolink AS videolink_9,
  t0.bgImagelink AS bgImagelink_10,
  t0.tagline AS tagline_11,
  t0.headerTextColor AS headerTextColor_12,
  t0.spResponsiblePerson AS spResponsiblePerson_13,
  t0.organization AS organization_14,
  t0.organizerName AS organizerName_15,
  t0.organizerEmail AS organizerEmail_16,
  t0.venueName AS venueName_17,
  t0.venueAddress AS venueAddress_18,
  t0.ticketing AS ticketing_19,
  t0.applicationUrl AS applicationUrl_20,
  t0.alert AS alert_21,
  t0.trainer AS trainer_22,
  t0.speakers AS speakers_23,
  t0.teaser AS teaser_24,
  t0.navbar AS navbar_25,
  t0.stripePriceId AS stripePriceId_26,
  t0.stripeProductId AS stripeProductId_27,
  t0.stripeAccount AS stripeAccount_28,
  t0.priceInEuroCent AS priceInEuroCent_29,
  t0.isTaxIncluded AS isTaxIncluded_30,
  t0.isFreeForKiCampus AS isFreeForKiCampus_31,
  t0.isFreeForCommunity AS isFreeForCommunity_32,
  t0.isSinglePage AS isSinglePage_33,
  t0.isFormalLanguage AS isFormalLanguage_34,
  t0.isMultiBatchEvent AS isMultiBatchEvent_35,
  t0.isFeatured AS isFeatured_36,
  t0.capacity AS capacity_37,
  t0.twigFile AS twigFile_38,
  t0.additionalCss AS additionalCss_39,
  t0.content AS content_40,
  t0.contentTwig AS contentTwig_41,
  t0.ctaContent AS ctaContent_42,
  t0.postCtaContent AS postCtaContent_43,
  t0.tags AS tags_44,
  t0.seriesTag AS seriesTag_45,
  t0.type AS type_46,
  t0.location AS location_47,
  t0.startDate AS startDate_48,
  t0.endDate AS endDate_49,
  t0.duration AS duration_50,
  t0.status AS status_51,
  t0.settings AS settings_52,
  t0.displayStartDate AS displayStartDate_53,
  t0.seoTitle AS seoTitle_54,
  t0.seoKeyword AS seoKeyword_55,
  t0.seoDescription AS seoDescription_56,
  t0.navbar_en AS navbar_en_57,
  t0.teaser_en AS teaser_en_58,
  t0.content_en AS content_en_59,
  t0.content_twig_en AS content_twig_en_60,
  t0.post_cta_content_en AS post_cta_content_en_61,
  t0.seo_title_en AS seo_title_en_62,
  t0.seo_description_en AS seo_description_en_63,
  t0.seo_keyword_en AS seo_keyword_en_64,
  t0.has_english_version AS has_english_version_65,
  t0.additional_js AS additional_js_66,
  t0.metaPixelId AS metaPixelId_67,
  t0.createDate AS createDate_68,
  t0.lastChangeDate AS lastChangeDate_69,
  t0.lastChangeUser AS lastChangeUser_70,
  t0.publicId AS publicId_71,
  t0.isExternalSubmission AS isExternalSubmission_72,
  t0.createdBy AS createdBy_73,
  t0.lastModified AS lastModified_74,
  t0.createdAt AS createdAt_75,
  t0.orgaNote AS orgaNote_76,
  t0.history AS history_77,
  t0.todoHistory AS todoHistory_78
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.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = 5644;