Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.qrcode AS qrcode_5,
  t0.qr_token AS qr_token_6,
  t0.user_type AS user_type_7,
  t0.is_admin AS is_admin_8,
  t0.email AS email_9,
  t0.password AS password_10,
  t0.image AS image_11,
  t0.signature_path AS signature_path_12,
  t0.signature_uploaded_at AS signature_uploaded_at_13,
  t0.signature_auto_enabled AS signature_auto_enabled_14,
  t0.statut AS statut_15,
  t0.fonction AS fonction_16,
  t0.adresse AS adresse_17,
  t0.code_postal AS code_postal_18,
  t0.ville AS ville_19,
  t0.pays AS pays_20,
  t0.telephone AS telephone_21,
  t0.token AS token_22,
  t0.deleted AS deleted_23,
  t0.archive AS archive_24,
  t0.telephone_fixe AS telephone_fixe_25,
  t0.entreprise AS entreprise_26,
  t0.linkedin AS linkedin_27,
  t0.siteweb AS siteweb_28,
  t0.idtoken AS idtoken_29,
  t0.role_id AS role_id_30,
  t0.mecene_id AS mecene_id_31,
  t0.soc_id AS soc_id_32
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.qrcode AS qrcode_5, t0.qr_token AS qr_token_6, t0.user_type AS user_type_7, t0.is_admin AS is_admin_8, t0.email AS email_9, t0.password AS password_10, t0.image AS image_11, t0.signature_path AS signature_path_12, t0.signature_uploaded_at AS signature_uploaded_at_13, t0.signature_auto_enabled AS signature_auto_enabled_14, t0.statut AS statut_15, t0.fonction AS fonction_16, t0.adresse AS adresse_17, t0.code_postal AS code_postal_18, t0.ville AS ville_19, t0.pays AS pays_20, t0.telephone AS telephone_21, t0.token AS token_22, t0.deleted AS deleted_23, t0.archive AS archive_24, t0.telephone_fixe AS telephone_fixe_25, t0.entreprise AS entreprise_26, t0.linkedin AS linkedin_27, t0.siteweb AS siteweb_28, t0.idtoken AS idtoken_29, t0.role_id AS role_id_30, t0.mecene_id AS mecene_id_31, t0.soc_id AS soc_id_32 FROM user t0 WHERE t0.id = 222;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.metadata AS metadata_4,
  t0.user_id AS user_id_5
FROM
  parametre_user t0
WHERE
  t0.user_id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.metadata AS metadata_4, t0.user_id AS user_id_5 FROM parametre_user t0 WHERE t0.user_id = 222 AND t0.type = 'accept_cgu' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.context_token AS context_token_1,
  a0_.kind AS kind_2,
  a0_.all_projects AS all_projects_3,
  a0_.permissions AS permissions_4,
  a0_.business_role AS business_role_5,
  a0_.status AS status_6,
  a0_.professional_email AS professional_email_7,
  a0_.active_scope_key AS active_scope_key_8,
  a0_.created_at AS created_at_9,
  a0_.accepted_at AS accepted_at_10,
  a0_.expires_at AS expires_at_11,
  a0_.revoked_at AS revoked_at_12,
  a0_.user_id AS user_id_13,
  a0_.organization_id AS organization_id_14,
  a0_.partner_id AS partner_id_15,
  a0_.project_id AS project_id_16,
  a0_.contact_profile_id AS contact_profile_id_17,
  a0_.created_by_id AS created_by_id_18
FROM
  access_membership a0_
WHERE
  a0_.user_id = ?
  AND a0_.context_token = ?
  AND a0_.status = ?
  AND (
    (
      a0_.expires_at IS NULL
      OR a0_.expires_at > ?
    )
  )

SELECT a0_.id AS id_0, a0_.context_token AS context_token_1, a0_.kind AS kind_2, a0_.all_projects AS all_projects_3, a0_.permissions AS permissions_4, a0_.business_role AS business_role_5, a0_.status AS status_6, a0_.professional_email AS professional_email_7, a0_.active_scope_key AS active_scope_key_8, a0_.created_at AS created_at_9, a0_.accepted_at AS accepted_at_10, a0_.expires_at AS expires_at_11, a0_.revoked_at AS revoked_at_12, a0_.user_id AS user_id_13, a0_.organization_id AS organization_id_14, a0_.partner_id AS partner_id_15, a0_.project_id AS project_id_16, a0_.contact_profile_id AS contact_profile_id_17, a0_.created_by_id AS created_by_id_18 FROM access_membership a0_ WHERE a0_.user_id = 222 AND a0_.context_token = 'dabbdce6ed13458f4c72c6d3e93632629d3fcc197d052efefa61ae1042292582' AND a0_.status = 'active' AND ((a0_.expires_at IS NULL OR a0_.expires_at > '2026-10-06 11:39:06'));

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.groupe AS groupe_4
FROM
  permission t0
  INNER JOIN user_permission ON t0.id = user_permission.permission_id
