Failed: 35 queries executed, 34 expected Captured queries were: 1. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."offererAddressId" AS "stock_offererAddressId", stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", offer_1."jsonData" AS "offer_1_jsonData", venue_1.address AS venue_1_address, venue_1.street AS venue_1_street, venue_1."bannerUrl" AS "venue_1_bannerUrl", venue_1."bannerMeta" AS "venue_1_bannerMeta", address_1.id AS address_1_id, address_1."banId" AS "address_1_banId", address_1."inseeCode" AS "address_1_inseeCode", address_1.street AS address_1_street, address_1."postalCode" AS "address_1_postalCode", address_1.city AS address_1_city, address_1.latitude AS address_1_latitude, address_1.longitude AS address_1_longitude, address_1."departmentCode" AS "address_1_departmentCode", address_1.timezone AS address_1_timezone, address_1."isManualEdition" AS "address_1_isManualEdition", offerer_address_1.id AS offerer_address_1_id, offerer_address_1.label AS offerer_address_1_label, offerer_address_1."addressId" AS "offerer_address_1_addressId", offerer_address_1."offererId" AS "offerer_address_1_offererId", venue_1.id AS venue_1_id, venue_1."audioDisabilityCompliant" AS "venue_1_audioDisabilityCompliant", venue_1."mentalDisabilityCompliant" AS "venue_1_mentalDisabilityCompliant", venue_1."motorDisabilityCompliant" AS "venue_1_motorDisabilityCompliant", venue_1."visualDisabilityCompliant" AS "venue_1_visualDisabilityCompliant", venue_1."thumbCount" AS "venue_1_thumbCount", venue_1.name AS venue_1_name, venue_1.siret AS venue_1_siret, venue_1."departementCode" AS "venue_1_departementCode", venue_1.latitude AS venue_1_latitude, venue_1.longitude AS venue_1_longitude, venue_1."managingOffererId" AS "venue_1_managingOffererId", venue_1."bookingEmail" AS "venue_1_bookingEmail", venue_1."postalCode" AS "venue_1_postalCode", venue_1.city AS venue_1_city, venue_1."banId" AS "venue_1_banId", venue_1.timezone AS venue_1_timezone, venue_1."publicName" AS "venue_1_publicName", venue_1."isVisibleInApp" AS "venue_1_isVisibleInApp", venue_1."isVirtual" AS "venue_1_isVirtual", venue_1."isPermanent" AS "venue_1_isPermanent", venue_1.comment AS venue_1_comment, venue_1."venueTypeCode" AS "venue_1_venueTypeCode", venue_1."venueLabelId" AS "venue_1_venueLabelId", venue_1."dateCreated" AS "venue_1_dateCreated", venue_1."withdrawalDetails" AS "venue_1_withdrawalDetails", venue_1.description AS venue_1_description, venue_1."adageId" AS "venue_1_adageId", venue_1."adageInscriptionDate" AS "venue_1_adageInscriptionDate", venue_1."dmsToken" AS "venue_1_dmsToken", venue_1."venueEducationalStatusId" AS "venue_1_venueEducationalStatusId", venue_1."collectiveDescription" AS "venue_1_collectiveDescription", venue_1."collectiveStudents" AS "venue_1_collectiveStudents", venue_1."collectiveWebsite" AS "venue_1_collectiveWebsite", venue_1."collectiveInterventionArea" AS "venue_1_collectiveInterventionArea", venue_1."collectiveNetwork" AS "venue_1_collectiveNetwork", venue_1."collectiveAccessInformation" AS "venue_1_collectiveAccessInformation", venue_1."collectivePhone" AS "venue_1_collectivePhone", venue_1."collectiveEmail" AS "venue_1_collectiveEmail", venue_1."collectiveSubCategoryId" AS "venue_1_collectiveSubCategoryId", venue_1."offererAddressId" AS "venue_1_offererAddressId", address_2.id AS address_2_id, address_2."banId" AS "address_2_banId", address_2."inseeCode" AS "address_2_inseeCode", address_2.street AS address_2_street, address_2."postalCode" AS "address_2_postalCode", address_2.city AS address_2_city, address_2.latitude AS address_2_latitude, address_2.longitude AS address_2_longitude, address_2."departmentCode" AS "address_2_departmentCode", address_2.timezone AS address_2_timezone, address_2."isManualEdition" AS "address_2_isManualEdition", offerer_address_2.id AS offerer_address_2_id, offerer_address_2.label AS offerer_address_2_label, offerer_address_2."addressId" AS "offerer_address_2_addressId", offerer_address_2."offererId" AS "offerer_address_2_offererId", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId" FROM stock LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock."offerId" LEFT OUTER JOIN venue AS venue_1 ON venue_1.id = offer_1."venueId" LEFT OUTER JOIN offerer_address AS offerer_address_1 ON offerer_address_1.id = venue_1."offererAddressId" LEFT OUTER JOIN address AS address_1 ON address_1.id = offerer_address_1."addressId" LEFT OUTER JOIN offerer_address AS offerer_address_2 ON offerer_address_2.id = offer_1."offererAddressId" LEFT OUTER JOIN address AS address_2 ON address_2.id = offerer_address_2."addressId" WHERE stock.id = 8 2. SELECT EXISTS (SELECT 1 FROM booking WHERE booking."venueId" = 8) AS anon_1 3. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."offererAddressId" AS "stock_offererAddressId", stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId" FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" WHERE stock.id = 8 FOR UPDATE 4. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" FROM "user" WHERE "user".id = 11 5. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" FROM "user" WHERE "user".id = 11 FOR UPDATE 6. SELECT EXISTS (SELECT 1 FROM booking JOIN stock ON stock.id = booking."stockId" WHERE 11 = booking."userId" AND booking.status != CANCELLED AND stock."offerId" = 8) AS anon_1 7. SELECT venue.address AS venue_address, venue.street AS venue_street, venue."bannerUrl" AS "venue_bannerUrl", venue."bannerMeta" AS "venue_bannerMeta", venue.id AS venue_id, venue."audioDisabilityCompliant" AS "venue_audioDisabilityCompliant", venue."mentalDisabilityCompliant" AS "venue_mentalDisabilityCompliant", venue."motorDisabilityCompliant" AS "venue_motorDisabilityCompliant", venue."visualDisabilityCompliant" AS "venue_visualDisabilityCompliant", venue."thumbCount" AS "venue_thumbCount", venue.name AS venue_name, venue.siret AS venue_siret, venue."departementCode" AS "venue_departementCode", venue.latitude AS venue_latitude, venue.longitude AS venue_longitude, venue."managingOffererId" AS "venue_managingOffererId", venue."bookingEmail" AS "venue_bookingEmail", venue."postalCode" AS "venue_postalCode", venue.city AS venue_city, venue."banId" AS "venue_banId", venue.timezone AS venue_timezone, venue."publicName" AS "venue_publicName", venue."isVisibleInApp" AS "venue_isVisibleInApp", venue."isVirtual" AS "venue_isVirtual", venue."isPermanent" AS "venue_isPermanent", venue.comment AS venue_comment, venue."venueTypeCode" AS "venue_venueTypeCode", venue."venueLabelId" AS "venue_venueLabelId", venue."dateCreated" AS "venue_dateCreated", venue."withdrawalDetails" AS "venue_withdrawalDetails", venue.description AS venue_description, venue."adageId" AS "venue_adageId", venue."adageInscriptionDate" AS "venue_adageInscriptionDate", venue."dmsToken" AS "venue_dmsToken", venue."venueEducationalStatusId" AS "venue_venueEducationalStatusId", venue."collectiveDescription" AS "venue_collectiveDescription", venue."collectiveStudents" AS "venue_collectiveStudents", venue."collectiveWebsite" AS "venue_collectiveWebsite", venue."collectiveInterventionArea" AS "venue_collectiveInterventionArea", venue."collectiveNetwork" AS "venue_collectiveNetwork", venue."collectiveAccessInformation" AS "venue_collectiveAccessInformation", venue."collectivePhone" AS "venue_collectivePhone", venue."collectiveEmail" AS "venue_collectiveEmail", venue."collectiveSubCategoryId" AS "venue_collectiveSubCategoryId", venue."offererAddressId" AS "venue_offererAddressId" FROM venue WHERE venue.id = 8 8. SELECT offerer.address AS offerer_address, offerer.street AS offerer_street, offerer."isActive" AS "offerer_isActive", offerer.id AS offerer_id, offerer."postalCode" AS "offerer_postalCode", offerer.city AS offerer_city, offerer."validationStatus" AS "offerer_validationStatus", offerer."dateCreated" AS "offerer_dateCreated", offerer.name AS offerer_name, offerer.siren AS offerer_siren, offerer."dateValidated" AS "offerer_dateValidated", offerer."allowedOnAdage" AS "offerer_allowedOnAdage" FROM offerer WHERE offerer.id = 8 9. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type FROM deposit WHERE 11 = deposit."userId" 10. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId", stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."offererAddressId" AS "stock_1_offererAddressId", stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" WHERE booking."depositId" = 11 AND booking.status != CANCELLED 11. SELECT EXISTS (SELECT 1 FROM booking WHERE booking.token = R3RJUD) AS anon_1 12. UPDATE stock SET "dnBookedQuantity"=7 WHERE stock.id = 8 13. INSERT INTO booking ("dateCreated", "dateUsed", "stockId", "venueId", "offererId", quantity, token, "userId", amount, "priceCategoryLabel", "cancellationDate", "displayAsEnded", "cancellationLimitDate", "cancellationReason", "cancellationUserId", status, "validationAuthorType", "reimbursementDate", "depositId") VALUES (2024-09-19 21:10:10.608896, None, 8, 8, 8, 1, R3RJUD, 11, 10.00, None, None, None, None, None, None, CONFIRMED, None, None, 11) RETURNING booking.id 14. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" FROM "user" WHERE "user".id = 11 15. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."offererAddressId" AS "stock_offererAddressId", stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId" FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" WHERE stock.id = 8 16. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 13 17. SELECT external_booking.id AS external_booking_id, external_booking."bookingId" AS "external_booking_bookingId", external_booking.barcode AS external_booking_barcode, external_booking.seat AS external_booking_seat, external_booking.additional_information AS external_booking_additional_information FROM external_booking WHERE 13 = external_booking."bookingId" 18. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."offererAddressId" AS "stock_offererAddressId", stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId" FROM stock WHERE 8 = stock."offerId" 19. SELECT venue.address AS venue_address, venue.street AS venue_street, venue."bannerUrl" AS "venue_bannerUrl", venue."bannerMeta" AS "venue_bannerMeta", venue.id AS venue_id, venue."audioDisabilityCompliant" AS "venue_audioDisabilityCompliant", venue."mentalDisabilityCompliant" AS "venue_mentalDisabilityCompliant", venue."motorDisabilityCompliant" AS "venue_motorDisabilityCompliant", venue."visualDisabilityCompliant" AS "venue_visualDisabilityCompliant", venue."thumbCount" AS "venue_thumbCount", venue.name AS venue_name, venue.siret AS venue_siret, venue."departementCode" AS "venue_departementCode", venue.latitude AS venue_latitude, venue.longitude AS venue_longitude, venue."managingOffererId" AS "venue_managingOffererId", venue."bookingEmail" AS "venue_bookingEmail", venue."postalCode" AS "venue_postalCode", venue.city AS venue_city, venue."banId" AS "venue_banId", venue.timezone AS venue_timezone, venue."publicName" AS "venue_publicName", venue."isVisibleInApp" AS "venue_isVisibleInApp", venue."isVirtual" AS "venue_isVirtual", venue."isPermanent" AS "venue_isPermanent", venue.comment AS venue_comment, venue."venueTypeCode" AS "venue_venueTypeCode", venue."venueLabelId" AS "venue_venueLabelId", venue."dateCreated" AS "venue_dateCreated", venue."withdrawalDetails" AS "venue_withdrawalDetails", venue.description AS venue_description, venue."adageId" AS "venue_adageId", venue."adageInscriptionDate" AS "venue_adageInscriptionDate", venue."dmsToken" AS "venue_dmsToken", venue."venueEducationalStatusId" AS "venue_venueEducationalStatusId", venue."collectiveDescription" AS "venue_collectiveDescription", venue."collectiveStudents" AS "venue_collectiveStudents", venue."collectiveWebsite" AS "venue_collectiveWebsite", venue."collectiveInterventionArea" AS "venue_collectiveInterventionArea", venue."collectiveNetwork" AS "venue_collectiveNetwork", venue."collectiveAccessInformation" AS "venue_collectiveAccessInformation", venue."collectivePhone" AS "venue_collectivePhone", venue."collectiveEmail" AS "venue_collectiveEmail", venue."collectiveSubCategoryId" AS "venue_collectiveSubCategoryId", venue."offererAddressId" AS "venue_offererAddressId" FROM venue WHERE venue.id = 8 20. SELECT offerer.address AS offerer_address, offerer.street AS offerer_street, offerer."isActive" AS "offerer_isActive", offerer.id AS offerer_id, offerer."postalCode" AS "offerer_postalCode", offerer.city AS offerer_city, offerer."validationStatus" AS "offerer_validationStatus", offerer."dateCreated" AS "offerer_dateCreated", offerer.name AS offerer_name, offerer.siren AS offerer_siren, offerer."dateValidated" AS "offerer_dateValidated", offerer."allowedOnAdage" AS "offerer_allowedOnAdage" FROM offerer WHERE offerer.id = 8 21. SELECT provider."isActive" AS "provider_isActive", provider.id AS provider_id, provider.name AS provider_name, provider."localClass" AS "provider_localClass", provider."apiUrl" AS "provider_apiUrl", provider."authToken" AS "provider_authToken", provider."enabledForPro" AS "provider_enabledForPro", provider."enableParallelSynchronization" AS "provider_enableParallelSynchronization", provider."logoUrl" AS "provider_logoUrl", provider."bookingExternalUrl" AS "provider_bookingExternalUrl", provider."cancelExternalUrl" AS "provider_cancelExternalUrl", provider."notificationExternalUrl" AS "provider_notificationExternalUrl", provider."hmacKey" AS "provider_hmacKey", provider."pricesInCents" AS "provider_pricesInCents" FROM provider WHERE provider.id IS NULL AND provider."isActive" = true AND provider."enabledForPro" = true 22. SELECT venue.address AS venue_address, venue.street AS venue_street, venue."bannerUrl" AS "venue_bannerUrl", venue."bannerMeta" AS "venue_bannerMeta", bank_account.id AS bank_account_id, bank_account.status AS bank_account_status, venue_bank_account_link.id AS venue_bank_account_link_id, venue_bank_account_link.timespan AS venue_bank_account_link_timespan, venue.id AS venue_id, venue."audioDisabilityCompliant" AS "venue_audioDisabilityCompliant", venue."mentalDisabilityCompliant" AS "venue_mentalDisabilityCompliant", venue."motorDisabilityCompliant" AS "venue_motorDisabilityCompliant", venue."visualDisabilityCompliant" AS "venue_visualDisabilityCompliant", venue."thumbCount" AS "venue_thumbCount", venue.name AS venue_name, venue.siret AS venue_siret, venue."departementCode" AS "venue_departementCode", venue.latitude AS venue_latitude, venue.longitude AS venue_longitude, venue."managingOffererId" AS "venue_managingOffererId", venue."bookingEmail" AS "venue_bookingEmail", venue."postalCode" AS "venue_postalCode", venue.city AS venue_city, venue."banId" AS "venue_banId", venue.timezone AS venue_timezone, venue."publicName" AS "venue_publicName", venue."isVisibleInApp" AS "venue_isVisibleInApp", venue."isVirtual" AS "venue_isVirtual", venue."isPermanent" AS "venue_isPermanent", venue.comment AS venue_comment, venue."venueTypeCode" AS "venue_venueTypeCode", venue."venueLabelId" AS "venue_venueLabelId", venue."dateCreated" AS "venue_dateCreated", venue."withdrawalDetails" AS "venue_withdrawalDetails", venue.description AS venue_description, venue."adageId" AS "venue_adageId", venue."adageInscriptionDate" AS "venue_adageInscriptionDate", venue."dmsToken" AS "venue_dmsToken", venue."venueEducationalStatusId" AS "venue_venueEducationalStatusId", venue."collectiveDescription" AS "venue_collectiveDescription", venue."collectiveStudents" AS "venue_collectiveStudents", venue."collectiveWebsite" AS "venue_collectiveWebsite", venue."collectiveInterventionArea" AS "venue_collectiveInterventionArea", venue."collectiveNetwork" AS "venue_collectiveNetwork", venue."collectiveAccessInformation" AS "venue_collectiveAccessInformation", venue."collectivePhone" AS "venue_collectivePhone", venue."collectiveEmail" AS "venue_collectiveEmail", venue."collectiveSubCategoryId" AS "venue_collectiveSubCategoryId", venue."offererAddressId" AS "venue_offererAddressId" FROM venue LEFT OUTER JOIN venue_bank_account_link ON venue.id = venue_bank_account_link."venueId" AND (venue_bank_account_link.timespan @> 2024-09-19 21:10:10.627258) LEFT OUTER JOIN bank_account ON venue_bank_account_link."bankAccountId" = bank_account.id WHERE venue.id = 8 23. SELECT activation_code.id AS activation_code_id, activation_code."bookingId" AS "activation_code_bookingId", activation_code.code AS activation_code_code, activation_code."expirationDate" AS "activation_code_expirationDate", activation_code."stockId" AS "activation_code_stockId" FROM activation_code WHERE 13 = activation_code."bookingId" 24. SELECT criterion.id AS criterion_id, criterion.name AS criterion_name, criterion.description AS criterion_description, criterion."startDateTime" AS "criterion_startDateTime", criterion."endDateTime" AS "criterion_endDateTime" FROM criterion, offer_criterion WHERE 8 = offer_criterion."offerId" AND criterion.id = offer_criterion."criterionId" 25. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1."jsonData" AS "offer_1_jsonData", offer_1.id AS offer_1_id, offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."offererAddressId" AS "stock_1_offererAddressId", stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", venue_1.id AS venue_1_id, venue_1."isVirtual" AS "venue_1_isVirtual" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" LEFT OUTER JOIN venue AS venue_1 ON venue_1.id = booking."venueId" WHERE booking."userId" = 11 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC 26. SELECT favorite.id AS favorite_id, favorite."userId" AS "favorite_userId", favorite."offerId" AS "favorite_offerId", favorite."dateCreated" AS "favorite_dateCreated", offer_1.id AS offer_1_id, offer_1."subcategoryId" AS "offer_1_subcategoryId" FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" WHERE favorite."userId" = 11 ORDER BY favorite.id DESC 27. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type FROM deposit WHERE 11 = deposit."userId" 28. SELECT get_wallet_balance(11, False) AS get_wallet_balance_1 29. SELECT action_history."jsonData" AS "action_history_jsonData", action_history.id AS action_history_id, action_history."actionType" AS "action_history_actionType", action_history."actionDate" AS "action_history_actionDate", action_history."authorUserId" AS "action_history_authorUserId", action_history."userId" AS "action_history_userId", action_history."offererId" AS "action_history_offererId", action_history."venueId" AS "action_history_venueId", action_history."financeIncidentId" AS "action_history_financeIncidentId", action_history."bankAccountId" AS "action_history_bankAccountId", action_history."ruleId" AS "action_history_ruleId", action_history.comment AS action_history_comment FROM action_history WHERE 11 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST 30. SELECT "user".id AS user_id, "user"."firstName" AS "user_firstName", "user"."lastName" AS "user_lastName", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", user_offerer_1.id AS user_offerer_1_id, user_offerer_1."userId" AS "user_offerer_1_userId", user_offerer_1."offererId" AS "user_offerer_1_offererId", offerer_tag_1.id AS offerer_tag_1_id, offerer_tag_1.label AS offerer_tag_1_label, offerer_1."isActive" AS "offerer_1_isActive", offerer_1.id AS offerer_1_id, offerer_1."validationStatus" AS "offerer_1_validationStatus", offerer_1.name AS offerer_1_name, venue_label_1.id AS venue_label_1_id, venue_label_1.label AS venue_label_1_label, venue_1.id AS venue_1_id, venue_1.name AS venue_1_name, venue_1."departementCode" AS "venue_1_departementCode", venue_1."postalCode" AS "venue_1_postalCode", venue_1."publicName" AS "venue_1_publicName", venue_1."venueTypeCode" AS "venue_1_venueTypeCode", venue_1."venueLabelId" AS "venue_1_venueLabelId", venue_1."adageId" AS "venue_1_adageId", user_offerer_2.id AS user_offerer_2_id, user_offerer_2."validationStatus" AS "user_offerer_2_validationStatus", user_offerer_2."userId" AS "user_offerer_2_userId", user_offerer_2."offererId" AS "user_offerer_2_offererId" FROM "user" LEFT OUTER JOIN user_offerer AS user_offerer_2 ON "user".id = user_offerer_2."userId" LEFT OUTER JOIN offerer AS offerer_1 ON offerer_1.id = user_offerer_2."offererId" LEFT OUTER JOIN user_offerer AS user_offerer_1 ON offerer_1.id = user_offerer_1."offererId" LEFT OUTER JOIN (offerer_tag_mapping AS offerer_tag_mapping_1 JOIN offerer_tag AS offerer_tag_1 ON offerer_tag_1.id = offerer_tag_mapping_1."tagId") ON offerer_1.id = offerer_tag_mapping_1."offererId" LEFT OUTER JOIN venue AS venue_1 ON offerer_1.id = venue_1."managingOffererId" LEFT OUTER JOIN venue_label AS venue_label_1 ON venue_label_1.id = venue_1."venueLabelId" WHERE lower("user".email) = [email protected] AND ("user".roles @> ['PRO']::VARCHAR(20)[] OR "user".roles @> ['NON_ATTACHED_PRO']::VARCHAR(20)[]) AND "user"."isActive" IS true ORDER BY user_offerer_1.id 31. SELECT offerer.id AS offerer_id, offerer.name AS offerer_name, venue."bannerUrl" AS "venue_bannerUrl", venue.id AS venue_id, venue.name AS venue_name, venue."departementCode" AS "venue_departementCode", venue."postalCode" AS "venue_postalCode", venue."publicName" AS "venue_publicName", venue."isVirtual" AS "venue_isVirtual", venue."isPermanent" AS "venue_isPermanent", venue."venueTypeCode" AS "venue_venueTypeCode", venue."venueLabelId" AS "venue_venueLabelId", venue."adageId" AS "venue_adageId", offerer_tag_1.id AS offerer_tag_1_id, offerer_tag_1.label AS offerer_tag_1_label, venue_label_1.id AS venue_label_1_id, venue_label_1.label AS venue_label_1_label, bank_information_1.id AS bank_information_1_id, bank_information_1.status AS bank_information_1_status FROM venue JOIN offerer ON offerer.id = venue."managingOffererId" AND offerer."isActive" AND offerer."validationStatus" = VALIDATED LEFT OUTER JOIN (offerer_tag_mapping AS offerer_tag_mapping_1 JOIN offerer_tag AS offerer_tag_1 ON offerer_tag_1.id = offerer_tag_mapping_1."tagId") ON offerer.id = offerer_tag_mapping_1."offererId" LEFT OUTER JOIN venue_label AS venue_label_1 ON venue_label_1.id = venue."venueLabelId" LEFT OUTER JOIN bank_information AS bank_information_1 ON venue.id = bank_information_1."venueId" WHERE venue."bookingEmail" = [email protected] 32. SELECT EXISTS (SELECT 1 FROM collective_offer JOIN educational_institution ON educational_institution.id = collective_offer."institutionId" JOIN educational_institution_program_association AS educational_institution_program_association_1 ON educational_institution.id = educational_institution_program_association_1."institutionId" JOIN educational_institution_program ON educational_institution_program.id = educational_institution_program_association_1."programId" WHERE collective_offer."venueId" IN (8) AND collective_offer.validation = APPROVED AND educational_institution_program.name = marseille_en_grand) AS anon_1 33. SELECT EXISTS (SELECT 1 FROM offer WHERE offer."venueId" IN (8) AND CASE WHEN (offer.validation = REJECTED) THEN REJECTED WHEN (offer.validation = PENDING) THEN PENDING WHEN (offer.validation = DRAFT) THEN DRAFT WHEN (offer."isActive" IS false) THEN INACTIVE WHEN (((EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false)) AND NOT (EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false AND (stock."bookingLimitDatetime" IS NOT NULL AND stock."bookingLimitDatetime" <= now()) IS false))) IS true) THEN EXPIRED WHEN ((NOT (EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false AND (stock."beginningDatetime" > now() OR stock."beginningDatetime" IS NULL) AND (CASE WHEN (stock.quantity IS NULL) THEN NULL ELSE stock.quantity - stock."dnBookedQuantity" END IS NULL OR CASE WHEN (stock.quantity IS NULL) THEN NULL ELSE stock.quantity - stock."dnBookedQuantity" END > 0)))) IS true) THEN SOLD_OUT ELSE ACTIVE END = ACTIVE) AS anon_1 34. SELECT EXISTS (SELECT 1 FROM booking WHERE booking."venueId" IN (8) AND booking.status != CANCELLED) AS anon_1 35. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

