| 1 |
0.92 ms |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.token AS token_8, t0.token_mdp AS token_mdp_9, t0.desactivation_compte AS desactivation_compte_10, t0.created_at AS created_at_11, t0.refus_campagne AS refus_campagne_12, t0.compte_finalise AS compte_finalise_13, t0.coordonnees_id AS coordonnees_id_14, t0.info_allocataire_id AS info_allocataire_id_15, t16.id AS id_17, t16.date_naissance AS date_naissance_18, t16.pays_naissance AS pays_naissance_19, t16.code_postal_naissance AS code_postal_naissance_20, t16.commune_naissance AS commune_naissance_21, t16.numero_securite_social AS numero_securite_social_22, t16.intitule_poste AS intitule_poste_23, t16.nom_photo AS nom_photo_24, t16.updated_at_photo AS updated_at_photo_25, t16.notes AS notes_26, t16.code_insee AS code_insee_27, t16.user_id AS user_id_28, t16.statut_employe_id AS statut_employe_id_29 FROM user t0 LEFT JOIN animateur t16 ON t16.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.token AS token_8, t0.token_mdp AS token_mdp_9, t0.desactivation_compte AS desactivation_compte_10, t0.created_at AS created_at_11, t0.refus_campagne AS refus_campagne_12, t0.compte_finalise AS compte_finalise_13, t0.coordonnees_id AS coordonnees_id_14, t0.info_allocataire_id AS info_allocataire_id_15, t16.id AS id_17, t16.date_naissance AS date_naissance_18, t16.pays_naissance AS pays_naissance_19, t16.code_postal_naissance AS code_postal_naissance_20, t16.commune_naissance AS commune_naissance_21, t16.numero_securite_social AS numero_securite_social_22, t16.intitule_poste AS intitule_poste_23, t16.nom_photo AS nom_photo_24, t16.updated_at_photo AS updated_at_photo_25, t16.notes AS notes_26, t16.code_insee AS code_insee_27, t16.user_id AS user_id_28, t16.statut_employe_id AS statut_employe_id_29 FROM user t0 LEFT JOIN animateur t16 ON t16.user_id = t0.id WHERE t0.id = 11;
|
| 2 |
3.82 ms |
SELECT d0_.id AS id_0, d0_.statut AS statut_1, d0_.heure_arrivee AS heure_arrivee_2, d0_.heure_depart AS heure_depart_3, d0_.plus_de_six_ans AS plus_de_six_ans_4, r1_.id AS id_5, r1_.statut AS statut_6, r1_.prix_creneau AS prix_creneau_7, r1_.liste_attente AS liste_attente_8, r1_.num_liste_attente AS num_liste_attente_9, r2_.id AS id_10, r2_.created_at AS created_at_11, r2_.updated_at AS updated_at_12, r2_.statut_reservation AS statut_reservation_13, r2_.montant_total AS montant_total_14, r2_.montant_acompte AS montant_acompte_15, r2_.valide AS valide_16, r2_.statut AS statut_17, r2_.archive AS archive_18, r2_.num_liste_attente AS num_liste_attente_19, r2_.plus_de_six_ans AS plus_de_six_ans_20, r2_.numero_attestation_presence AS numero_attestation_presence_21, e3_.id AS id_22, e3_.nom AS nom_23, e3_.prenom AS prenom_24, e3_.sexe AS sexe_25, e3_.date_naissance AS date_naissance_26, e3_.autres_allergies AS autres_allergies_27, e3_.remarques_medicales AS remarques_medicales_28, e3_.suivi_traitement AS suivi_traitement_29, e3_.traitement AS traitement_30, e3_.nom_ordonnance AS nom_ordonnance_31, e3_.updated_at AS updated_at_32, e3_.nom_photo AS nom_photo_33, e3_.updated_at_photo AS updated_at_photo_34, e3_.autorisation_photo AS autorisation_photo_35, e3_.aeeh AS aeeh_36, e3_.est_utilisateur AS est_utilisateur_37, s4_.id AS id_38, s4_.nom_sejour AS nom_sejour_39, s4_.age_min AS age_min_40, s4_.age_max AS age_max_41, s4_.date_debut AS date_debut_42, s4_.date_fin AS date_fin_43, s4_.description AS description_44, s4_.nbplace AS nbplace_45, s4_.montant_acompte AS montant_acompte_46, s4_.hebergement AS hebergement_47, s4_.justificatif_suplementaire AS justificatif_suplementaire_48, s4_.nom_image_principale AS nom_image_principale_49, s4_.updated_at AS updated_at_50, s4_.type_activite AS type_activite_51, s4_.nb_places_prises AS nb_places_prises_52, s4_.date_delai_reservation AS date_delai_reservation_53, s4_.date_delai_annulation AS date_delai_annulation_54, s4_.statut AS statut_55, s4_.total_liste_attente AS total_liste_attente_56, s4_.recurrence AS recurrence_57, s4_.type_recurrence AS type_recurrence_58, s4_.numero_declaration_sdjes AS numero_declaration_sdjes_59, s4_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_60, d5_.id AS id_61, d6_.id AS id_62, d6_.date AS date_63, d7_.id AS id_64, d7_.label AS label_65, s8_.id AS id_66, s8_.label AS label_67, d0_.reservation_creneau_activite_id AS reservation_creneau_activite_id_68, d0_.decoupage_creneau_id AS decoupage_creneau_id_69, d0_.statut_presence_id AS statut_presence_id_70, r1_.reservation_id AS reservation_id_71, r1_.creneau_activite_id AS creneau_activite_id_72, r1_.tarif_id AS tarif_id_73, r1_.annulation_id AS annulation_id_74, r2_.utilisateur_id AS utilisateur_id_75, r2_.enfant_id AS enfant_id_76, r2_.activite_id AS activite_id_77, r2_.commande_id AS commande_id_78, r2_.annulation_id AS annulation_id_79, r2_.presence_sejour_id AS presence_sejour_id_80, r2_.tarif_id AS tarif_id_81, s4_.categorie_id AS categorie_id_82, s4_.coordonnees_id AS coordonnees_id_83, s4_.semaine_recurrence_id AS semaine_recurrence_id_84, d5_.demi_journee_id AS demi_journee_id_85, d5_.creneau_activite_id AS creneau_activite_id_86, d6_.demi_journee_id AS demi_journee_id_87 FROM decoupage_presence d0_ LEFT JOIN reservation_creneau_activite r1_ ON d0_.reservation_creneau_activite_id = r1_.id LEFT JOIN reservation r2_ ON r1_.reservation_id = r2_.id LEFT JOIN enfant e3_ ON r2_.enfant_id = e3_.id LEFT JOIN sejour s4_ ON r2_.activite_id = s4_.id LEFT JOIN decoupage_creneau d5_ ON d0_.decoupage_creneau_id = d5_.id LEFT JOIN demi_journee_decoupage d6_ ON d5_.demi_journee_id = d6_.id LEFT JOIN demi_journee d7_ ON d6_.demi_journee_id = d7_.id LEFT JOIN statut_presence s8_ ON d0_.statut_presence_id = s8_.id WHERE s4_.statut = ? AND r2_.statut_reservation IN (?, ?, ?, ?) AND (r2_.statut <> (?) OR r2_.statut IS NULL) AND r2_.valide = 1 AND d0_.statut IS NULL
Parameters: [
"publie"
"payee"
"acompte_paye"
"paiement_en_attente"
"acompte_en_attente"
"annule"
]
SELECT
d0_.id AS id_0,
d0_.statut AS statut_1,
d0_.heure_arrivee AS heure_arrivee_2,
d0_.heure_depart AS heure_depart_3,
d0_.plus_de_six_ans AS plus_de_six_ans_4,
r1_.id AS id_5,
r1_.statut AS statut_6,
r1_.prix_creneau AS prix_creneau_7,
r1_.liste_attente AS liste_attente_8,
r1_.num_liste_attente AS num_liste_attente_9,
r2_.id AS id_10,
r2_.created_at AS created_at_11,
r2_.updated_at AS updated_at_12,
r2_.statut_reservation AS statut_reservation_13,
r2_.montant_total AS montant_total_14,
r2_.montant_acompte AS montant_acompte_15,
r2_.valide AS valide_16,
r2_.statut AS statut_17,
r2_.archive AS archive_18,
r2_.num_liste_attente AS num_liste_attente_19,
r2_.plus_de_six_ans AS plus_de_six_ans_20,
r2_.numero_attestation_presence AS numero_attestation_presence_21,
e3_.id AS id_22,
e3_.nom AS nom_23,
e3_.prenom AS prenom_24,
e3_.sexe AS sexe_25,
e3_.date_naissance AS date_naissance_26,
e3_.autres_allergies AS autres_allergies_27,
e3_.remarques_medicales AS remarques_medicales_28,
e3_.suivi_traitement AS suivi_traitement_29,
e3_.traitement AS traitement_30,
e3_.nom_ordonnance AS nom_ordonnance_31,
e3_.updated_at AS updated_at_32,
e3_.nom_photo AS nom_photo_33,
e3_.updated_at_photo AS updated_at_photo_34,
e3_.autorisation_photo AS autorisation_photo_35,
e3_.aeeh AS aeeh_36,
e3_.est_utilisateur AS est_utilisateur_37,
s4_.id AS id_38,
s4_.nom_sejour AS nom_sejour_39,
s4_.age_min AS age_min_40,
s4_.age_max AS age_max_41,
s4_.date_debut AS date_debut_42,
s4_.date_fin AS date_fin_43,
s4_.description AS description_44,
s4_.nbplace AS nbplace_45,
s4_.montant_acompte AS montant_acompte_46,
s4_.hebergement AS hebergement_47,
s4_.justificatif_suplementaire AS justificatif_suplementaire_48,
s4_.nom_image_principale AS nom_image_principale_49,
s4_.updated_at AS updated_at_50,
s4_.type_activite AS type_activite_51,
s4_.nb_places_prises AS nb_places_prises_52,
s4_.date_delai_reservation AS date_delai_reservation_53,
s4_.date_delai_annulation AS date_delai_annulation_54,
s4_.statut AS statut_55,
s4_.total_liste_attente AS total_liste_attente_56,
s4_.recurrence AS recurrence_57,
s4_.type_recurrence AS type_recurrence_58,
s4_.numero_declaration_sdjes AS numero_declaration_sdjes_59,
s4_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_60,
d5_.id AS id_61,
d6_.id AS id_62,
d6_.date AS date_63,
d7_.id AS id_64,
d7_.label AS label_65,
s8_.id AS id_66,
s8_.label AS label_67,
d0_.reservation_creneau_activite_id AS reservation_creneau_activite_id_68,
d0_.decoupage_creneau_id AS decoupage_creneau_id_69,
d0_.statut_presence_id AS statut_presence_id_70,
r1_.reservation_id AS reservation_id_71,
r1_.creneau_activite_id AS creneau_activite_id_72,
r1_.tarif_id AS tarif_id_73,
r1_.annulation_id AS annulation_id_74,
r2_.utilisateur_id AS utilisateur_id_75,
r2_.enfant_id AS enfant_id_76,
r2_.activite_id AS activite_id_77,
r2_.commande_id AS commande_id_78,
r2_.annulation_id AS annulation_id_79,
r2_.presence_sejour_id AS presence_sejour_id_80,
r2_.tarif_id AS tarif_id_81,
s4_.categorie_id AS categorie_id_82,
s4_.coordonnees_id AS coordonnees_id_83,
s4_.semaine_recurrence_id AS semaine_recurrence_id_84,
d5_.demi_journee_id AS demi_journee_id_85,
d5_.creneau_activite_id AS creneau_activite_id_86,
d6_.demi_journee_id AS demi_journee_id_87
FROM
decoupage_presence d0_
LEFT JOIN reservation_creneau_activite r1_ ON d0_.reservation_creneau_activite_id = r1_.id
LEFT JOIN reservation r2_ ON r1_.reservation_id = r2_.id
LEFT JOIN enfant e3_ ON r2_.enfant_id = e3_.id
LEFT JOIN sejour s4_ ON r2_.activite_id = s4_.id
LEFT JOIN decoupage_creneau d5_ ON d0_.decoupage_creneau_id = d5_.id
LEFT JOIN demi_journee_decoupage d6_ ON d5_.demi_journee_id = d6_.id
LEFT JOIN demi_journee d7_ ON d6_.demi_journee_id = d7_.id
LEFT JOIN statut_presence s8_ ON d0_.statut_presence_id = s8_.id
WHERE
s4_.statut = ?
AND r2_.statut_reservation IN (?, ?, ?, ?)
AND (
r2_.statut <> (?)
OR r2_.statut IS NULL
)
AND r2_.valide = 1
AND d0_.statut IS NULL
SELECT d0_.id AS id_0, d0_.statut AS statut_1, d0_.heure_arrivee AS heure_arrivee_2, d0_.heure_depart AS heure_depart_3, d0_.plus_de_six_ans AS plus_de_six_ans_4, r1_.id AS id_5, r1_.statut AS statut_6, r1_.prix_creneau AS prix_creneau_7, r1_.liste_attente AS liste_attente_8, r1_.num_liste_attente AS num_liste_attente_9, r2_.id AS id_10, r2_.created_at AS created_at_11, r2_.updated_at AS updated_at_12, r2_.statut_reservation AS statut_reservation_13, r2_.montant_total AS montant_total_14, r2_.montant_acompte AS montant_acompte_15, r2_.valide AS valide_16, r2_.statut AS statut_17, r2_.archive AS archive_18, r2_.num_liste_attente AS num_liste_attente_19, r2_.plus_de_six_ans AS plus_de_six_ans_20, r2_.numero_attestation_presence AS numero_attestation_presence_21, e3_.id AS id_22, e3_.nom AS nom_23, e3_.prenom AS prenom_24, e3_.sexe AS sexe_25, e3_.date_naissance AS date_naissance_26, e3_.autres_allergies AS autres_allergies_27, e3_.remarques_medicales AS remarques_medicales_28, e3_.suivi_traitement AS suivi_traitement_29, e3_.traitement AS traitement_30, e3_.nom_ordonnance AS nom_ordonnance_31, e3_.updated_at AS updated_at_32, e3_.nom_photo AS nom_photo_33, e3_.updated_at_photo AS updated_at_photo_34, e3_.autorisation_photo AS autorisation_photo_35, e3_.aeeh AS aeeh_36, e3_.est_utilisateur AS est_utilisateur_37, s4_.id AS id_38, s4_.nom_sejour AS nom_sejour_39, s4_.age_min AS age_min_40, s4_.age_max AS age_max_41, s4_.date_debut AS date_debut_42, s4_.date_fin AS date_fin_43, s4_.description AS description_44, s4_.nbplace AS nbplace_45, s4_.montant_acompte AS montant_acompte_46, s4_.hebergement AS hebergement_47, s4_.justificatif_suplementaire AS justificatif_suplementaire_48, s4_.nom_image_principale AS nom_image_principale_49, s4_.updated_at AS updated_at_50, s4_.type_activite AS type_activite_51, s4_.nb_places_prises AS nb_places_prises_52, s4_.date_delai_reservation AS date_delai_reservation_53, s4_.date_delai_annulation AS date_delai_annulation_54, s4_.statut AS statut_55, s4_.total_liste_attente AS total_liste_attente_56, s4_.recurrence AS recurrence_57, s4_.type_recurrence AS type_recurrence_58, s4_.numero_declaration_sdjes AS numero_declaration_sdjes_59, s4_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_60, d5_.id AS id_61, d6_.id AS id_62, d6_.date AS date_63, d7_.id AS id_64, d7_.label AS label_65, s8_.id AS id_66, s8_.label AS label_67, d0_.reservation_creneau_activite_id AS reservation_creneau_activite_id_68, d0_.decoupage_creneau_id AS decoupage_creneau_id_69, d0_.statut_presence_id AS statut_presence_id_70, r1_.reservation_id AS reservation_id_71, r1_.creneau_activite_id AS creneau_activite_id_72, r1_.tarif_id AS tarif_id_73, r1_.annulation_id AS annulation_id_74, r2_.utilisateur_id AS utilisateur_id_75, r2_.enfant_id AS enfant_id_76, r2_.activite_id AS activite_id_77, r2_.commande_id AS commande_id_78, r2_.annulation_id AS annulation_id_79, r2_.presence_sejour_id AS presence_sejour_id_80, r2_.tarif_id AS tarif_id_81, s4_.categorie_id AS categorie_id_82, s4_.coordonnees_id AS coordonnees_id_83, s4_.semaine_recurrence_id AS semaine_recurrence_id_84, d5_.demi_journee_id AS demi_journee_id_85, d5_.creneau_activite_id AS creneau_activite_id_86, d6_.demi_journee_id AS demi_journee_id_87 FROM decoupage_presence d0_ LEFT JOIN reservation_creneau_activite r1_ ON d0_.reservation_creneau_activite_id = r1_.id LEFT JOIN reservation r2_ ON r1_.reservation_id = r2_.id LEFT JOIN enfant e3_ ON r2_.enfant_id = e3_.id LEFT JOIN sejour s4_ ON r2_.activite_id = s4_.id LEFT JOIN decoupage_creneau d5_ ON d0_.decoupage_creneau_id = d5_.id LEFT JOIN demi_journee_decoupage d6_ ON d5_.demi_journee_id = d6_.id LEFT JOIN demi_journee d7_ ON d6_.demi_journee_id = d7_.id LEFT JOIN statut_presence s8_ ON d0_.statut_presence_id = s8_.id WHERE s4_.statut = 'publie' AND r2_.statut_reservation IN ('payee', 'acompte_paye', 'paiement_en_attente', 'acompte_en_attente') AND (r2_.statut <> ('annule') OR r2_.statut IS NULL) AND r2_.valide = 1 AND d0_.statut IS NULL;
|
| 3 |
1.66 ms |
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.statut_reservation AS statut_reservation_3, r0_.montant_total AS montant_total_4, r0_.montant_acompte AS montant_acompte_5, r0_.valide AS valide_6, r0_.statut AS statut_7, r0_.archive AS archive_8, r0_.num_liste_attente AS num_liste_attente_9, r0_.plus_de_six_ans AS plus_de_six_ans_10, r0_.numero_attestation_presence AS numero_attestation_presence_11, s1_.id AS id_12, s1_.nom_sejour AS nom_sejour_13, s1_.age_min AS age_min_14, s1_.age_max AS age_max_15, s1_.date_debut AS date_debut_16, s1_.date_fin AS date_fin_17, s1_.description AS description_18, s1_.nbplace AS nbplace_19, s1_.montant_acompte AS montant_acompte_20, s1_.hebergement AS hebergement_21, s1_.justificatif_suplementaire AS justificatif_suplementaire_22, s1_.nom_image_principale AS nom_image_principale_23, s1_.updated_at AS updated_at_24, s1_.type_activite AS type_activite_25, s1_.nb_places_prises AS nb_places_prises_26, s1_.date_delai_reservation AS date_delai_reservation_27, s1_.date_delai_annulation AS date_delai_annulation_28, s1_.statut AS statut_29, s1_.total_liste_attente AS total_liste_attente_30, s1_.recurrence AS recurrence_31, s1_.type_recurrence AS type_recurrence_32, s1_.numero_declaration_sdjes AS numero_declaration_sdjes_33, s1_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_34, e2_.id AS id_35, e2_.nom AS nom_36, e2_.prenom AS prenom_37, e2_.sexe AS sexe_38, e2_.date_naissance AS date_naissance_39, e2_.autres_allergies AS autres_allergies_40, e2_.remarques_medicales AS remarques_medicales_41, e2_.suivi_traitement AS suivi_traitement_42, e2_.traitement AS traitement_43, e2_.nom_ordonnance AS nom_ordonnance_44, e2_.updated_at AS updated_at_45, e2_.nom_photo AS nom_photo_46, e2_.updated_at_photo AS updated_at_photo_47, e2_.autorisation_photo AS autorisation_photo_48, e2_.aeeh AS aeeh_49, e2_.est_utilisateur AS est_utilisateur_50, p3_.id AS id_51, p3_.heure_arrivee AS heure_arrivee_52, p3_.heure_depart AS heure_depart_53, s4_.id AS id_54, s4_.label AS label_55, r0_.utilisateur_id AS utilisateur_id_56, r0_.enfant_id AS enfant_id_57, r0_.activite_id AS activite_id_58, r0_.commande_id AS commande_id_59, r0_.annulation_id AS annulation_id_60, r0_.presence_sejour_id AS presence_sejour_id_61, r0_.tarif_id AS tarif_id_62, s1_.categorie_id AS categorie_id_63, s1_.coordonnees_id AS coordonnees_id_64, s1_.semaine_recurrence_id AS semaine_recurrence_id_65, p3_.statut_id AS statut_id_66 FROM reservation r0_ INNER JOIN sejour s1_ ON r0_.activite_id = s1_.id LEFT JOIN enfant e2_ ON r0_.enfant_id = e2_.id LEFT JOIN presence_sejour p3_ ON r0_.presence_sejour_id = p3_.id LEFT JOIN statut_presence s4_ ON p3_.statut_id = s4_.id LEFT JOIN reservation_creneau_activite r5_ ON r0_.id = r5_.reservation_id WHERE r0_.statut_reservation IN (?, ?, ?, ?) AND ((r0_.statut <> ? OR r0_.statut IS NULL)) AND s1_.statut = ? AND s1_.type_activite = ? AND r0_.archive = 0 AND r0_.valide = 1 AND s1_.recurrence = ? AND r5_.id IS NULL
Parameters: [
"payee"
"acompte_paye"
"paiement_en_attente"
"acompte_en_attente"
"annule"
"publie"
"sejours"
0
]
SELECT
r0_.id AS id_0,
r0_.created_at AS created_at_1,
r0_.updated_at AS updated_at_2,
r0_.statut_reservation AS statut_reservation_3,
r0_.montant_total AS montant_total_4,
r0_.montant_acompte AS montant_acompte_5,
r0_.valide AS valide_6,
r0_.statut AS statut_7,
r0_.archive AS archive_8,
r0_.num_liste_attente AS num_liste_attente_9,
r0_.plus_de_six_ans AS plus_de_six_ans_10,
r0_.numero_attestation_presence AS numero_attestation_presence_11,
s1_.id AS id_12,
s1_.nom_sejour AS nom_sejour_13,
s1_.age_min AS age_min_14,
s1_.age_max AS age_max_15,
s1_.date_debut AS date_debut_16,
s1_.date_fin AS date_fin_17,
s1_.description AS description_18,
s1_.nbplace AS nbplace_19,
s1_.montant_acompte AS montant_acompte_20,
s1_.hebergement AS hebergement_21,
s1_.justificatif_suplementaire AS justificatif_suplementaire_22,
s1_.nom_image_principale AS nom_image_principale_23,
s1_.updated_at AS updated_at_24,
s1_.type_activite AS type_activite_25,
s1_.nb_places_prises AS nb_places_prises_26,
s1_.date_delai_reservation AS date_delai_reservation_27,
s1_.date_delai_annulation AS date_delai_annulation_28,
s1_.statut AS statut_29,
s1_.total_liste_attente AS total_liste_attente_30,
s1_.recurrence AS recurrence_31,
s1_.type_recurrence AS type_recurrence_32,
s1_.numero_declaration_sdjes AS numero_declaration_sdjes_33,
s1_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_34,
e2_.id AS id_35,
e2_.nom AS nom_36,
e2_.prenom AS prenom_37,
e2_.sexe AS sexe_38,
e2_.date_naissance AS date_naissance_39,
e2_.autres_allergies AS autres_allergies_40,
e2_.remarques_medicales AS remarques_medicales_41,
e2_.suivi_traitement AS suivi_traitement_42,
e2_.traitement AS traitement_43,
e2_.nom_ordonnance AS nom_ordonnance_44,
e2_.updated_at AS updated_at_45,
e2_.nom_photo AS nom_photo_46,
e2_.updated_at_photo AS updated_at_photo_47,
e2_.autorisation_photo AS autorisation_photo_48,
e2_.aeeh AS aeeh_49,
e2_.est_utilisateur AS est_utilisateur_50,
p3_.id AS id_51,
p3_.heure_arrivee AS heure_arrivee_52,
p3_.heure_depart AS heure_depart_53,
s4_.id AS id_54,
s4_.label AS label_55,
r0_.utilisateur_id AS utilisateur_id_56,
r0_.enfant_id AS enfant_id_57,
r0_.activite_id AS activite_id_58,
r0_.commande_id AS commande_id_59,
r0_.annulation_id AS annulation_id_60,
r0_.presence_sejour_id AS presence_sejour_id_61,
r0_.tarif_id AS tarif_id_62,
s1_.categorie_id AS categorie_id_63,
s1_.coordonnees_id AS coordonnees_id_64,
s1_.semaine_recurrence_id AS semaine_recurrence_id_65,
p3_.statut_id AS statut_id_66
FROM
reservation r0_
INNER JOIN sejour s1_ ON r0_.activite_id = s1_.id
LEFT JOIN enfant e2_ ON r0_.enfant_id = e2_.id
LEFT JOIN presence_sejour p3_ ON r0_.presence_sejour_id = p3_.id
LEFT JOIN statut_presence s4_ ON p3_.statut_id = s4_.id
LEFT JOIN reservation_creneau_activite r5_ ON r0_.id = r5_.reservation_id
WHERE
r0_.statut_reservation IN (?, ?, ?, ?)
AND (
(
r0_.statut <> ?
OR r0_.statut IS NULL
)
)
AND s1_.statut = ?
AND s1_.type_activite = ?
AND r0_.archive = 0
AND r0_.valide = 1
AND s1_.recurrence = ?
AND r5_.id IS NULL
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.statut_reservation AS statut_reservation_3, r0_.montant_total AS montant_total_4, r0_.montant_acompte AS montant_acompte_5, r0_.valide AS valide_6, r0_.statut AS statut_7, r0_.archive AS archive_8, r0_.num_liste_attente AS num_liste_attente_9, r0_.plus_de_six_ans AS plus_de_six_ans_10, r0_.numero_attestation_presence AS numero_attestation_presence_11, s1_.id AS id_12, s1_.nom_sejour AS nom_sejour_13, s1_.age_min AS age_min_14, s1_.age_max AS age_max_15, s1_.date_debut AS date_debut_16, s1_.date_fin AS date_fin_17, s1_.description AS description_18, s1_.nbplace AS nbplace_19, s1_.montant_acompte AS montant_acompte_20, s1_.hebergement AS hebergement_21, s1_.justificatif_suplementaire AS justificatif_suplementaire_22, s1_.nom_image_principale AS nom_image_principale_23, s1_.updated_at AS updated_at_24, s1_.type_activite AS type_activite_25, s1_.nb_places_prises AS nb_places_prises_26, s1_.date_delai_reservation AS date_delai_reservation_27, s1_.date_delai_annulation AS date_delai_annulation_28, s1_.statut AS statut_29, s1_.total_liste_attente AS total_liste_attente_30, s1_.recurrence AS recurrence_31, s1_.type_recurrence AS type_recurrence_32, s1_.numero_declaration_sdjes AS numero_declaration_sdjes_33, s1_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_34, e2_.id AS id_35, e2_.nom AS nom_36, e2_.prenom AS prenom_37, e2_.sexe AS sexe_38, e2_.date_naissance AS date_naissance_39, e2_.autres_allergies AS autres_allergies_40, e2_.remarques_medicales AS remarques_medicales_41, e2_.suivi_traitement AS suivi_traitement_42, e2_.traitement AS traitement_43, e2_.nom_ordonnance AS nom_ordonnance_44, e2_.updated_at AS updated_at_45, e2_.nom_photo AS nom_photo_46, e2_.updated_at_photo AS updated_at_photo_47, e2_.autorisation_photo AS autorisation_photo_48, e2_.aeeh AS aeeh_49, e2_.est_utilisateur AS est_utilisateur_50, p3_.id AS id_51, p3_.heure_arrivee AS heure_arrivee_52, p3_.heure_depart AS heure_depart_53, s4_.id AS id_54, s4_.label AS label_55, r0_.utilisateur_id AS utilisateur_id_56, r0_.enfant_id AS enfant_id_57, r0_.activite_id AS activite_id_58, r0_.commande_id AS commande_id_59, r0_.annulation_id AS annulation_id_60, r0_.presence_sejour_id AS presence_sejour_id_61, r0_.tarif_id AS tarif_id_62, s1_.categorie_id AS categorie_id_63, s1_.coordonnees_id AS coordonnees_id_64, s1_.semaine_recurrence_id AS semaine_recurrence_id_65, p3_.statut_id AS statut_id_66 FROM reservation r0_ INNER JOIN sejour s1_ ON r0_.activite_id = s1_.id LEFT JOIN enfant e2_ ON r0_.enfant_id = e2_.id LEFT JOIN presence_sejour p3_ ON r0_.presence_sejour_id = p3_.id LEFT JOIN statut_presence s4_ ON p3_.statut_id = s4_.id LEFT JOIN reservation_creneau_activite r5_ ON r0_.id = r5_.reservation_id WHERE r0_.statut_reservation IN ('payee', 'acompte_paye', 'paiement_en_attente', 'acompte_en_attente') AND ((r0_.statut <> 'annule' OR r0_.statut IS NULL)) AND s1_.statut = 'publie' AND s1_.type_activite = 'sejours' AND r0_.archive = 0 AND r0_.valide = 1 AND s1_.recurrence = 0 AND r5_.id IS NULL;
|