WHERE
  user_permission.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = 222;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.permissions AS permissions_3,
  t0.deleted AS deleted_4,
  t0.idtoken AS idtoken_5,
  t0.societe_id AS societe_id_6
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.permissions AS permissions_3, t0.deleted AS deleted_4, t0.idtoken AS idtoken_5, t0.societe_id AS societe_id_6 FROM role t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.groupe AS groupe_4
FROM
  permission t0
  INNER JOIN role_permission ON t0.id = role_permission.permission_id
WHERE
  role_permission.role_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = 1;

SELECT
  a0_.id AS id_0,
  a0_.context_token AS context_token_1,
  a0_.kind AS kind_2,
  a0_.all_projects AS all_projects_3,
  a0_.permissions AS permissions_4,
  a0_.business_role AS business_role_5,
  a0_.status AS status_6,
  a0_.professional_email AS professional_email_7,
  a0_.active_scope_key AS active_scope_key_8,
  a0_.created_at AS created_at_9,
  a0_.accepted_at AS accepted_at_10,
  a0_.expires_at AS expires_at_11,
  a0_.revoked_at AS revoked_at_12,
  a0_.user_id AS user_id_13,
  a0_.organization_id AS organization_id_14,
  a0_.partner_id AS partner_id_15,
  a0_.project_id AS project_id_16,
  a0_.contact_profile_id AS contact_profile_id_17,
  a0_.created_by_id AS created_by_id_18
FROM
  access_membership a0_
WHERE
  a0_.user_id = ?
  AND a0_.context_token = ?
  AND a0_.status = ?
  AND (
    (
      a0_.expires_at IS NULL
      OR a0_.expires_at > ?
    )
  )

SELECT a0_.id AS id_0, a0_.context_token AS context_token_1, a0_.kind AS kind_2, a0_.all_projects AS all_projects_3, a0_.permissions AS permissions_4, a0_.business_role AS business_role_5, a0_.status AS status_6, a0_.professional_email AS professional_email_7, a0_.active_scope_key AS active_scope_key_8, a0_.created_at AS created_at_9, a0_.accepted_at AS accepted_at_10, a0_.expires_at AS expires_at_11, a0_.revoked_at AS revoked_at_12, a0_.user_id AS user_id_13, a0_.organization_id AS organization_id_14, a0_.partner_id AS partner_id_15, a0_.project_id AS project_id_16, a0_.contact_profile_id AS contact_profile_id_17, a0_.created_by_id AS created_by_id_18 FROM access_membership a0_ WHERE a0_.user_id = 222 AND a0_.context_token = 'dabbdce6ed13458f4c72c6d3e93632629d3fcc197d052efefa61ae1042292582' AND a0_.status = 'active' AND ((a0_.expires_at IS NULL OR a0_.expires_at > '2026-10-06 11:39:06'));

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.code AS code_2,
  p0_.title AS title_3,
  p0_.summary AS summary_4,
  p0_.content AS content_5,
  p0_.slides AS slides_6,
  p0_.form_definition AS form_definition_7,
  p0_.status AS status_8,
  p0_.priority AS priority_9,
  p0_.starts_at AS starts_at_10,
  p0_.ends_at AS ends_at_11,
  p0_.published_at AS published_at_12,
  p0_.created_at AS created_at_13,
  p0_.updated_at AS updated_at_14,
  p1_.id AS id_15,
  p1_.audience AS audience_16,
  p1_.mode AS mode_17,
  p1_.form_handler_key AS form_handler_key_18,
  p1_.submit_label AS submit_label_19,
  p1_.required_capability AS required_capability_20,
  p1_.targeting_configuration AS targeting_configuration_21,
  p1_.content_override AS content_override_22,
  p1_.created_at AS created_at_23,
  p1_.updated_at AS updated_at_24,
  p0_.created_by_id AS created_by_id_25,
  p1_.platform_update_id AS platform_update_id_26
FROM
  platform_update p0_
  INNER JOIN platform_update_audience_configuration p1_ ON p0_.id = p1_.platform_update_id
  AND (p1_.audience = ?)
  LEFT JOIN organizer_update_completion o2_ ON (
    o2_.platform_update_id = p0_.id
    AND o2_.company_id = ?
    AND o2_.status = ?
  )
