tests/core/bookings/test_api.py:193: in test_create_booking
    with assert_num_queries(num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 35 queries executed, 34 expected
E   Captured queries were:
E   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" 
E       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" 
E       WHERE stock.id = 8
E   2. SELECT EXISTS (SELECT 1 
E       FROM booking 
E       WHERE booking."venueId" = 8) AS anon_1
E   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" 
E       FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" 
E       WHERE stock.id = 8 FOR UPDATE
E   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" 
E       FROM "user" 
E       WHERE "user".id = 11
E   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" 
E       FROM "user" 
E       WHERE "user".id = 11 FOR UPDATE
E   6. SELECT EXISTS (SELECT 1 
E       FROM booking JOIN stock ON stock.id = booking."stockId" 
E       WHERE 11 = booking."userId" AND booking.status != CANCELLED AND stock."offerId" = 8) AS anon_1
E   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" 
E       FROM venue 
E       WHERE venue.id = 8
E   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" 
E       FROM offerer 
E       WHERE offerer.id = 8
E   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 
E       FROM deposit 
E       WHERE 11 = deposit."userId"
E   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" 
E       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" 
E       WHERE booking."depositId" = 11 AND booking.status != CANCELLED
E   11. SELECT EXISTS (SELECT 1 
E       FROM booking 
E       WHERE booking.token = R3RJUD) AS anon_1
E   12. UPDATE stock SET "dnBookedQuantity"=7 WHERE stock.id = 8
E   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
E   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" 
E       FROM "user" 
E       WHERE "user".id = 11
E   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" 
E       FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" 
E       WHERE stock.id = 8
E   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" 
E       FROM booking 
E       WHERE booking.id = 13
E   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 
E       FROM external_booking 
E       WHERE 13 = external_booking."bookingId"
E   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" 
E       FROM stock 
E       WHERE 8 = stock."offerId"
E   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" 
E       FROM venue 
E       WHERE venue.id = 8
E   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" 
E       FROM offerer 
E       WHERE offerer.id = 8
E   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" 
E       FROM provider 
E       WHERE provider.id IS NULL AND provider."isActive" = true AND provider."enabledForPro" = true
E   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" 
E       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 
E       WHERE venue.id = 8
E   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" 
E       FROM activation_code 
E       WHERE 13 = activation_code."bookingId"
E   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" 
E       FROM criterion, offer_criterion 
E       WHERE 8 = offer_criterion."offerId" AND criterion.id = offer_criterion."criterionId"
E   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" 
E       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" 
E       WHERE booking."userId" = 11 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC
E   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" 
E       FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" 
E       WHERE favorite."userId" = 11 ORDER BY favorite.id DESC
E   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 
E       FROM deposit 
E       WHERE 11 = deposit."userId"
E   28. SELECT get_wallet_balance(11, False) AS get_wallet_balance_1
E   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 
E       FROM action_history 
E       WHERE 11 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST
E   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" 
E       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" 
E       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
E   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 
E       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" 
E       WHERE venue."bookingEmail" = [email protected]
E   32. SELECT EXISTS (SELECT 1 
E       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" 
E       WHERE collective_offer."venueId" IN (8) AND collective_offer.validation = APPROVED AND educational_institution_program.name = marseille_en_grand) AS anon_1
E   33. SELECT EXISTS (SELECT 1 
E       FROM offer 
E       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 * 
E       FROM stock 
E       WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false)) AND NOT (EXISTS (SELECT * 
E       FROM stock 
E       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 * 
E       FROM stock 
E       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
E   34. SELECT EXISTS (SELECT 1 
E       FROM booking 
E       WHERE booking."venueId" IN (8) AND booking.status != CANCELLED) AS anon_1
E   35. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E       FROM feature