Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.eventbriteId AS eventbriteId_1,
  a0_.wpPostId AS wpPostId_2,
  a0_.title AS title_3,
  a0_.slug AS slug_4,
  a0_.lang AS lang_5,
  a0_.imagelink AS imagelink_6,
  a0_.videolink AS videolink_7,
  a0_.bgImagelink AS bgImagelink_8,
  a0_.tagline AS tagline_9,
  a0_.headerTextColor AS headerTextColor_10,
  a0_.spResponsiblePerson AS spResponsiblePerson_11,
  a0_.organization AS organization_12,
  a0_.organizerName AS organizerName_13,
  a0_.organizerEmail AS organizerEmail_14,
  a0_.venueName AS venueName_15,
  a0_.venueAddress AS venueAddress_16,
  a0_.ticketing AS ticketing_17,
  a0_.applicationUrl AS applicationUrl_18,
  a0_.alert AS alert_19,
  a0_.trainer AS trainer_20,
  a0_.speakers AS speakers_21,
  a0_.teaser AS teaser_22,
  a0_.navbar AS navbar_23,
  a0_.stripePriceId AS stripePriceId_24,
  a0_.stripeProductId AS stripeProductId_25,
  a0_.stripeAccount AS stripeAccount_26,
  a0_.priceInEuroCent AS priceInEuroCent_27,
  a0_.isTaxIncluded AS isTaxIncluded_28,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  a0_.isFreeForCommunity AS isFreeForCommunity_30,
  a0_.isSinglePage AS isSinglePage_31,
  a0_.isFormalLanguage AS isFormalLanguage_32,
  a0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  a0_.twigFile AS twigFile_34,
  a0_.additionalCss AS additionalCss_35,
  a0_.content AS content_36,
  a0_.contentTwig AS contentTwig_37,
  a0_.ctaContent AS ctaContent_38,
  a0_.postCtaContent AS postCtaContent_39,
  a0_.tags AS tags_40,
  a0_.seriesTag AS seriesTag_41,
  a0_.type AS type_42,
  a0_.location AS location_43,
  a0_.startDate AS startDate_44,
  a0_.endDate AS endDate_45,
  a0_.duration AS duration_46,
  a0_.status AS status_47,
  a0_.settings AS settings_48,
  a0_.displayStartDate AS displayStartDate_49,
  a0_.seoTitle AS seoTitle_50,
  a0_.seoKeyword AS seoKeyword_51,
  a0_.seoDescription AS seoDescription_52,
  a0_.navbar_en AS navbar_en_53,
  a0_.teaser_en AS teaser_en_54,
  a0_.content_en AS content_en_55,
  a0_.content_twig_en AS content_twig_en_56,
  a0_.post_cta_content_en AS post_cta_content_en_57,
  a0_.seo_title_en AS seo_title_en_58,
  a0_.seo_description_en AS seo_description_en_59,
  a0_.seo_keyword_en AS seo_keyword_en_60,
  a0_.has_english_version AS has_english_version_61,
  a0_.additional_js AS additional_js_62,
  a0_.metaPixelId AS metaPixelId_63,
  a0_.createDate AS createDate_64,
  a0_.lastChangeDate AS lastChangeDate_65,
  a0_.lastChangeUser AS lastChangeUser_66,
  a0_.publicId AS publicId_67,
  a0_.isExternalSubmission AS isExternalSubmission_68,
  a0_.createdBy AS createdBy_69,
  a0_.lastModified AS lastModified_70,
  a0_.createdAt AS createdAt_71,
  a0_.orgaNote AS orgaNote_72,
  a0_.history AS history_73,
  a0_.todoHistory AS todoHistory_74
FROM
  asp_events a0_
WHERE
  a0_.seriesTag = ?
  AND a0_.status = ?

SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = 'ai-monday-koeln' AND a0_.status = 'publish';