WHERE
  p0_.status = ?
  AND (
    p0_.starts_at IS NULL
    OR p0_.starts_at <= ?
  )
  AND (
    p0_.ends_at IS NULL
    OR p0_.ends_at > ?
  )
  AND o2_.id IS NULL
ORDER BY
  p0_.priority DESC,
  p0_.published_at ASC,
  p0_.id ASC,
  p1_.audience ASC

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.code AS code_2, p0_.title AS title_3, p0_.summary AS summary_4, p0_.content AS content_5, p0_.slides AS slides_6, p0_.form_definition AS form_definition_7, p0_.status AS status_8, p0_.priority AS priority_9, p0_.starts_at AS starts_at_10, p0_.ends_at AS ends_at_11, p0_.published_at AS published_at_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p1_.id AS id_15, p1_.audience AS audience_16, p1_.mode AS mode_17, p1_.form_handler_key AS form_handler_key_18, p1_.submit_label AS submit_label_19, p1_.required_capability AS required_capability_20, p1_.targeting_configuration AS targeting_configuration_21, p1_.content_override AS content_override_22, p1_.created_at AS created_at_23, p1_.updated_at AS updated_at_24, p0_.created_by_id AS created_by_id_25, p1_.platform_update_id AS platform_update_id_26 FROM platform_update p0_ INNER JOIN platform_update_audience_configuration p1_ ON p0_.id = p1_.platform_update_id AND (p1_.audience = 'organizer') LEFT JOIN organizer_update_completion o2_ ON (o2_.platform_update_id = p0_.id AND o2_.company_id = 2 AND o2_.status = 'completed') WHERE p0_.status = 'published' AND (p0_.starts_at IS NULL OR p0_.starts_at <= '2026-10-06 11:39:06') AND (p0_.ends_at IS NULL OR p0_.ends_at > '2026-10-06 11:39:06') AND o2_.id IS NULL ORDER BY p0_.priority DESC, p0_.published_at ASC, p0_.id ASC, p1_.audience ASC;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.titre AS titre_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.deadline AS deadline_6,
  t0.statut AS statut_7,
  t0.created_at AS created_at_8,
  t0.objectif_financier AS objectif_financier_9,
  t0.montant_prevu AS montant_prevu_10,
  t0.montant_recu AS montant_recu_11,
  t0.archive AS archive_12,
  t0.logo AS logo_13,
  t0.affiche AS affiche_14,
  t0.presentation_file_path AS presentation_file_path_15,
  t0.presentation_file_original_name AS presentation_file_original_name_16,
  t0.presentation_file_size AS presentation_file_size_17,
  t0.presentation_file_mime_type AS presentation_file_mime_type_18,
  t0.presentation_file_uploaded_at AS presentation_file_uploaded_at_19,
  t0.visuel_principal AS visuel_principal_20,
  t0.public AS public_21,
  t0.deleted AS deleted_22,
  t0.idtoken AS idtoken_23,
  t0.gains AS gains_24,
  t0.depenses AS depenses_25,
  t0.import_convention AS import_convention_26,
  t0.import_formule AS import_formule_27,
  t0.import_modele AS import_modele_28,
  t0.import_contrepartie AS import_contrepartie_29,
  t0.import AS import_30,
  t0.edition_label AS edition_label_31,
  t0.edition_number AS edition_number_32,
  t0.reopened_at AS reopened_at_33,
  t0.reopen_reason AS reopen_reason_34,
  t0.created_by_id AS created_by_id_35,
  t0.presentation_file_uploaded_by_id AS presentation_file_uploaded_by_id_36,
  t0.societe_id AS societe_id_37,
  t0.signataire_id AS signataire_id_38,
  t0.responsable_id AS responsable_id_39,
  t0.parent_id AS parent_id_40,
  t0.presentation_id AS presentation_id_41,
  t0.espace_id AS espace_id_42,
  t43.id AS id_44,
  t43.is_enabled AS is_enabled_45,
  t43.welcome_message AS welcome_message_46,
  t43.created_at AS created_at_47,
  t43.updated_at AS updated_at_48,
  t43.project_id AS project_id_49,
  t0.edition_series_id AS edition_series_id_50,
  t0.previous_edition_id AS previous_edition_id_51,
  t0.next_edition_id AS next_edition_id_52