❌ Tests reported 1 failures

Failed: 3 queries executed, 2 expected Captured queries were: 1. SELECT user_session.id AS user_session_id, user_session."userId" AS "user_session_userId", user_session.uuid AS user_session_uuid FROM user_session WHERE user_session."userId" = 803 AND user_session.uuid = b6c0923e-0aa1-42d6-ab6c-000a7bbd50bc 2. SELECT "user".id AS user_id, "user".email AS user_email, "user"."firstName" AS "user_firstName", "user"."lastName" AS "user_lastName", "user".roles AS user_roles, permission_1.id AS permission_1_id, permission_1.name AS permission_1_name, permission_1.category AS permission_1_category, role_1.id AS role_1_id, role_1.name AS role_1_name, backoffice_user_profile_1.id AS backoffice_user_profile_1_id, backoffice_user_profile_1."userId" AS "backoffice_user_profile_1_userId", backoffice_user_profile_1.preferences AS backoffice_user_profile_1_preferences FROM "user" LEFT OUTER JOIN backoffice_user_profile AS backoffice_user_profile_1 ON "user".id = backoffice_user_profile_1."userId" LEFT OUTER JOIN (role_backoffice_profile AS role_backoffice_profile_1 JOIN role AS role_1 ON role_1.id = role_backoffice_profile_1."roleId") ON backoffice_user_profile_1.id = role_backoffice_profile_1."profileId" LEFT OUTER JOIN (role_permission AS role_permission_1 JOIN permission AS permission_1 ON permission_1.id = role_permission_1."permissionId") ON role_1.id = role_permission_1."roleId" WHERE "user".id = 803 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 4 queries executed, 3 expected Captured queries were: 1. SELECT user_session.id AS user_session_id, user_session."userId" AS "user_session_userId", user_session.uuid AS user_session_uuid FROM user_session WHERE user_session."userId" = 832 AND user_session.uuid = d035bba3-ce70-4bfd-9bbb-a1c3e9052681 2. SELECT "user".id AS user_id, "user".email AS user_email, "user"."firstName" AS "user_firstName", "user"."lastName" AS "user_lastName", "user".roles AS user_roles, permission_1.id AS permission_1_id, permission_1.name AS permission_1_name, permission_1.category AS permission_1_category, role_1.id AS role_1_id, role_1.name AS role_1_name, backoffice_user_profile_1.id AS backoffice_user_profile_1_id, backoffice_user_profile_1."userId" AS "backoffice_user_profile_1_userId", backoffice_user_profile_1.preferences AS backoffice_user_profile_1_preferences FROM "user" LEFT OUTER JOIN backoffice_user_profile AS backoffice_user_profile_1 ON "user".id = backoffice_user_profile_1."userId" LEFT OUTER JOIN (role_backoffice_profile AS role_backoffice_profile_1 JOIN role AS role_1 ON role_1.id = role_backoffice_profile_1."roleId") ON backoffice_user_profile_1.id = role_backoffice_profile_1."profileId" LEFT OUTER JOIN (role_permission AS role_permission_1 JOIN permission AS permission_1 ON permission_1.id = role_permission_1."permissionId") ON role_1.id = role_permission_1."roleId" WHERE "user".id = 832 3. SELECT anon_1.anon_2_collective_booking_id AS anon_1_anon_2_collective_booking_id, anon_1."anon_2_collective_booking_dateCreated" AS "anon_1_anon_2_collective_booking_dateCreated", anon_1."anon_2_collective_booking_dateUsed" AS "anon_1_anon_2_collective_booking_dateUsed", anon_1."anon_2_collective_booking_collectiveStockId" AS "anon_1_anon_2_collective_booking_collectiveStockId", anon_1."anon_2_collective_booking_venueId" AS "anon_1_anon_2_collective_booking_venueId", anon_1."anon_2_collective_booking_offererId" AS "anon_1_anon_2_collective_booking_offererId", anon_1."anon_2_collective_booking_cancellationDate" AS "anon_1_anon_2_collective_booking_cancellationDate", anon_1."anon_2_collective_booking_cancellationUserId" AS "anon_1_anon_2_collective_booking_cancellationUserId", anon_1."anon_2_collective_booking_cancellationLimitDate" AS "anon_1_anon_2_collective_booking_cancellationLimitDate", anon_1."anon_2_collective_booking_cancellationReason" AS "anon_1_anon_2_collective_booking_cancellationReason", anon_1.anon_2_collective_booking_status AS anon_1_anon_2_collective_booking_status, anon_1."anon_2_collective_booking_reimbursementDate" AS "anon_1_anon_2_collective_booking_reimbursementDate", anon_1."anon_2_collective_booking_educationalInstitutionId" AS "anon_1_anon_2_collective_booking_educationalInstitutionId", anon_1."anon_2_collective_booking_educationalYearId" AS "anon_1_anon_2_collective_booking_educationalYearId", anon_1."anon_2_collective_booking_confirmationDate" AS "anon_1_anon_2_collective_booking_confirmationDate", anon_1."anon_2_collective_booking_confirmationLimitDate" AS "anon_1_anon_2_collective_booking_confirmationLimitDate", anon_1."anon_2_collective_booking_educationalRedactorId" AS "anon_1_anon_2_collective_booking_educationalRedactorId", collective_offer_1.id AS collective_offer_1_id, collective_offer_1.name AS collective_offer_1_name, collective_offer_1.formats AS collective_offer_1_formats, collective_stock_1.id AS collective_stock_1_id, collective_stock_1."beginningDatetime" AS "collective_stock_1_beginningDatetime", collective_stock_1."startDatetime" AS "collective_stock_1_startDatetime", collective_stock_1."endDatetime" AS "collective_stock_1_endDatetime", collective_stock_1."collectiveOfferId" AS "collective_stock_1_collectiveOfferId", collective_stock_1.price AS collective_stock_1_price, collective_stock_1."bookingLimitDatetime" AS "collective_stock_1_bookingLimitDatetime", collective_stock_1."numberOfTickets" AS "collective_stock_1_numberOfTickets", venue_1.id AS venue_1_id, venue_1.name AS venue_1_name, venue_1."managingOffererId" AS "venue_1_managingOffererId", venue_1."publicName" AS "venue_1_publicName", venue_1."isVirtual" AS "venue_1_isVirtual", offerer_1.id AS offerer_1_id, offerer_1.name AS offerer_1_name, educational_institution_1.id AS educational_institution_1_id, educational_institution_1."institutionId" AS "educational_institution_1_institutionId", educational_institution_1."institutionType" AS "educational_institution_1_institutionType", educational_institution_1.name AS educational_institution_1_name, educational_institution_1.city AS educational_institution_1_city, educational_redactor_1.id AS educational_redactor_1_id, educational_redactor_1."firstName" AS "educational_redactor_1_firstName", educational_redactor_1."lastName" AS "educational_redactor_1_lastName", cashflow_batch_1.id AS cashflow_batch_1_id, cashflow_batch_1.label AS cashflow_batch_1_label, cashflow_1.id AS cashflow_1_id, cashflow_1."batchId" AS "cashflow_1_batchId", pricing_1.id AS pricing_1_id, pricing_1.status AS pricing_1_status, pricing_1."creationDate" AS "pricing_1_creationDate", pricing_1.amount AS pricing_1_amount, finance_incident_1.id AS finance_incident_1_id, finance_incident_1.status AS finance_incident_1_status, booking_finance_incident_1.id AS booking_finance_incident_1_id, booking_finance_incident_1."bookingId" AS "booking_finance_incident_1_bookingId", booking_finance_incident_1."collectiveBookingId" AS "booking_finance_incident_1_collectiveBookingId", booking_finance_incident_1."incidentId" AS "booking_finance_incident_1_incidentId", booking_finance_incident_1."beneficiaryId" AS "booking_finance_incident_1_beneficiaryId", booking_finance_incident_1."newTotalAmount" AS "booking_finance_incident_1_newTotalAmount" FROM (SELECT anon_2.collective_booking_id AS anon_2_collective_booking_id, anon_2."collective_booking_dateCreated" AS "anon_2_collective_booking_dateCreated", anon_2."collective_booking_dateUsed" AS "anon_2_collective_booking_dateUsed", anon_2."collective_booking_collectiveStockId" AS "anon_2_collective_booking_collectiveStockId", anon_2."collective_booking_venueId" AS "anon_2_collective_booking_venueId", anon_2."collective_booking_offererId" AS "anon_2_collective_booking_offererId", anon_2."collective_booking_cancellationDate" AS "anon_2_collective_booking_cancellationDate", anon_2."collective_booking_cancellationUserId" AS "anon_2_collective_booking_cancellationUserId", anon_2."collective_booking_cancellationLimitDate" AS "anon_2_collective_booking_cancellationLimitDate", anon_2."collective_booking_cancellationReason" AS "anon_2_collective_booking_cancellationReason", anon_2.collective_booking_status AS anon_2_collective_booking_status, anon_2."collective_booking_reimbursementDate" AS "anon_2_collective_booking_reimbursementDate", anon_2."collective_booking_educationalInstitutionId" AS "anon_2_collective_booking_educationalInstitutionId", anon_2."collective_booking_educationalYearId" AS "anon_2_collective_booking_educationalYearId", anon_2."collective_booking_confirmationDate" AS "anon_2_collective_booking_confirmationDate", anon_2."collective_booking_confirmationLimitDate" AS "anon_2_collective_booking_confirmationLimitDate", anon_2."collective_booking_educationalRedactorId" AS "anon_2_collective_booking_educationalRedactorId" FROM (SELECT collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "collective_booking_dateCreated", collective_booking."dateUsed" AS "collective_booking_dateUsed", collective_booking."collectiveStockId" AS "collective_booking_collectiveStockId", collective_booking."venueId" AS "collective_booking_venueId", collective_booking."offererId" AS "collective_booking_offererId", collective_booking."cancellationDate" AS "collective_booking_cancellationDate", collective_booking."cancellationUserId" AS "collective_booking_cancellationUserId", collective_booking."cancellationLimitDate" AS "collective_booking_cancellationLimitDate", collective_booking."cancellationReason" AS "collective_booking_cancellationReason", collective_booking.status AS collective_booking_status, collective_booking."reimbursementDate" AS "collective_booking_reimbursementDate", collective_booking."educationalInstitutionId" AS "collective_booking_educationalInstitutionId", collective_booking."educationalYearId" AS "collective_booking_educationalYearId", collective_booking."confirmationDate" AS "collective_booking_confirmationDate", collective_booking."confirmationLimitDate" AS "collective_booking_confirmationLimitDate", collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE collective_booking.id = 59000 UNION SELECT collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "collective_booking_dateCreated", collective_booking."dateUsed" AS "collective_booking_dateUsed", collective_booking."collectiveStockId" AS "collective_booking_collectiveStockId", collective_booking."venueId" AS "collective_booking_venueId", collective_booking."offererId" AS "collective_booking_offererId", collective_booking."cancellationDate" AS "collective_booking_cancellationDate", collective_booking."cancellationUserId" AS "collective_booking_cancellationUserId", collective_booking."cancellationLimitDate" AS "collective_booking_cancellationLimitDate", collective_booking."cancellationReason" AS "collective_booking_cancellationReason", collective_booking.status AS collective_booking_status, collective_booking."reimbursementDate" AS "collective_booking_reimbursementDate", collective_booking."educationalInstitutionId" AS "collective_booking_educationalInstitutionId", collective_booking."educationalYearId" AS "collective_booking_educationalYearId", collective_booking."confirmationDate" AS "collective_booking_confirmationDate", collective_booking."confirmationLimitDate" AS "collective_booking_confirmationLimitDate", collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE collective_offer.id = 59000) AS anon_2 LIMIT 101) AS anon_1 LEFT OUTER JOIN collective_stock AS collective_stock_1 ON collective_stock_1.id = anon_1."anon_2_collective_booking_collectiveStockId" LEFT OUTER JOIN collective_offer AS collective_offer_1 ON collective_offer_1.id = collective_stock_1."collectiveOfferId" LEFT OUTER JOIN venue AS venue_1 ON venue_1.id = anon_1."anon_2_collective_booking_venueId" LEFT OUTER JOIN offerer AS offerer_1 ON offerer_1.id = anon_1."anon_2_collective_booking_offererId" LEFT OUTER JOIN educational_institution AS educational_institution_1 ON educational_institution_1.id = anon_1."anon_2_collective_booking_educationalInstitutionId" LEFT OUTER JOIN educational_redactor AS educational_redactor_1 ON educational_redactor_1.id = anon_1."anon_2_collective_booking_educationalRedactorId" LEFT OUTER JOIN pricing AS pricing_1 ON anon_1.anon_2_collective_booking_id = pricing_1."collectiveBookingId" LEFT OUTER JOIN (cashflow_pricing AS cashflow_pricing_1 JOIN cashflow AS cashflow_1 ON cashflow_1.id = cashflow_pricing_1."cashflowId") ON pricing_1.id = cashflow_pricing_1."pricingId" LEFT OUTER JOIN cashflow_batch AS cashflow_batch_1 ON cashflow_batch_1.id = cashflow_1."batchId" LEFT OUTER JOIN booking_finance_incident AS booking_finance_incident_1 ON anon_1.anon_2_collective_booking_id = booking_finance_incident_1."collectiveBookingId" LEFT OUTER JOIN finance_incident AS finance_incident_1 ON finance_incident_1.id = booking_finance_incident_1."incidentId" 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 3 queries executed, 2 expected Captured queries were: 1. SELECT user_session.id AS user_session_id, user_session."userId" AS "user_session_userId", user_session.uuid AS user_session_uuid FROM user_session WHERE user_session."userId" = 851 AND user_session.uuid = abb638db-aa09-4c60-b416-1042079e61d9 2. SELECT "user".id AS user_id, "user".email AS user_email, "user"."firstName" AS "user_firstName", "user"."lastName" AS "user_lastName", "user".roles AS user_roles, permission_1.id AS permission_1_id, permission_1.name AS permission_1_name, permission_1.category AS permission_1_category, role_1.id AS role_1_id, role_1.name AS role_1_name, backoffice_user_profile_1.id AS backoffice_user_profile_1_id, backoffice_user_profile_1."userId" AS "backoffice_user_profile_1_userId", backoffice_user_profile_1.preferences AS backoffice_user_profile_1_preferences FROM "user" LEFT OUTER JOIN backoffice_user_profile AS backoffice_user_profile_1 ON "user".id = backoffice_user_profile_1."userId" LEFT OUTER JOIN (role_backoffice_profile AS role_backoffice_profile_1 JOIN role AS role_1 ON role_1.id = role_backoffice_profile_1."roleId") ON backoffice_user_profile_1.id = role_backoffice_profile_1."profileId" LEFT OUTER JOIN (role_permission AS role_permission_1 JOIN permission AS permission_1 ON permission_1.id = role_permission_1."permissionId") ON role_1.id = role_permission_1."roleId" WHERE "user".id = 851 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

❌ Tests reported 3 failures

Running tests api with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi-tests:5a605df77cc9cc734abf19c4323fde8c2e4a341f

Running update api client template with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:5a605df77cc9cc734abf19c4323fde8c2e4a341f

Running e2e-tests with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:5a605df77cc9cc734abf19c4323fde8c2e4a341f

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-node@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: actions/setup-node@v2, actions/cache@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: technote-space/workflow-conclusion-action@v3, docker/login-action@v1, actions/setup-node@v3, actions/cache@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The "process_gcloudignore" option is true, but no .gcloudignore file was found. If you do not intend to process a gcloudignore file, set "process_gcloudignore" to false.

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/

The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/