SELECTt0.idASid_1,t0.startupIdASstartupId_2,t0.programIdASprogramId_3,t0.batchIdASbatchId_4,t0.utm_sourceASutm_source_5,t0.utm_mediumASutm_medium_6,t0.utm_campaignASutm_campaign_7,t0.utm_termASutm_term_8,t0.utm_contentASutm_content_9,t0.votesRegisteredASvotesRegistered_10,t0.programNameASprogramName_11,t0.programSlugASprogramSlug_12,t0.batchNameASbatchName_13,t0.batchSlugASbatchSlug_14,t0.templateAStemplate_15,t0.teamIdASteamId_16,t0.memberIdASmemberId_17,t0.langASlang_18,t0.startupNameASstartupName_19,t0.visibilityASvisibility_20,t0.firstNameASfirstName_21,t0.lastNameASlastName_22,t0.personASperson_23,t0.emailASemail_24,t0.secondaryEmailASsecondaryEmail_25,t0.phoneASphone_26,t0.linkedinASlinkedin_27,t0.telegramAStelegram_28,t0.discordASdiscord_29,t0.walletASwallet_30,t0.priceinEuroCentASpriceinEuroCent_31,t0.realPriceinEuroCentASrealPriceinEuroCent_32,t0.discountPercentASdiscountPercent_33,t0.discountReasonASdiscountReason_34,t0.teamSizeASteamSize_35,t0.cityAScity_36,t0.startupStageASstartupStage_37,t0.industryASindustry_38,t0.trackAStrack_39,t0.projectCategoryASprojectCategory_40,t0.blockchainASblockchain_41,t0.recommendedByASrecommendedBy_42,t0.editStatusASeditStatus_43,t0.editMessageASeditMessage_44,t0.applicationStatusASapplicationStatus_45,t0.reviewStatusASreviewStatus_46,t0.applicantTypeASapplicantType_47,t0.canReadListAScanReadList_48,t0.isSittingASisSitting_49,t0.isNewMemberASisNewMember_50,t0.hasNewsletterPermissionGivenAShasNewsletterPermissionGiven_51,t0.hasConfirmationMailSentAShasConfirmationMailSent_52,t0.hasTermsAcceptedAShasTermsAccepted_53,t0.hasPaidAShasPaid_54,t0.hasVolunteerAgreedAShasVolunteerAgreed_55,t0.hasEmailValidatedAShasEmailValidated_56,t0.batchStatusASbatchStatus_57,t0.selectionStatusASselectionStatus_58,t0.participationStatusASparticipationStatus_59,t0.coachMemberIdAScoachMemberId_60,t0.participationStartedAtASparticipationStartedAt_61,t0.participationCompletedAtASparticipationCompletedAt_62,t0.pitchPositionASpitchPosition_63,t0.pitchImageLinkASpitchImageLink_64,t0.pitchVideoLinkASpitchVideoLink_65,t0.linkPitchDeckASlinkPitchDeck_66,t0.publicIdPitchDeckASpublicIdPitchDeck_67,t0.ideaPaperUrlASideaPaperUrl_68,t0.publicIdIdeaPaperASpublicIdIdeaPaper_69,t0.websiteUrlASwebsiteUrl_70,t0.fulltimeASfulltime_71,t0.languageASlanguage_72,t0.mvpStatusASmvpStatus_73,t0.dealroomUrlASdealroomUrl_74,t0.podioIdASpodioId_75,t0.podioItemIdASpodioItemId_76,t0.podioUrlASpodioUrl_77,t0.ideaPitchASideaPitch_78,t0.createdAtAScreatedAt_79,t0.lastModifiedASlastModified_80,t0.deletedAtASdeletedAt_81,t0.lastChangeUserASlastChangeUser_82,t0.historyAShistory_83,t0.extraFieldsASextraFields_84,t0.adminNotesASadminNotes_85,t0.ratingJudge1ASratingJudge1_86,t0.ratingJudge2ASratingJudge2_87,t0.ratingJudge3ASratingJudge3_88,t0.ratingJudge4ASratingJudge4_89,t0.ratingJudge5ASratingJudge5_90,t0.ratingAverageASratingAverage_91,t0.ratingUpdatedAtASratingUpdatedAt_92,t0.memberTagsAtRegistrationASmemberTagsAtRegistration_93,t0.wasCommunityMemberAtRegistrationASwasCommunityMemberAtRegistration_94,t0.wasPhysicalMemberAtRegistrationASwasPhysicalMemberAtRegistration_95,t0.memberUtmSourceAtRegistrationASmemberUtmSourceAtRegistration_96,t0.kiKompetenzAtRegistrationASkiKompetenzAtRegistration_97,t0.pendingMemberDataASpendingMemberData_98,t0.pendingTeamDataASpendingTeamData_99,t0.resumeTokenASresumeToken_100,t0.resumeTokenExpiresAtASresumeTokenExpiresAt_101,t0.isMemberCreatedASisMemberCreated_102,t0.isTeamCreatedASisTeamCreated_103FROMsp_applicationst0WHEREt0.teamId=?ANDt0.programIdIN (?) AND ((t0.deletedAtISNULL))
SELECTt0.idASid_1,t0.startupIdASstartupId_2,t0.programIdASprogramId_3,t0.batchIdASbatchId_4,t0.utm_sourceASutm_source_5,t0.utm_mediumASutm_medium_6,t0.utm_campaignASutm_campaign_7,t0.utm_termASutm_term_8,t0.utm_contentASutm_content_9,t0.votesRegisteredASvotesRegistered_10,t0.programNameASprogramName_11,t0.programSlugASprogramSlug_12,t0.batchNameASbatchName_13,t0.batchSlugASbatchSlug_14,t0.templateAStemplate_15,t0.teamIdASteamId_16,t0.memberIdASmemberId_17,t0.langASlang_18,t0.startupNameASstartupName_19,t0.visibilityASvisibility_20,t0.firstNameASfirstName_21,t0.lastNameASlastName_22,t0.personASperson_23,t0.emailASemail_24,t0.secondaryEmailASsecondaryEmail_25,t0.phoneASphone_26,t0.linkedinASlinkedin_27,t0.telegramAStelegram_28,t0.discordASdiscord_29,t0.walletASwallet_30,t0.priceinEuroCentASpriceinEuroCent_31,t0.realPriceinEuroCentASrealPriceinEuroCent_32,t0.discountPercentASdiscountPercent_33,t0.discountReasonASdiscountReason_34,t0.teamSizeASteamSize_35,t0.cityAScity_36,t0.startupStageASstartupStage_37,t0.industryASindustry_38,t0.trackAStrack_39,t0.projectCategoryASprojectCategory_40,t0.blockchainASblockchain_41,t0.recommendedByASrecommendedBy_42,t0.editStatusASeditStatus_43,t0.editMessageASeditMessage_44,t0.applicationStatusASapplicationStatus_45,t0.reviewStatusASreviewStatus_46,t0.applicantTypeASapplicantType_47,t0.canReadListAScanReadList_48,t0.isSittingASisSitting_49,t0.isNewMemberASisNewMember_50,t0.hasNewsletterPermissionGivenAShasNewsletterPermissionGiven_51,t0.hasConfirmationMailSentAShasConfirmationMailSent_52,t0.hasTermsAcceptedAShasTermsAccepted_53,t0.hasPaidAShasPaid_54,t0.hasVolunteerAgreedAShasVolunteerAgreed_55,t0.hasEmailValidatedAShasEmailValidated_56,t0.batchStatusASbatchStatus_57,t0.selectionStatusASselectionStatus_58,t0.participationStatusASparticipationStatus_59,t0.coachMemberIdAScoachMemberId_60,t0.participationStartedAtASparticipationStartedAt_61,t0.participationCompletedAtASparticipationCompletedAt_62,t0.pitchPositionASpitchPosition_63,t0.pitchImageLinkASpitchImageLink_64,t0.pitchVideoLinkASpitchVideoLink_65,t0.linkPitchDeckASlinkPitchDeck_66,t0.publicIdPitchDeckASpublicIdPitchDeck_67,t0.ideaPaperUrlASideaPaperUrl_68,t0.publicIdIdeaPaperASpublicIdIdeaPaper_69,t0.websiteUrlASwebsiteUrl_70,t0.fulltimeASfulltime_71,t0.languageASlanguage_72,t0.mvpStatusASmvpStatus_73,t0.dealroomUrlASdealroomUrl_74,t0.podioIdASpodioId_75,t0.podioItemIdASpodioItemId_76,t0.podioUrlASpodioUrl_77,t0.ideaPitchASideaPitch_78,t0.createdAtAScreatedAt_79,t0.lastModifiedASlastModified_80,t0.deletedAtASdeletedAt_81,t0.lastChangeUserASlastChangeUser_82,t0.historyAShistory_83,t0.extraFieldsASextraFields_84,t0.adminNotesASadminNotes_85,t0.ratingJudge1ASratingJudge1_86,t0.ratingJudge2ASratingJudge2_87,t0.ratingJudge3ASratingJudge3_88,t0.ratingJudge4ASratingJudge4_89,t0.ratingJudge5ASratingJudge5_90,t0.ratingAverageASratingAverage_91,t0.ratingUpdatedAtASratingUpdatedAt_92,t0.memberTagsAtRegistrationASmemberTagsAtRegistration_93,t0.wasCommunityMemberAtRegistrationASwasCommunityMemberAtRegistration_94,t0.wasPhysicalMemberAtRegistrationASwasPhysicalMemberAtRegistration_95,t0.memberUtmSourceAtRegistrationASmemberUtmSourceAtRegistration_96,t0.kiKompetenzAtRegistrationASkiKompetenzAtRegistration_97,t0.pendingMemberDataASpendingMemberData_98,t0.pendingTeamDataASpendingTeamData_99,t0.resumeTokenASresumeToken_100,t0.resumeTokenExpiresAtASresumeTokenExpiresAt_101,t0.isMemberCreatedASisMemberCreated_102,t0.isTeamCreatedASisTeamCreated_103FROMsp_applicationst0WHEREt0.teamId=?ANDt0.programIdIN (?)
AND (
(t0.deletedAtISNULL)
)
SELECTt0.idASid_1,t0.startupIdASstartupId_2,t0.programIdASprogramId_3,t0.batchIdASbatchId_4,t0.utm_sourceASutm_source_5,t0.utm_mediumASutm_medium_6,t0.utm_campaignASutm_campaign_7,t0.utm_termASutm_term_8,t0.utm_contentASutm_content_9,t0.votesRegisteredASvotesRegistered_10,t0.programNameASprogramName_11,t0.programSlugASprogramSlug_12,t0.batchNameASbatchName_13,t0.batchSlugASbatchSlug_14,t0.templateAStemplate_15,t0.teamIdASteamId_16,t0.memberIdASmemberId_17,t0.langASlang_18,t0.startupNameASstartupName_19,t0.visibilityASvisibility_20,t0.firstNameASfirstName_21,t0.lastNameASlastName_22,t0.personASperson_23,t0.emailASemail_24,t0.secondaryEmailASsecondaryEmail_25,t0.phoneASphone_26,t0.linkedinASlinkedin_27,t0.telegramAStelegram_28,t0.discordASdiscord_29,t0.walletASwallet_30,t0.priceinEuroCentASpriceinEuroCent_31,t0.realPriceinEuroCentASrealPriceinEuroCent_32,t0.discountPercentASdiscountPercent_33,t0.discountReasonASdiscountReason_34,t0.teamSizeASteamSize_35,t0.cityAScity_36,t0.startupStageASstartupStage_37,t0.industryASindustry_38,t0.trackAStrack_39,t0.projectCategoryASprojectCategory_40,t0.blockchainASblockchain_41,t0.recommendedByASrecommendedBy_42,t0.editStatusASeditStatus_43,t0.editMessageASeditMessage_44,t0.applicationStatusASapplicationStatus_45,t0.reviewStatusASreviewStatus_46,t0.applicantTypeASapplicantType_47,t0.canReadListAScanReadList_48,t0.isSittingASisSitting_49,t0.isNewMemberASisNewMember_50,t0.hasNewsletterPermissionGivenAShasNewsletterPermissionGiven_51,t0.hasConfirmationMailSentAShasConfirmationMailSent_52,t0.hasTermsAcceptedAShasTermsAccepted_53,t0.hasPaidAShasPaid_54,t0.hasVolunteerAgreedAShasVolunteerAgreed_55,t0.hasEmailValidatedAShasEmailValidated_56,t0.batchStatusASbatchStatus_57,t0.selectionStatusASselectionStatus_58,t0.participationStatusASparticipationStatus_59,t0.coachMemberIdAScoachMemberId_60,t0.participationStartedAtASparticipationStartedAt_61,t0.participationCompletedAtASparticipationCompletedAt_62,t0.pitchPositionASpitchPosition_63,t0.pitchImageLinkASpitchImageLink_64,t0.pitchVideoLinkASpitchVideoLink_65,t0.linkPitchDeckASlinkPitchDeck_66,t0.publicIdPitchDeckASpublicIdPitchDeck_67,t0.ideaPaperUrlASideaPaperUrl_68,t0.publicIdIdeaPaperASpublicIdIdeaPaper_69,t0.websiteUrlASwebsiteUrl_70,t0.fulltimeASfulltime_71,t0.languageASlanguage_72,t0.mvpStatusASmvpStatus_73,t0.dealroomUrlASdealroomUrl_74,t0.podioIdASpodioId_75,t0.podioItemIdASpodioItemId_76,t0.podioUrlASpodioUrl_77,t0.ideaPitchASideaPitch_78,t0.createdAtAScreatedAt_79,t0.lastModifiedASlastModified_80,t0.deletedAtASdeletedAt_81,t0.lastChangeUserASlastChangeUser_82,t0.historyAShistory_83,t0.extraFieldsASextraFields_84,t0.adminNotesASadminNotes_85,t0.ratingJudge1ASratingJudge1_86,t0.ratingJudge2ASratingJudge2_87,t0.ratingJudge3ASratingJudge3_88,t0.ratingJudge4ASratingJudge4_89,t0.ratingJudge5ASratingJudge5_90,t0.ratingAverageASratingAverage_91,t0.ratingUpdatedAtASratingUpdatedAt_92,t0.memberTagsAtRegistrationASmemberTagsAtRegistration_93,t0.wasCommunityMemberAtRegistrationASwasCommunityMemberAtRegistration_94,t0.wasPhysicalMemberAtRegistrationASwasPhysicalMemberAtRegistration_95,t0.memberUtmSourceAtRegistrationASmemberUtmSourceAtRegistration_96,t0.kiKompetenzAtRegistrationASkiKompetenzAtRegistration_97,t0.pendingMemberDataASpendingMemberData_98,t0.pendingTeamDataASpendingTeamData_99,t0.resumeTokenASresumeToken_100,t0.resumeTokenExpiresAtASresumeTokenExpiresAt_101,t0.isMemberCreatedASisMemberCreated_102,t0.isTeamCreatedASisTeamCreated_103FROMsp_applicationst0WHEREt0.teamId=20885ANDt0.programIdIN ('1','2','3') AND ((t0.deletedAtISNULL));
19.10 ms (20.34%)
1
SELECTs0_.startupNameASstartupName_0,s0_.pitchPositionASpitchPosition_1,s0_.programNameASprogramName_2,s0_.batchNameASbatchName_3,s1_.pitchDateASpitchDate_4,s1_.cityAScity_5FROMsp_applicationss0_INNER JOINsp_batchess1_ON (s0_.batchId=s1_.id) WHERE (s0_.startupId=?ANDs0_.programId=?) AND (s0_.deletedAtISNULL)
SELECTs0_.startupNameASstartupName_0,s0_.pitchPositionASpitchPosition_1,s0_.programNameASprogramName_2,s0_.batchNameASbatchName_3,s1_.pitchDateASpitchDate_4,s1_.cityAScity_5FROMsp_applicationss0_INNER JOINsp_batchess1_ON (s0_.batchId=s1_.id)
WHERE
(
s0_.startupId=?ANDs0_.programId=?
)
AND (s0_.deletedAtISNULL)
SELECTs0_.startupNameASstartupName_0,s0_.pitchPositionASpitchPosition_1,s0_.programNameASprogramName_2,s0_.batchNameASbatchName_3,s1_.pitchDateASpitchDate_4,s1_.cityAScity_5FROMsp_applicationss0_INNER JOINsp_batchess1_ON (s0_.batchId=s1_.id) WHERE (s0_.startupId='3001817'ANDs0_.programId=1) AND (s0_.deletedAtISNULL);
The field 'App\StartPlatz\Bundle\StartupBundle\Entity\Application#ratingAverage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
The field App\StartPlatz\Bundle\StartupBundle\Entity\Application#assessments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment#application does not contain the required 'inversedBy="assessments"' attribute.