FROM
  projet t0
  LEFT JOIN project_onboarding t43 ON t43.project_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.presentation_file_path AS presentation_file_path_15, t0.presentation_file_original_name AS presentation_file_original_name_16, t0.presentation_file_size AS presentation_file_size_17, t0.presentation_file_mime_type AS presentation_file_mime_type_18, t0.presentation_file_uploaded_at AS presentation_file_uploaded_at_19, t0.visuel_principal AS visuel_principal_20, t0.public AS public_21, t0.deleted AS deleted_22, t0.idtoken AS idtoken_23, t0.gains AS gains_24, t0.depenses AS depenses_25, t0.import_convention AS import_convention_26, t0.import_formule AS import_formule_27, t0.import_modele AS import_modele_28, t0.import_contrepartie AS import_contrepartie_29, t0.import AS import_30, t0.edition_label AS edition_label_31, t0.edition_number AS edition_number_32, t0.reopened_at AS reopened_at_33, t0.reopen_reason AS reopen_reason_34, t0.created_by_id AS created_by_id_35, t0.presentation_file_uploaded_by_id AS presentation_file_uploaded_by_id_36, t0.societe_id AS societe_id_37, t0.signataire_id AS signataire_id_38, t0.responsable_id AS responsable_id_39, t0.parent_id AS parent_id_40, t0.presentation_id AS presentation_id_41, t0.espace_id AS espace_id_42, t43.id AS id_44, t43.is_enabled AS is_enabled_45, t43.welcome_message AS welcome_message_46, t43.created_at AS created_at_47, t43.updated_at AS updated_at_48, t43.project_id AS project_id_49, t0.edition_series_id AS edition_series_id_50, t0.previous_edition_id AS previous_edition_id_51, t0.next_edition_id AS next_edition_id_52 FROM projet t0 LEFT JOIN project_onboarding t43 ON t43.project_id = t0.id WHERE t0.id = '4';

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.photo AS photo_3,
  t0.original_filename AS original_filename_4,
  t0.stored_filename AS stored_filename_5,
  t0.original_path AS original_path_6,
  t0.thumb_path AS thumb_path_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.position AS position_12,
  t0.favorite AS favorite_13,
  t0.created_at AS created_at_14,
  t0.deleted AS deleted_15,
  t0.societe_id AS societe_id_16,
  t0.galerie_id AS galerie_id_17,
  t0.created_by_id AS created_by_id_18
FROM
  photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.photo AS photo_3, t0.original_filename AS original_filename_4, t0.stored_filename AS stored_filename_5, t0.original_path AS original_path_6, t0.thumb_path AS thumb_path_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.position AS position_12, t0.favorite AS favorite_13, t0.created_at AS created_at_14, t0.deleted AS deleted_15, t0.societe_id AS societe_id_16, t0.galerie_id AS galerie_id_17, t0.created_by_id AS created_by_id_18 FROM photo t0 WHERE t0.id = '19';

SELECT
  a0_.id AS id_0,
  a0_.context_token AS context_token_1,
  a0_.kind AS kind_2,
  a0_.all_projects AS all_projects_3,
  a0_.permissions AS permissions_4,
  a0_.business_role AS business_role_5,
  a0_.status AS status_6,
  a0_.professional_email AS professional_email_7,
  a0_.active_scope_key AS active_scope_key_8,
  a0_.created_at AS created_at_9,
  a0_.accepted_at AS accepted_at_10,
  a0_.expires_at AS expires_at_11,
  a0_.revoked_at AS revoked_at_12,
  a0_.user_id AS user_id_13,
  a0_.organization_id AS organization_id_14,
  a0_.partner_id AS partner_id_15,
  a0_.project_id AS project_id_16,
  a0_.contact_profile_id AS contact_profile_id_17,
  a0_.created_by_id AS created_by_id_18
FROM
  access_membership a0_
WHERE
  a0_.user_id = ?
  AND a0_.context_token = ?
  AND a0_.status = ?
  AND (
    (
      a0_.expires_at IS NULL
      OR a0_.expires_at > ?
    )
  )