SELECT
  a0_.id AS id_0,
  a0_.eventbriteId AS eventbriteId_1,
  a0_.wpPostId AS wpPostId_2,
  a0_.title AS title_3,
  a0_.slug AS slug_4,
  a0_.lang AS lang_5,
  a0_.imagelink AS imagelink_6,
  a0_.videolink AS videolink_7,
  a0_.bgImagelink AS bgImagelink_8,
  a0_.tagline AS tagline_9,
  a0_.headerTextColor AS headerTextColor_10,
  a0_.spResponsiblePerson AS spResponsiblePerson_11,
  a0_.organization AS organization_12,
  a0_.organizerName AS organizerName_13,
  a0_.organizerEmail AS organizerEmail_14,
  a0_.venueName AS venueName_15,
  a0_.venueAddress AS venueAddress_16,
  a0_.ticketing AS ticketing_17,
  a0_.applicationUrl AS applicationUrl_18,
  a0_.alert AS alert_19,
  a0_.trainer AS trainer_20,
  a0_.speakers AS speakers_21,
  a0_.teaser AS teaser_22,
  a0_.navbar AS navbar_23,
  a0_.stripePriceId AS stripePriceId_24,
  a0_.stripeProductId AS stripeProductId_25,
  a0_.stripeAccount AS stripeAccount_26,
  a0_.priceInEuroCent AS priceInEuroCent_27,
  a0_.isTaxIncluded AS isTaxIncluded_28,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  a0_.isFreeForCommunity AS isFreeForCommunity_30,
  a0_.isSinglePage AS isSinglePage_31,
  a0_.isFormalLanguage AS isFormalLanguage_32,
  a0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  a0_.twigFile AS twigFile_34,
  a0_.additionalCss AS additionalCss_35,
  a0_.content AS content_36,
  a0_.contentTwig AS contentTwig_37,
  a0_.ctaContent AS ctaContent_38,
  a0_.postCtaContent AS postCtaContent_39,
  a0_.tags AS tags_40,
  a0_.seriesTag AS seriesTag_41,
  a0_.type AS type_42,
  a0_.location AS location_43,
  a0_.startDate AS startDate_44,
  a0_.endDate AS endDate_45,
  a0_.duration AS duration_46,
  a0_.status AS status_47,
  a0_.settings AS settings_48,
  a0_.displayStartDate AS displayStartDate_49,
  a0_.seoTitle AS seoTitle_50,
  a0_.seoKeyword AS seoKeyword_51,
  a0_.seoDescription AS seoDescription_52,
  a0_.navbar_en AS navbar_en_53,
  a0_.teaser_en AS teaser_en_54,
  a0_.content_en AS content_en_55,
  a0_.content_twig_en AS content_twig_en_56,
  a0_.post_cta_content_en AS post_cta_content_en_57,
  a0_.seo_title_en AS seo_title_en_58,
  a0_.seo_description_en AS seo_description_en_59,
  a0_.seo_keyword_en AS seo_keyword_en_60,
  a0_.has_english_version AS has_english_version_61,
  a0_.additional_js AS additional_js_62,
  a0_.metaPixelId AS metaPixelId_63,
  a0_.createDate AS createDate_64,
  a0_.lastChangeDate AS lastChangeDate_65,
  a0_.lastChangeUser AS lastChangeUser_66,
  a0_.publicId AS publicId_67,
  a0_.isExternalSubmission AS isExternalSubmission_68,
  a0_.createdBy AS createdBy_69,
  a0_.lastModified AS lastModified_70,
  a0_.createdAt AS createdAt_71,
  a0_.orgaNote AS orgaNote_72,
  a0_.history AS history_73,
  a0_.todoHistory AS todoHistory_74
FROM
  asp_events a0_
WHERE
  a0_.seriesTag = ?
  AND a0_.status = ?

SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = 'ai-monday-koeln' AND a0_.status = 'publish';

