| 1 |
18.86 ms |
SELECT b0_.id AS id_0, b0_.date_livraison AS date_livraison_1, b0_.heure_livraison AS heure_livraison_2, b0_.nombre_plis AS nombre_plis_3, b0_.poids AS poids_4, b0_.date_retour_boredereau AS date_retour_boredereau_5, b0_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_6, b0_.type_operation AS type_operation_7, b0_.instruction_particuliere AS instruction_particuliere_8, b0_.destinataire AS destinataire_9, b0_.adresse_livraison AS adresse_livraison_10, b0_.intruction_particuliere_livraison AS intruction_particuliere_livraison_11, b0_.statut_livraison AS statut_livraison_12, b0_.price AS price_13, b0_.number_bordereau AS number_bordereau_14, b0_.nom_client_retour_bordereau AS nom_client_retour_bordereau_15, b0_.date AS date_16, b0_.receptionnaire_colis AS receptionnaire_colis_17, b0_.non_transmis_commentaire AS non_transmis_commentaire_18, b0_.appel AS appel_19, b0_.frais_appel AS frais_appel_20, b0_.plis AS plis_21, b0_.nom_categorie_client AS nom_categorie_client_22, b0_.nombre_colis AS nombre_colis_23, b0_.nombre_avis_passage AS nombre_avis_passage_24, b0_.nombre_feuillet AS nombre_feuillet_25, b0_.reference AS reference_26, b0_.observation AS observation_27, b0_.numero_facture AS numero_facture_28, b0_.code_produit AS code_produit_29, b0_.nombre_corporate AS nombre_corporate_30, b0_.date_enlevement AS date_enlevement_31, b0_.heure_enlevement AS heure_enlevement_32, b0_.nombre_ticket AS nombre_ticket_33, b0_.reference_bordereau AS reference_bordereau_34, b0_.nombre_plis_courant AS nombre_plis_courant_35, b0_.price_complement AS price_complement_36, b0_.comment_retour_int AS comment_retour_int_37, b0_.comment_abandon_int AS comment_abandon_int_38, b0_.comment_destruction_int AS comment_destruction_int_39, b0_.comment_refus_reception_int AS comment_refus_reception_int_40, b0_.statut_representant AS statut_representant_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.deleted_at AS deleted_at_44, b0_.created_by AS created_by_45, b0_.updated_by AS updated_by_46, c1_.id AS id_47, c1_.name AS name_48, c1_.firstname AS firstname_49, c1_.phone_number AS phone_number_50, c1_.company_name AS company_name_51, c1_.number_card AS number_card_52, c1_.date_expiration AS date_expiration_53, c1_.status_generate AS status_generate_54, c1_.type AS type_55, c1_.logo AS logo_56, c1_.standard AS standard_57, c1_.mobile AS mobile_58, c1_.fax AS fax_59, c1_.bp AS bp_60, c1_.client_web AS client_web_61, c1_.numero_carre AS numero_carre_62, c1_.maison AS maison_63, c1_.email AS email_64, c1_.anniversaire AS anniversaire_65, c1_.tva AS tva_66, c1_.ifu AS ifu_67, c1_.observation AS observation_68, c1_.civilite AS civilite_69, c1_.nom_dg AS nom_dg_70, c1_.password AS password_71, c1_.regime_fiscal AS regime_fiscal_72, c1_.code_client AS code_client_73, c1_.direct AS direct_74, c1_.adresse_physique AS adresse_physique_75, c1_.personne_contact AS personne_contact_76, c1_.created_at AS created_at_77, c1_.updated_at AS updated_at_78, c1_.deleted_at AS deleted_at_79, c1_.created_by AS created_by_80, c1_.updated_by AS updated_by_81, u2_.id AS id_82, u2_.email AS email_83, u2_.roles AS roles_84, u2_.password AS password_85, u2_.first_name AS first_name_86, u2_.last_name AS last_name_87, u2_.corpate AS corpate_88, u2_.active AS active_89, u2_.date_embauche AS date_embauche_90, u2_.date_depart AS date_depart_91, u2_.interphone AS interphone_92, u2_.date_naissance AS date_naissance_93, u2_.code_employer AS code_employer_94, u2_.code_pays AS code_pays_95, u2_.mobile AS mobile_96, u2_.fax AS fax_97, u2_.telephone_employer AS telephone_employer_98, u2_.email_employer AS email_employer_99, u2_.created_at AS created_at_100, u2_.updated_at AS updated_at_101, u2_.deleted_at AS deleted_at_102, u2_.created_by AS created_by_103, u2_.updated_by AS updated_by_104, v3_.id AS id_105, v3_.nom_ville AS nom_ville_106, v3_.code_ville AS code_ville_107, v3_.tarif_puclic_courrier AS tarif_puclic_courrier_108, v3_.tarif_perso_courrier AS tarif_perso_courrier_109, v3_.delai AS delai_110, v3_.observation AS observation_111, v3_.nombre_ticket AS nombre_ticket_112, v3_.created_at AS created_at_113, v3_.updated_at AS updated_at_114, v3_.deleted_at AS deleted_at_115, v3_.created_by AS created_by_116, v3_.updated_by AS updated_by_117, b4_.id AS id_118, b4_.date_livraison AS date_livraison_119, b4_.heure_livraison AS heure_livraison_120, b4_.nombre_plis AS nombre_plis_121, b4_.poids AS poids_122, b4_.date_retour_boredereau AS date_retour_boredereau_123, b4_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_124, b4_.type_operation AS type_operation_125, b4_.instruction_particuliere AS instruction_particuliere_126, b4_.destinataire AS destinataire_127, b4_.adresse_livraison AS adresse_livraison_128, b4_.intruction_particuliere_livraison AS intruction_particuliere_livraison_129, b4_.statut_livraison AS statut_livraison_130, b4_.price AS price_131, b4_.number_bordereau AS number_bordereau_132, b4_.nom_client_retour_bordereau AS nom_client_retour_bordereau_133, b4_.date AS date_134, b4_.receptionnaire_colis AS receptionnaire_colis_135, b4_.non_transmis_commentaire AS non_transmis_commentaire_136, b4_.appel AS appel_137, b4_.frais_appel AS frais_appel_138, b4_.plis AS plis_139, b4_.nom_categorie_client AS nom_categorie_client_140, b4_.nombre_colis AS nombre_colis_141, b4_.nombre_avis_passage AS nombre_avis_passage_142, b4_.nombre_feuillet AS nombre_feuillet_143, b4_.reference AS reference_144, b4_.observation AS observation_145, b4_.numero_facture AS numero_facture_146, b4_.code_produit AS code_produit_147, b4_.nombre_corporate AS nombre_corporate_148, b4_.date_enlevement AS date_enlevement_149, b4_.heure_enlevement AS heure_enlevement_150, b4_.nombre_ticket AS nombre_ticket_151, b4_.reference_bordereau AS reference_bordereau_152, b4_.nombre_plis_courant AS nombre_plis_courant_153, b4_.price_complement AS price_complement_154, b4_.comment_retour_int AS comment_retour_int_155, b4_.comment_abandon_int AS comment_abandon_int_156, b4_.comment_destruction_int AS comment_destruction_int_157, b4_.comment_refus_reception_int AS comment_refus_reception_int_158, b4_.statut_representant AS statut_representant_159, b4_.created_at AS created_at_160, b4_.updated_at AS updated_at_161, b4_.deleted_at AS deleted_at_162, b4_.created_by AS created_by_163, b4_.updated_by AS updated_by_164, b5_.id AS id_165, b5_.date_livraison AS date_livraison_166, b5_.heure_livraison AS heure_livraison_167, b5_.nombre_plis AS nombre_plis_168, b5_.poids AS poids_169, b5_.date_retour_boredereau AS date_retour_boredereau_170, b5_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_171, b5_.type_operation AS type_operation_172, b5_.instruction_particuliere AS instruction_particuliere_173, b5_.destinataire AS destinataire_174, b5_.adresse_livraison AS adresse_livraison_175, b5_.intruction_particuliere_livraison AS intruction_particuliere_livraison_176, b5_.statut_livraison AS statut_livraison_177, b5_.price AS price_178, b5_.number_bordereau AS number_bordereau_179, b5_.nom_client_retour_bordereau AS nom_client_retour_bordereau_180, b5_.date AS date_181, b5_.receptionnaire_colis AS receptionnaire_colis_182, b5_.non_transmis_commentaire AS non_transmis_commentaire_183, b5_.appel AS appel_184, b5_.frais_appel AS frais_appel_185, b5_.plis AS plis_186, b5_.nom_categorie_client AS nom_categorie_client_187, b5_.nombre_colis AS nombre_colis_188, b5_.nombre_avis_passage AS nombre_avis_passage_189, b5_.nombre_feuillet AS nombre_feuillet_190, b5_.reference AS reference_191, b5_.observation AS observation_192, b5_.numero_facture AS numero_facture_193, b5_.code_produit AS code_produit_194, b5_.nombre_corporate AS nombre_corporate_195, b5_.date_enlevement AS date_enlevement_196, b5_.heure_enlevement AS heure_enlevement_197, b5_.nombre_ticket AS nombre_ticket_198, b5_.reference_bordereau AS reference_bordereau_199, b5_.nombre_plis_courant AS nombre_plis_courant_200, b5_.price_complement AS price_complement_201, b5_.comment_retour_int AS comment_retour_int_202, b5_.comment_abandon_int AS comment_abandon_int_203, b5_.comment_destruction_int AS comment_destruction_int_204, b5_.comment_refus_reception_int AS comment_refus_reception_int_205, b5_.statut_representant AS statut_representant_206, b5_.created_at AS created_at_207, b5_.updated_at AS updated_at_208, b5_.deleted_at AS deleted_at_209, b5_.created_by AS created_by_210, b5_.updated_by AS updated_by_211, m6_.id AS id_212, m6_.name AS name_213, b0_.client_id AS client_id_214, b0_.coursier_id AS coursier_id_215, b0_.produit_id AS produit_id_216, b0_.operation_type_id AS operation_type_id_217, b0_.ville_id AS ville_id_218, b0_.bordereau_parent_id AS bordereau_parent_id_219, b0_.bordereau_complement_parent_id AS bordereau_complement_parent_id_220, b0_.ville_complement_id AS ville_complement_id_221, b0_.motif_id AS motif_id_222, b0_.representant_id AS representant_id_223, c1_.zone_id AS zone_id_224, c1_.activite_id AS activite_id_225, c1_.quartier_id AS quartier_id_226, c1_.client_de_id AS client_de_id_227, c1_.categorie_client_id AS categorie_client_id_228, u2_.affiliate_id AS affiliate_id_229, u2_.service_id AS service_id_230, v3_.pays_id AS pays_id_231, b4_.client_id AS client_id_232, b4_.coursier_id AS coursier_id_233, b4_.produit_id AS produit_id_234, b4_.operation_type_id AS operation_type_id_235, b4_.ville_id AS ville_id_236, b4_.bordereau_parent_id AS bordereau_parent_id_237, b4_.bordereau_complement_parent_id AS bordereau_complement_parent_id_238, b4_.ville_complement_id AS ville_complement_id_239, b4_.motif_id AS motif_id_240, b4_.representant_id AS representant_id_241, b5_.client_id AS client_id_242, b5_.coursier_id AS coursier_id_243, b5_.produit_id AS produit_id_244, b5_.operation_type_id AS operation_type_id_245, b5_.ville_id AS ville_id_246, b5_.bordereau_parent_id AS bordereau_parent_id_247, b5_.bordereau_complement_parent_id AS bordereau_complement_parent_id_248, b5_.ville_complement_id AS ville_complement_id_249, b5_.motif_id AS motif_id_250, b5_.representant_id AS representant_id_251, m6_.category_id AS category_id_252 FROM bordereau b0_ LEFT JOIN client c1_ ON b0_.client_id = c1_.id LEFT JOIN `user` u2_ ON b0_.coursier_id = u2_.id LEFT JOIN ville v3_ ON b0_.ville_id = v3_.id LEFT JOIN bordereau b4_ ON b0_.bordereau_parent_id = b4_.id LEFT JOIN bordereau b5_ ON b0_.id = b5_.bordereau_parent_id LEFT JOIN motif m6_ ON b0_.motif_id = m6_.id WHERE b0_.number_bordereau = ? ORDER BY b0_.updated_at DESC
Parameters: [
"13439937"
]
SELECT
b0_.id AS id_0,
b0_.date_livraison AS date_livraison_1,
b0_.heure_livraison AS heure_livraison_2,
b0_.nombre_plis AS nombre_plis_3,
b0_.poids AS poids_4,
b0_.date_retour_boredereau AS date_retour_boredereau_5,
b0_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_6,
b0_.type_operation AS type_operation_7,
b0_.instruction_particuliere AS instruction_particuliere_8,
b0_.destinataire AS destinataire_9,
b0_.adresse_livraison AS adresse_livraison_10,
b0_.intruction_particuliere_livraison AS intruction_particuliere_livraison_11,
b0_.statut_livraison AS statut_livraison_12,
b0_.price AS price_13,
b0_.number_bordereau AS number_bordereau_14,
b0_.nom_client_retour_bordereau AS nom_client_retour_bordereau_15,
b0_.date AS date_16,
b0_.receptionnaire_colis AS receptionnaire_colis_17,
b0_.non_transmis_commentaire AS non_transmis_commentaire_18,
b0_.appel AS appel_19,
b0_.frais_appel AS frais_appel_20,
b0_.plis AS plis_21,
b0_.nom_categorie_client AS nom_categorie_client_22,
b0_.nombre_colis AS nombre_colis_23,
b0_.nombre_avis_passage AS nombre_avis_passage_24,
b0_.nombre_feuillet AS nombre_feuillet_25,
b0_.reference AS reference_26,
b0_.observation AS observation_27,
b0_.numero_facture AS numero_facture_28,
b0_.code_produit AS code_produit_29,
b0_.nombre_corporate AS nombre_corporate_30,
b0_.date_enlevement AS date_enlevement_31,
b0_.heure_enlevement AS heure_enlevement_32,
b0_.nombre_ticket AS nombre_ticket_33,
b0_.reference_bordereau AS reference_bordereau_34,
b0_.nombre_plis_courant AS nombre_plis_courant_35,
b0_.price_complement AS price_complement_36,
b0_.comment_retour_int AS comment_retour_int_37,
b0_.comment_abandon_int AS comment_abandon_int_38,
b0_.comment_destruction_int AS comment_destruction_int_39,
b0_.comment_refus_reception_int AS comment_refus_reception_int_40,
b0_.statut_representant AS statut_representant_41,
b0_.created_at AS created_at_42,
b0_.updated_at AS updated_at_43,
b0_.deleted_at AS deleted_at_44,
b0_.created_by AS created_by_45,
b0_.updated_by AS updated_by_46,
c1_.id AS id_47,
c1_.name AS name_48,
c1_.firstname AS firstname_49,
c1_.phone_number AS phone_number_50,
c1_.company_name AS company_name_51,
c1_.number_card AS number_card_52,
c1_.date_expiration AS date_expiration_53,
c1_.status_generate AS status_generate_54,
c1_.type AS type_55,
c1_.logo AS logo_56,
c1_.standard AS standard_57,
c1_.mobile AS mobile_58,
c1_.fax AS fax_59,
c1_.bp AS bp_60,
c1_.client_web AS client_web_61,
c1_.numero_carre AS numero_carre_62,
c1_.maison AS maison_63,
c1_.email AS email_64,
c1_.anniversaire AS anniversaire_65,
c1_.tva AS tva_66,
c1_.ifu AS ifu_67,
c1_.observation AS observation_68,
c1_.civilite AS civilite_69,
c1_.nom_dg AS nom_dg_70,
c1_.password AS password_71,
c1_.regime_fiscal AS regime_fiscal_72,
c1_.code_client AS code_client_73,
c1_.direct AS direct_74,
c1_.adresse_physique AS adresse_physique_75,
c1_.personne_contact AS personne_contact_76,
c1_.created_at AS created_at_77,
c1_.updated_at AS updated_at_78,
c1_.deleted_at AS deleted_at_79,
c1_.created_by AS created_by_80,
c1_.updated_by AS updated_by_81,
u2_.id AS id_82,
u2_.email AS email_83,
u2_.roles AS roles_84,
u2_.password AS password_85,
u2_.first_name AS first_name_86,
u2_.last_name AS last_name_87,
u2_.corpate AS corpate_88,
u2_.active AS active_89,
u2_.date_embauche AS date_embauche_90,
u2_.date_depart AS date_depart_91,
u2_.interphone AS interphone_92,
u2_.date_naissance AS date_naissance_93,
u2_.code_employer AS code_employer_94,
u2_.code_pays AS code_pays_95,
u2_.mobile AS mobile_96,
u2_.fax AS fax_97,
u2_.telephone_employer AS telephone_employer_98,
u2_.email_employer AS email_employer_99,
u2_.created_at AS created_at_100,
u2_.updated_at AS updated_at_101,
u2_.deleted_at AS deleted_at_102,
u2_.created_by AS created_by_103,
u2_.updated_by AS updated_by_104,
v3_.id AS id_105,
v3_.nom_ville AS nom_ville_106,
v3_.code_ville AS code_ville_107,
v3_.tarif_puclic_courrier AS tarif_puclic_courrier_108,
v3_.tarif_perso_courrier AS tarif_perso_courrier_109,
v3_.delai AS delai_110,
v3_.observation AS observation_111,
v3_.nombre_ticket AS nombre_ticket_112,
v3_.created_at AS created_at_113,
v3_.updated_at AS updated_at_114,
v3_.deleted_at AS deleted_at_115,
v3_.created_by AS created_by_116,
v3_.updated_by AS updated_by_117,
b4_.id AS id_118,
b4_.date_livraison AS date_livraison_119,
b4_.heure_livraison AS heure_livraison_120,
b4_.nombre_plis AS nombre_plis_121,
b4_.poids AS poids_122,
b4_.date_retour_boredereau AS date_retour_boredereau_123,
b4_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_124,
b4_.type_operation AS type_operation_125,
b4_.instruction_particuliere AS instruction_particuliere_126,
b4_.destinataire AS destinataire_127,
b4_.adresse_livraison AS adresse_livraison_128,
b4_.intruction_particuliere_livraison AS intruction_particuliere_livraison_129,
b4_.statut_livraison AS statut_livraison_130,
b4_.price AS price_131,
b4_.number_bordereau AS number_bordereau_132,
b4_.nom_client_retour_bordereau AS nom_client_retour_bordereau_133,
b4_.date AS date_134,
b4_.receptionnaire_colis AS receptionnaire_colis_135,
b4_.non_transmis_commentaire AS non_transmis_commentaire_136,
b4_.appel AS appel_137,
b4_.frais_appel AS frais_appel_138,
b4_.plis AS plis_139,
b4_.nom_categorie_client AS nom_categorie_client_140,
b4_.nombre_colis AS nombre_colis_141,
b4_.nombre_avis_passage AS nombre_avis_passage_142,
b4_.nombre_feuillet AS nombre_feuillet_143,
b4_.reference AS reference_144,
b4_.observation AS observation_145,
b4_.numero_facture AS numero_facture_146,
b4_.code_produit AS code_produit_147,
b4_.nombre_corporate AS nombre_corporate_148,
b4_.date_enlevement AS date_enlevement_149,
b4_.heure_enlevement AS heure_enlevement_150,
b4_.nombre_ticket AS nombre_ticket_151,
b4_.reference_bordereau AS reference_bordereau_152,
b4_.nombre_plis_courant AS nombre_plis_courant_153,
b4_.price_complement AS price_complement_154,
b4_.comment_retour_int AS comment_retour_int_155,
b4_.comment_abandon_int AS comment_abandon_int_156,
b4_.comment_destruction_int AS comment_destruction_int_157,
b4_.comment_refus_reception_int AS comment_refus_reception_int_158,
b4_.statut_representant AS statut_representant_159,
b4_.created_at AS created_at_160,
b4_.updated_at AS updated_at_161,
b4_.deleted_at AS deleted_at_162,
b4_.created_by AS created_by_163,
b4_.updated_by AS updated_by_164,
b5_.id AS id_165,
b5_.date_livraison AS date_livraison_166,
b5_.heure_livraison AS heure_livraison_167,
b5_.nombre_plis AS nombre_plis_168,
b5_.poids AS poids_169,
b5_.date_retour_boredereau AS date_retour_boredereau_170,
b5_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_171,
b5_.type_operation AS type_operation_172,
b5_.instruction_particuliere AS instruction_particuliere_173,
b5_.destinataire AS destinataire_174,
b5_.adresse_livraison AS adresse_livraison_175,
b5_.intruction_particuliere_livraison AS intruction_particuliere_livraison_176,
b5_.statut_livraison AS statut_livraison_177,
b5_.price AS price_178,
b5_.number_bordereau AS number_bordereau_179,
b5_.nom_client_retour_bordereau AS nom_client_retour_bordereau_180,
b5_.date AS date_181,
b5_.receptionnaire_colis AS receptionnaire_colis_182,
b5_.non_transmis_commentaire AS non_transmis_commentaire_183,
b5_.appel AS appel_184,
b5_.frais_appel AS frais_appel_185,
b5_.plis AS plis_186,
b5_.nom_categorie_client AS nom_categorie_client_187,
b5_.nombre_colis AS nombre_colis_188,
b5_.nombre_avis_passage AS nombre_avis_passage_189,
b5_.nombre_feuillet AS nombre_feuillet_190,
b5_.reference AS reference_191,
b5_.observation AS observation_192,
b5_.numero_facture AS numero_facture_193,
b5_.code_produit AS code_produit_194,
b5_.nombre_corporate AS nombre_corporate_195,
b5_.date_enlevement AS date_enlevement_196,
b5_.heure_enlevement AS heure_enlevement_197,
b5_.nombre_ticket AS nombre_ticket_198,
b5_.reference_bordereau AS reference_bordereau_199,
b5_.nombre_plis_courant AS nombre_plis_courant_200,
b5_.price_complement AS price_complement_201,
b5_.comment_retour_int AS comment_retour_int_202,
b5_.comment_abandon_int AS comment_abandon_int_203,
b5_.comment_destruction_int AS comment_destruction_int_204,
b5_.comment_refus_reception_int AS comment_refus_reception_int_205,
b5_.statut_representant AS statut_representant_206,
b5_.created_at AS created_at_207,
b5_.updated_at AS updated_at_208,
b5_.deleted_at AS deleted_at_209,
b5_.created_by AS created_by_210,
b5_.updated_by AS updated_by_211,
m6_.id AS id_212,
m6_.name AS name_213,
b0_.client_id AS client_id_214,
b0_.coursier_id AS coursier_id_215,
b0_.produit_id AS produit_id_216,
b0_.operation_type_id AS operation_type_id_217,
b0_.ville_id AS ville_id_218,
b0_.bordereau_parent_id AS bordereau_parent_id_219,
b0_.bordereau_complement_parent_id AS bordereau_complement_parent_id_220,
b0_.ville_complement_id AS ville_complement_id_221,
b0_.motif_id AS motif_id_222,
b0_.representant_id AS representant_id_223,
c1_.zone_id AS zone_id_224,
c1_.activite_id AS activite_id_225,
c1_.quartier_id AS quartier_id_226,
c1_.client_de_id AS client_de_id_227,
c1_.categorie_client_id AS categorie_client_id_228,
u2_.affiliate_id AS affiliate_id_229,
u2_.service_id AS service_id_230,
v3_.pays_id AS pays_id_231,
b4_.client_id AS client_id_232,
b4_.coursier_id AS coursier_id_233,
b4_.produit_id AS produit_id_234,
b4_.operation_type_id AS operation_type_id_235,
b4_.ville_id AS ville_id_236,
b4_.bordereau_parent_id AS bordereau_parent_id_237,
b4_.bordereau_complement_parent_id AS bordereau_complement_parent_id_238,
b4_.ville_complement_id AS ville_complement_id_239,
b4_.motif_id AS motif_id_240,
b4_.representant_id AS representant_id_241,
b5_.client_id AS client_id_242,
b5_.coursier_id AS coursier_id_243,
b5_.produit_id AS produit_id_244,
b5_.operation_type_id AS operation_type_id_245,
b5_.ville_id AS ville_id_246,
b5_.bordereau_parent_id AS bordereau_parent_id_247,
b5_.bordereau_complement_parent_id AS bordereau_complement_parent_id_248,
b5_.ville_complement_id AS ville_complement_id_249,
b5_.motif_id AS motif_id_250,
b5_.representant_id AS representant_id_251,
m6_.category_id AS category_id_252
FROM
bordereau b0_
LEFT JOIN client c1_ ON b0_.client_id = c1_.id
LEFT JOIN `user` u2_ ON b0_.coursier_id = u2_.id
LEFT JOIN ville v3_ ON b0_.ville_id = v3_.id
LEFT JOIN bordereau b4_ ON b0_.bordereau_parent_id = b4_.id
LEFT JOIN bordereau b5_ ON b0_.id = b5_.bordereau_parent_id
LEFT JOIN motif m6_ ON b0_.motif_id = m6_.id
WHERE
b0_.number_bordereau = ?
ORDER BY
b0_.updated_at DESC
SELECT b0_.id AS id_0, b0_.date_livraison AS date_livraison_1, b0_.heure_livraison AS heure_livraison_2, b0_.nombre_plis AS nombre_plis_3, b0_.poids AS poids_4, b0_.date_retour_boredereau AS date_retour_boredereau_5, b0_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_6, b0_.type_operation AS type_operation_7, b0_.instruction_particuliere AS instruction_particuliere_8, b0_.destinataire AS destinataire_9, b0_.adresse_livraison AS adresse_livraison_10, b0_.intruction_particuliere_livraison AS intruction_particuliere_livraison_11, b0_.statut_livraison AS statut_livraison_12, b0_.price AS price_13, b0_.number_bordereau AS number_bordereau_14, b0_.nom_client_retour_bordereau AS nom_client_retour_bordereau_15, b0_.date AS date_16, b0_.receptionnaire_colis AS receptionnaire_colis_17, b0_.non_transmis_commentaire AS non_transmis_commentaire_18, b0_.appel AS appel_19, b0_.frais_appel AS frais_appel_20, b0_.plis AS plis_21, b0_.nom_categorie_client AS nom_categorie_client_22, b0_.nombre_colis AS nombre_colis_23, b0_.nombre_avis_passage AS nombre_avis_passage_24, b0_.nombre_feuillet AS nombre_feuillet_25, b0_.reference AS reference_26, b0_.observation AS observation_27, b0_.numero_facture AS numero_facture_28, b0_.code_produit AS code_produit_29, b0_.nombre_corporate AS nombre_corporate_30, b0_.date_enlevement AS date_enlevement_31, b0_.heure_enlevement AS heure_enlevement_32, b0_.nombre_ticket AS nombre_ticket_33, b0_.reference_bordereau AS reference_bordereau_34, b0_.nombre_plis_courant AS nombre_plis_courant_35, b0_.price_complement AS price_complement_36, b0_.comment_retour_int AS comment_retour_int_37, b0_.comment_abandon_int AS comment_abandon_int_38, b0_.comment_destruction_int AS comment_destruction_int_39, b0_.comment_refus_reception_int AS comment_refus_reception_int_40, b0_.statut_representant AS statut_representant_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.deleted_at AS deleted_at_44, b0_.created_by AS created_by_45, b0_.updated_by AS updated_by_46, c1_.id AS id_47, c1_.name AS name_48, c1_.firstname AS firstname_49, c1_.phone_number AS phone_number_50, c1_.company_name AS company_name_51, c1_.number_card AS number_card_52, c1_.date_expiration AS date_expiration_53, c1_.status_generate AS status_generate_54, c1_.type AS type_55, c1_.logo AS logo_56, c1_.standard AS standard_57, c1_.mobile AS mobile_58, c1_.fax AS fax_59, c1_.bp AS bp_60, c1_.client_web AS client_web_61, c1_.numero_carre AS numero_carre_62, c1_.maison AS maison_63, c1_.email AS email_64, c1_.anniversaire AS anniversaire_65, c1_.tva AS tva_66, c1_.ifu AS ifu_67, c1_.observation AS observation_68, c1_.civilite AS civilite_69, c1_.nom_dg AS nom_dg_70, c1_.password AS password_71, c1_.regime_fiscal AS regime_fiscal_72, c1_.code_client AS code_client_73, c1_.direct AS direct_74, c1_.adresse_physique AS adresse_physique_75, c1_.personne_contact AS personne_contact_76, c1_.created_at AS created_at_77, c1_.updated_at AS updated_at_78, c1_.deleted_at AS deleted_at_79, c1_.created_by AS created_by_80, c1_.updated_by AS updated_by_81, u2_.id AS id_82, u2_.email AS email_83, u2_.roles AS roles_84, u2_.password AS password_85, u2_.first_name AS first_name_86, u2_.last_name AS last_name_87, u2_.corpate AS corpate_88, u2_.active AS active_89, u2_.date_embauche AS date_embauche_90, u2_.date_depart AS date_depart_91, u2_.interphone AS interphone_92, u2_.date_naissance AS date_naissance_93, u2_.code_employer AS code_employer_94, u2_.code_pays AS code_pays_95, u2_.mobile AS mobile_96, u2_.fax AS fax_97, u2_.telephone_employer AS telephone_employer_98, u2_.email_employer AS email_employer_99, u2_.created_at AS created_at_100, u2_.updated_at AS updated_at_101, u2_.deleted_at AS deleted_at_102, u2_.created_by AS created_by_103, u2_.updated_by AS updated_by_104, v3_.id AS id_105, v3_.nom_ville AS nom_ville_106, v3_.code_ville AS code_ville_107, v3_.tarif_puclic_courrier AS tarif_puclic_courrier_108, v3_.tarif_perso_courrier AS tarif_perso_courrier_109, v3_.delai AS delai_110, v3_.observation AS observation_111, v3_.nombre_ticket AS nombre_ticket_112, v3_.created_at AS created_at_113, v3_.updated_at AS updated_at_114, v3_.deleted_at AS deleted_at_115, v3_.created_by AS created_by_116, v3_.updated_by AS updated_by_117, b4_.id AS id_118, b4_.date_livraison AS date_livraison_119, b4_.heure_livraison AS heure_livraison_120, b4_.nombre_plis AS nombre_plis_121, b4_.poids AS poids_122, b4_.date_retour_boredereau AS date_retour_boredereau_123, b4_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_124, b4_.type_operation AS type_operation_125, b4_.instruction_particuliere AS instruction_particuliere_126, b4_.destinataire AS destinataire_127, b4_.adresse_livraison AS adresse_livraison_128, b4_.intruction_particuliere_livraison AS intruction_particuliere_livraison_129, b4_.statut_livraison AS statut_livraison_130, b4_.price AS price_131, b4_.number_bordereau AS number_bordereau_132, b4_.nom_client_retour_bordereau AS nom_client_retour_bordereau_133, b4_.date AS date_134, b4_.receptionnaire_colis AS receptionnaire_colis_135, b4_.non_transmis_commentaire AS non_transmis_commentaire_136, b4_.appel AS appel_137, b4_.frais_appel AS frais_appel_138, b4_.plis AS plis_139, b4_.nom_categorie_client AS nom_categorie_client_140, b4_.nombre_colis AS nombre_colis_141, b4_.nombre_avis_passage AS nombre_avis_passage_142, b4_.nombre_feuillet AS nombre_feuillet_143, b4_.reference AS reference_144, b4_.observation AS observation_145, b4_.numero_facture AS numero_facture_146, b4_.code_produit AS code_produit_147, b4_.nombre_corporate AS nombre_corporate_148, b4_.date_enlevement AS date_enlevement_149, b4_.heure_enlevement AS heure_enlevement_150, b4_.nombre_ticket AS nombre_ticket_151, b4_.reference_bordereau AS reference_bordereau_152, b4_.nombre_plis_courant AS nombre_plis_courant_153, b4_.price_complement AS price_complement_154, b4_.comment_retour_int AS comment_retour_int_155, b4_.comment_abandon_int AS comment_abandon_int_156, b4_.comment_destruction_int AS comment_destruction_int_157, b4_.comment_refus_reception_int AS comment_refus_reception_int_158, b4_.statut_representant AS statut_representant_159, b4_.created_at AS created_at_160, b4_.updated_at AS updated_at_161, b4_.deleted_at AS deleted_at_162, b4_.created_by AS created_by_163, b4_.updated_by AS updated_by_164, b5_.id AS id_165, b5_.date_livraison AS date_livraison_166, b5_.heure_livraison AS heure_livraison_167, b5_.nombre_plis AS nombre_plis_168, b5_.poids AS poids_169, b5_.date_retour_boredereau AS date_retour_boredereau_170, b5_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_171, b5_.type_operation AS type_operation_172, b5_.instruction_particuliere AS instruction_particuliere_173, b5_.destinataire AS destinataire_174, b5_.adresse_livraison AS adresse_livraison_175, b5_.intruction_particuliere_livraison AS intruction_particuliere_livraison_176, b5_.statut_livraison AS statut_livraison_177, b5_.price AS price_178, b5_.number_bordereau AS number_bordereau_179, b5_.nom_client_retour_bordereau AS nom_client_retour_bordereau_180, b5_.date AS date_181, b5_.receptionnaire_colis AS receptionnaire_colis_182, b5_.non_transmis_commentaire AS non_transmis_commentaire_183, b5_.appel AS appel_184, b5_.frais_appel AS frais_appel_185, b5_.plis AS plis_186, b5_.nom_categorie_client AS nom_categorie_client_187, b5_.nombre_colis AS nombre_colis_188, b5_.nombre_avis_passage AS nombre_avis_passage_189, b5_.nombre_feuillet AS nombre_feuillet_190, b5_.reference AS reference_191, b5_.observation AS observation_192, b5_.numero_facture AS numero_facture_193, b5_.code_produit AS code_produit_194, b5_.nombre_corporate AS nombre_corporate_195, b5_.date_enlevement AS date_enlevement_196, b5_.heure_enlevement AS heure_enlevement_197, b5_.nombre_ticket AS nombre_ticket_198, b5_.reference_bordereau AS reference_bordereau_199, b5_.nombre_plis_courant AS nombre_plis_courant_200, b5_.price_complement AS price_complement_201, b5_.comment_retour_int AS comment_retour_int_202, b5_.comment_abandon_int AS comment_abandon_int_203, b5_.comment_destruction_int AS comment_destruction_int_204, b5_.comment_refus_reception_int AS comment_refus_reception_int_205, b5_.statut_representant AS statut_representant_206, b5_.created_at AS created_at_207, b5_.updated_at AS updated_at_208, b5_.deleted_at AS deleted_at_209, b5_.created_by AS created_by_210, b5_.updated_by AS updated_by_211, m6_.id AS id_212, m6_.name AS name_213, b0_.client_id AS client_id_214, b0_.coursier_id AS coursier_id_215, b0_.produit_id AS produit_id_216, b0_.operation_type_id AS operation_type_id_217, b0_.ville_id AS ville_id_218, b0_.bordereau_parent_id AS bordereau_parent_id_219, b0_.bordereau_complement_parent_id AS bordereau_complement_parent_id_220, b0_.ville_complement_id AS ville_complement_id_221, b0_.motif_id AS motif_id_222, b0_.representant_id AS representant_id_223, c1_.zone_id AS zone_id_224, c1_.activite_id AS activite_id_225, c1_.quartier_id AS quartier_id_226, c1_.client_de_id AS client_de_id_227, c1_.categorie_client_id AS categorie_client_id_228, u2_.affiliate_id AS affiliate_id_229, u2_.service_id AS service_id_230, v3_.pays_id AS pays_id_231, b4_.client_id AS client_id_232, b4_.coursier_id AS coursier_id_233, b4_.produit_id AS produit_id_234, b4_.operation_type_id AS operation_type_id_235, b4_.ville_id AS ville_id_236, b4_.bordereau_parent_id AS bordereau_parent_id_237, b4_.bordereau_complement_parent_id AS bordereau_complement_parent_id_238, b4_.ville_complement_id AS ville_complement_id_239, b4_.motif_id AS motif_id_240, b4_.representant_id AS representant_id_241, b5_.client_id AS client_id_242, b5_.coursier_id AS coursier_id_243, b5_.produit_id AS produit_id_244, b5_.operation_type_id AS operation_type_id_245, b5_.ville_id AS ville_id_246, b5_.bordereau_parent_id AS bordereau_parent_id_247, b5_.bordereau_complement_parent_id AS bordereau_complement_parent_id_248, b5_.ville_complement_id AS ville_complement_id_249, b5_.motif_id AS motif_id_250, b5_.representant_id AS representant_id_251, m6_.category_id AS category_id_252 FROM bordereau b0_ LEFT JOIN client c1_ ON b0_.client_id = c1_.id LEFT JOIN `user` u2_ ON b0_.coursier_id = u2_.id LEFT JOIN ville v3_ ON b0_.ville_id = v3_.id LEFT JOIN bordereau b4_ ON b0_.bordereau_parent_id = b4_.id LEFT JOIN bordereau b5_ ON b0_.id = b5_.bordereau_parent_id LEFT JOIN motif m6_ ON b0_.motif_id = m6_.id WHERE b0_.number_bordereau = '13439937' ORDER BY b0_.updated_at DESC;
|