SELECT a0_.id AS id_0, a0_.context_token AS context_token_1, a0_.kind AS kind_2, a0_.all_projects AS all_projects_3, a0_.permissions AS permissions_4, a0_.business_role AS business_role_5, a0_.status AS status_6, a0_.professional_email AS professional_email_7, a0_.active_scope_key AS active_scope_key_8, a0_.created_at AS created_at_9, a0_.accepted_at AS accepted_at_10, a0_.expires_at AS expires_at_11, a0_.revoked_at AS revoked_at_12, a0_.user_id AS user_id_13, a0_.organization_id AS organization_id_14, a0_.partner_id AS partner_id_15, a0_.project_id AS project_id_16, a0_.contact_profile_id AS contact_profile_id_17, a0_.created_by_id AS created_by_id_18 FROM access_membership a0_ WHERE a0_.user_id = 222 AND a0_.context_token = 'dabbdce6ed13458f4c72c6d3e93632629d3fcc197d052efefa61ae1042292582' AND a0_.status = 'active' AND ((a0_.expires_at IS NULL OR a0_.expires_at > '2026-10-06 11:39:06'));

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.titre AS titre_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.deadline AS deadline_6,
  t0.statut AS statut_7,
  t0.created_at AS created_at_8,
  t0.objectif_financier AS objectif_financier_9,
  t0.montant_prevu AS montant_prevu_10,
  t0.montant_recu AS montant_recu_11,
  t0.archive AS archive_12,
  t0.logo AS logo_13,
  t0.affiche AS affiche_14,
  t0.presentation_file_path AS presentation_file_path_15,
  t0.presentation_file_original_name AS presentation_file_original_name_16,
  t0.presentation_file_size AS presentation_file_size_17,
  t0.presentation_file_mime_type AS presentation_file_mime_type_18,
  t0.presentation_file_uploaded_at AS presentation_file_uploaded_at_19,
  t0.visuel_principal AS visuel_principal_20,
  t0.public AS public_21,
  t0.deleted AS deleted_22,
  t0.idtoken AS idtoken_23,
  t0.gains AS gains_24,
  t0.depenses AS depenses_25,
  t0.import_convention AS import_convention_26,
  t0.import_formule AS import_formule_27,
  t0.import_modele AS import_modele_28,
  t0.import_contrepartie AS import_contrepartie_29,
  t0.import AS import_30,
  t0.edition_label AS edition_label_31,
  t0.edition_number AS edition_number_32,
  t0.reopened_at AS reopened_at_33,
  t0.reopen_reason AS reopen_reason_34,
  t0.created_by_id AS created_by_id_35,
  t0.presentation_file_uploaded_by_id AS presentation_file_uploaded_by_id_36,
  t0.societe_id AS societe_id_37,
  t0.signataire_id AS signataire_id_38,
  t0.responsable_id AS responsable_id_39,
  t0.parent_id AS parent_id_40,
  t0.presentation_id AS presentation_id_41,
  t0.espace_id AS espace_id_42,
  t43.id AS id_44,
  t43.is_enabled AS is_enabled_45,
  t43.welcome_message AS welcome_message_46,
  t43.created_at AS created_at_47,
  t43.updated_at AS updated_at_48,
  t43.project_id AS project_id_49,
  t0.edition_series_id AS edition_series_id_50,
  t0.previous_edition_id AS previous_edition_id_51,
  t0.next_edition_id AS next_edition_id_52
FROM
  projet t0
  LEFT JOIN project_onboarding t43 ON t43.project_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.presentation_file_path AS presentation_file_path_15, t0.presentation_file_original_name AS presentation_file_original_name_16, t0.presentation_file_size AS presentation_file_size_17, t0.presentation_file_mime_type AS presentation_file_mime_type_18, t0.presentation_file_uploaded_at AS presentation_file_uploaded_at_19, t0.visuel_principal AS visuel_principal_20, t0.public AS public_21, t0.deleted AS deleted_22, t0.idtoken AS idtoken_23, t0.gains AS gains_24, t0.depenses AS depenses_25, t0.import_convention AS import_convention_26, t0.import_formule AS import_formule_27, t0.import_modele AS import_modele_28, t0.import_contrepartie AS import_contrepartie_29, t0.import AS import_30, t0.edition_label AS edition_label_31, t0.edition_number AS edition_number_32, t0.reopened_at AS reopened_at_33, t0.reopen_reason AS reopen_reason_34, t0.created_by_id AS created_by_id_35, t0.presentation_file_uploaded_by_id AS presentation_file_uploaded_by_id_36, t0.societe_id AS societe_id_37, t0.signataire_id AS signataire_id_38, t0.responsable_id AS responsable_id_39, t0.parent_id AS parent_id_40, t0.presentation_id AS presentation_id_41, t0.espace_id AS espace_id_42, t43.id AS id_44, t43.is_enabled AS is_enabled_45, t43.welcome_message AS welcome_message_46, t43.created_at AS created_at_47, t43.updated_at AS updated_at_48, t43.project_id AS project_id_49, t0.edition_series_id AS edition_series_id_50, t0.previous_edition_id AS previous_edition_id_51, t0.next_edition_id AS next_edition_id_52 FROM projet t0 LEFT JOIN project_onboarding t43 ON t43.project_id = t0.id WHERE t0.parent_id = 4;