SELECT
  a0_.id AS id_0,
  a0_.eventbriteId AS eventbriteId_1,
  a0_.wpPostId AS wpPostId_2,
  a0_.title AS title_3,
  a0_.slug AS slug_4,
  a0_.lang AS lang_5,
  a0_.imagelink AS imagelink_6,
  a0_.videolink AS videolink_7,
  a0_.bgImagelink AS bgImagelink_8,
  a0_.tagline AS tagline_9,
  a0_.headerTextColor AS headerTextColor_10,
  a0_.spResponsiblePerson AS spResponsiblePerson_11,
  a0_.organization AS organization_12,
  a0_.organizerName AS organizerName_13,
  a0_.organizerEmail AS organizerEmail_14,
  a0_.venueName AS venueName_15,
  a0_.venueAddress AS venueAddress_16,
  a0_.ticketing AS ticketing_17,
  a0_.applicationUrl AS applicationUrl_18,
  a0_.alert AS alert_19,
  a0_.trainer AS trainer_20,
  a0_.speakers AS speakers_21,
  a0_.teaser AS teaser_22,
  a0_.navbar AS navbar_23,
  a0_.stripePriceId AS stripePriceId_24,
  a0_.stripeProductId AS stripeProductId_25,
  a0_.stripeAccount AS stripeAccount_26,
  a0_.priceInEuroCent AS priceInEuroCent_27,
  a0_.isTaxIncluded AS isTaxIncluded_28,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  a0_.isFreeForCommunity AS isFreeForCommunity_30,
  a0_.isSinglePage AS isSinglePage_31,
  a0_.isFormalLanguage AS isFormalLanguage_32,
  a0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  a0_.twigFile AS twigFile_34,
  a0_.additionalCss AS additionalCss_35,
  a0_.content AS content_36,
  a0_.contentTwig AS contentTwig_37,
  a0_.ctaContent AS ctaContent_38,
  a0_.postCtaContent AS postCtaContent_39,
  a0_.tags AS tags_40,
  a0_.seriesTag AS seriesTag_41,
  a0_.type AS type_42,
  a0_.location AS location_43,
  a0_.startDate AS startDate_44,
  a0_.endDate AS endDate_45,
  a0_.duration AS duration_46,
  a0_.status AS status_47,
  a0_.settings AS settings_48,
  a0_.displayStartDate AS displayStartDate_49,
  a0_.seoTitle AS seoTitle_50,
  a0_.seoKeyword AS seoKeyword_51,
  a0_.seoDescription AS seoDescription_52,
  a0_.navbar_en AS navbar_en_53,
  a0_.teaser_en AS teaser_en_54,
  a0_.content_en AS content_en_55,
  a0_.content_twig_en AS content_twig_en_56,
  a0_.post_cta_content_en AS post_cta_content_en_57,
  a0_.seo_title_en AS seo_title_en_58,
  a0_.seo_description_en AS seo_description_en_59,
  a0_.seo_keyword_en AS seo_keyword_en_60,
  a0_.has_english_version AS has_english_version_61,
  a0_.additional_js AS additional_js_62,
  a0_.metaPixelId AS metaPixelId_63,
  a0_.createDate AS createDate_64,
  a0_.lastChangeDate AS lastChangeDate_65,
  a0_.lastChangeUser AS lastChangeUser_66,
  a0_.publicId AS publicId_67,
  a0_.isExternalSubmission AS isExternalSubmission_68,
  a0_.createdBy AS createdBy_69,
  a0_.lastModified AS lastModified_70,
  a0_.createdAt AS createdAt_71,
  a0_.orgaNote AS orgaNote_72,
  a0_.history AS history_73,
  a0_.todoHistory AS todoHistory_74
FROM
  asp_events a0_
WHERE
  a0_.seriesTag = ?
  AND a0_.id <> ?
  AND a0_.status = ?

SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = 'ai-monday-koeln' AND a0_.id <> 6436 AND a0_.status = 'publish';

SELECT
  a0_.id AS id_0,
  a0_.eventbriteId AS eventbriteId_1,
  a0_.wpPostId AS wpPostId_2,
  a0_.title AS title_3,
  a0_.slug AS slug_4,
  a0_.lang AS lang_5,
  a0_.imagelink AS imagelink_6,
  a0_.videolink AS videolink_7,
  a0_.bgImagelink AS bgImagelink_8,
  a0_.tagline AS tagline_9,
  a0_.headerTextColor AS headerTextColor_10,
  a0_.spResponsiblePerson AS spResponsiblePerson_11,
  a0_.organization AS organization_12,
  a0_.organizerName AS organizerName_13,
  a0_.organizerEmail AS organizerEmail_14,
  a0_.venueName AS venueName_15,
  a0_.venueAddress AS venueAddress_16,
  a0_.ticketing AS ticketing_17,
  a0_.applicationUrl AS applicationUrl_18,
  a0_.alert AS alert_19,
  a0_.trainer AS trainer_20,
  a0_.speakers AS speakers_21,
  a0_.teaser AS teaser_22,
  a0_.navbar AS navbar_23,
  a0_.stripePriceId AS stripePriceId_24,
  a0_.stripeProductId AS stripeProductId_25,
  a0_.stripeAccount AS stripeAccount_26,
  a0_.priceInEuroCent AS priceInEuroCent_27,
  a0_.isTaxIncluded AS isTaxIncluded_28,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  a0_.isFreeForCommunity AS isFreeForCommunity_30,
  a0_.isSinglePage AS isSinglePage_31,
  a0_.isFormalLanguage AS isFormalLanguage_32,
  a0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  a0_.twigFile AS twigFile_34,
  a0_.additionalCss AS additionalCss_35,
  a0_.content AS content_36,
  a0_.contentTwig AS contentTwig_37,
  a0_.ctaContent AS ctaContent_38,
  a0_.postCtaContent AS postCtaContent_39,
  a0_.tags AS tags_40,
  a0_.seriesTag AS seriesTag_41,
  a0_.type AS type_42,
  a0_.location AS location_43,
  a0_.startDate AS startDate_44,
  a0_.endDate AS endDate_45,
  a0_.duration AS duration_46,
  a0_.status AS status_47,
  a0_.settings AS settings_48,
  a0_.displayStartDate AS displayStartDate_49,
  a0_.seoTitle AS seoTitle_50,
  a0_.seoKeyword AS seoKeyword_51,
  a0_.seoDescription AS seoDescription_52,
  a0_.navbar_en AS navbar_en_53,
  a0_.teaser_en AS teaser_en_54,
  a0_.content_en AS content_en_55,
  a0_.content_twig_en AS content_twig_en_56,
  a0_.post_cta_content_en AS post_cta_content_en_57,
  a0_.seo_title_en AS seo_title_en_58,
  a0_.seo_description_en AS seo_description_en_59,
  a0_.seo_keyword_en AS seo_keyword_en_60,
  a0_.has_english_version AS has_english_version_61,
  a0_.additional_js AS additional_js_62,
  a0_.metaPixelId AS metaPixelId_63,
  a0_.createDate AS createDate_64,
  a0_.lastChangeDate AS lastChangeDate_65,
  a0_.lastChangeUser AS lastChangeUser_66,
  a0_.publicId AS publicId_67,
  a0_.isExternalSubmission AS isExternalSubmission_68,
  a0_.createdBy AS createdBy_69,
  a0_.lastModified AS lastModified_70,
  a0_.createdAt AS createdAt_71,
  a0_.orgaNote AS orgaNote_72,
  a0_.history AS history_73,
  a0_.todoHistory AS todoHistory_74
FROM
  asp_events a0_
WHERE
  a0_.seriesTag = ?
  AND a0_.id <> ?
  AND a0_.status = ?

SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = 'ai-monday-koeln' AND a0_.id <> 6436 AND a0_.status = 'publish';

SELECT
  b.id as batch_id,
  b.eventId as event_id,
  b.name as batch_name,
  b.slug as batch_slug,
  COALESCE(b.startDate, b.pitchDate) as batch_date,
  b.endDate as batch_end_date,
  b.status as batch_status,
  e.id as event_id,
  e.title as event_title,
  e.slug as event_slug,
  e.location,
  e.venueName,
  e.trainer,
  e.isMultiBatchEvent
FROM
  asp_events e
  INNER JOIN aab_batches b ON b.eventId = e.id
WHERE
  e.seriesTag = :seriesTag
  AND e.status = 'publish'
  AND b.status = 'active'
  AND e.isMultiBatchEvent = 1
  AND (
    (
      b.startDate IS NOT NULL
      AND b.startDate > NOW()
    )
    OR (
      b.startDate IS NULL
      AND b.pitchDate > NOW()
    )
  )
ORDER BY
  COALESCE(b.startDate, b.pitchDate) ASC

SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM asp_events e
            INNER JOIN aab_batches b ON b.eventId = e.id
            WHERE e.seriesTag = 'ai-monday-koeln'
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.startDate IS NOT NULL AND b.startDate > NOW()) OR 
                (b.startDate IS NULL AND b.pitchDate > NOW())
            )
         ORDER BY COALESCE(b.startDate, b.pitchDate) ASC;

SELECT
  b.id as batch_id,
  b.eventId as event_id,
  b.name as batch_name,
  b.slug as batch_slug,
  COALESCE(
    b.endDate, b.startDate, b.pitchDate
  ) as batch_date,
  b.endDate as batch_end_date,
  b.status as batch_status,
  e.id as event_id,
  e.title as event_title,
  e.slug as event_slug,
  e.location,
  e.venueName,
  e.trainer,
  e.isMultiBatchEvent
FROM
  asp_events e
  INNER JOIN aab_batches b ON b.eventId = e.id
WHERE
  e.seriesTag = :seriesTag
  AND e.status = 'publish'
  AND b.status = 'active'
  AND e.isMultiBatchEvent = 1
  AND (
    (
      b.endDate IS NOT NULL
      AND b.endDate < NOW()
    )
    OR (
      b.endDate IS NULL
      AND b.startDate IS NOT NULL
      AND b.startDate < NOW()
    )
    OR (
      b.startDate IS NULL
      AND b.pitchDate < NOW()
    )
  )
ORDER BY
  COALESCE(
    b.endDate, b.startDate, b.pitchDate
  ) DESC

SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM asp_events e
            INNER JOIN aab_batches b ON b.eventId = e.id
            WHERE e.seriesTag = 'ai-monday-koeln'
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.endDate IS NOT NULL AND b.endDate < NOW()) OR
                (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR
                (b.startDate IS NULL AND b.pitchDate < NOW())
            )
         ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC;

SELECT
  t0.id AS id_1,
  t0.spMemberId AS spMemberId_2,
  t0.score AS score_3,
  t0.completenessScore AS completenessScore_4,
  t0.status AS status_5,
  t0.location AS location_6,
  t0.salutation AS salutation_7,
  t0.title AS title_8,
  t0.jobTitle AS jobTitle_9,
  t0.firstName AS firstName_10,
  t0.lastName AS lastName_11,
  t0.name AS name_12,
  t0.sortName AS sortName_13,
  t0.email AS email_14,
  t0.secondaryEmail AS secondaryEmail_15,
  t0.phone AS phone_16,
  t0.hasCommunityMembership AS hasCommunityMembership_17,
  t0.aiMemberValid AS aiMemberValid_18,
  t0.aiMemberStatus AS aiMemberStatus_19,
  t0.aiMemberReason AS aiMemberReason_20,
  t0.aiMemberStart AS aiMemberStart_21,
  t0.aiMemberEnd AS aiMemberEnd_22,
  t0.utm_source AS utm_source_23,
  t0.utm_medium AS utm_medium_24,
  t0.utm_campaign AS utm_campaign_25,
  t0.utm_term AS utm_term_26,
  t0.utm_content AS utm_content_27,
  t0.birthday AS birthday_28,
  t0.addressFieldOne AS addressFieldOne_29,
  t0.addressFieldTwo AS addressFieldTwo_30,
  t0.addressCountryCode AS addressCountryCode_31,
  t0.addressPostalCode AS addressPostalCode_32,
  t0.addressCity AS addressCity_33,
  t0.teamId AS teamId_34,
  t0.teamName AS teamName_35,
  t0.company AS company_36,
  t0.history AS history_37,
  t0.tags AS tags_38,
  t0.annotation AS annotation_39,
  t0.mentorBuckets AS mentorBuckets_40,
  t0.areasOfExpertise AS areasOfExpertise_41,
  t0.mentor_firma AS mentor_firma_42,
  t0.mentor_firma_url AS mentor_firma_url_43,
  t0.mentor_locations AS mentor_locations_44,
  t0.mentor_profile AS mentor_profile_45,
  t0.mentor_note AS mentor_note_46,
  t0.mentor_admin_rating AS mentor_admin_rating_47,
  t0.active AS active_48,
  t0.tiefgarage AS tiefgarage_49,
  t0.transponder AS transponder_50,
  t0.isTransponderAllowed AS isTransponderAllowed_51,
  t0.imageLink AS imageLink_52,
  t0.homepage AS homepage_53,
  t0.xing AS xing_54,
  t0.pipedriveId AS pipedriveId_55,
  t0.linkedin AS linkedin_56,
  t0.facebook AS facebook_57,
  t0.instagram AS instagram_58,
  t0.twitter AS twitter_59,
  t0.skills AS skills_60,
  t0.description AS description_61,
  t0.touchpoints AS touchpoints_62,
  t0.isAddressComplete AS isAddressComplete_63,
  t0.hasMailchimp AS hasMailchimp_64,
  t0.hasKiNewsletter AS hasKiNewsletter_65,
  t0.enterDate AS enterDate_66,
  t0.exitDate AS exitDate_67,
  t0.physicalMembershipStarted AS physicalMembershipStarted_68,
  t0.physicalMembershipEnded AS physicalMembershipEnded_69,
  t0.lastModified AS lastModified_70,
  t0.lastChangeUser AS lastChangeUser_71,
  t0.nAiWebinarsAttended AS nAiWebinarsAttended_72,
  t0.nAiWebinarsApplied AS nAiWebinarsApplied_73,
  t0.nAiEventsAttended AS nAiEventsAttended_74,
  t0.nAiEventsApplied AS nAiEventsApplied_75,
  t0.nPaidAttended AS nPaidAttended_76,
  t0.nPaidApplied AS nPaidApplied_77,
  t0.nKiEinstiegAttended AS nKiEinstiegAttended_78,
  t0.nKiEinstiegApplied AS nKiEinstiegApplied_79,
  t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_80,
  t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_81,
  t0.nEcodynamicsAttended AS nEcodynamicsAttended_82,
  t0.nEcodynamicsApplied AS nEcodynamicsApplied_83,
  t0.nBbqApplied AS nBbqApplied_84,
  t0.nAiFridayApplied AS nAiFridayApplied_85,
  t0.nAiGatheringApplied AS nAiGatheringApplied_86,
  t0.nAiGatheringAttended AS nAiGatheringAttended_87,
  t0.aiSs24Applied AS aiSs24Applied_88,
  t0.aiSs24Booked AS aiSs24Booked_89,
  t0.interestedIn AS interestedIn_90,
  t0.interests AS interests_91,
  t0.mentorMetadata AS mentorMetadata_92,
  t0.eventParticipations AS eventParticipations_93,
  t0.kiKompetenz AS kiKompetenz_94,
  t0.mentorOwnerId AS mentorOwnerId_95
FROM
  aaa_sp_members t0
WHERE
  t0.id = ?