3.17 ms
(47.82%)
|
1 |
SELECT b0_.id AS id_0, b0_.demande AS demande_1, b0_.number AS number_2, b0_.mode AS mode_3, b0_.sens AS sens_4, b0_.valeur AS valeur_5, b0_.valeur_finale AS valeur_finale_6, b0_.devise_valeur AS devise_valeur_7, b0_.reference_doc_number AS reference_doc_number_8, b0_.reference_doc_child_number AS reference_doc_child_number_9, b0_.shipper AS shipper_10, b0_.foreign_shipper AS foreign_shipper_11, b0_.forwarding_agent AS forwarding_agent_12, b0_.carrier AS carrier_13, b0_.country_of_origin AS country_of_origin_14, b0_.country_of_loading AS country_of_loading_15, b0_.port_of_loading AS port_of_loading_16, b0_.country_of_discharge AS country_of_discharge_17, b0_.port_of_discharge AS port_of_discharge_18, b0_.final_destination AS final_destination_19, b0_.loaded_at AS loaded_at_20, b0_.discharged_at AS discharged_at_21, b0_.eta AS eta_22, b0_.ata AS ata_23, b0_.etd AS etd_24, b0_.atd AS atd_25, b0_.incoterm AS incoterm_26, b0_.vessel AS vessel_27, b0_.voyage AS voyage_28, b0_.freight AS freight_29, b0_.freight_cur AS freight_cur_30, b0_.insurance AS insurance_31, b0_.insurance_cur AS insurance_cur_32, b0_.baf AS baf_33, b0_.baf_cur AS baf_cur_34, b0_.caf AS caf_35, b0_.caf_cur AS caf_cur_36, b0_.thc AS thc_37, b0_.thc_cur AS thc_cur_38, b0_.frais_sup AS frais_sup_39, b0_.frais_sup_cur AS frais_sup_cur_40, b0_.conditionnement AS conditionnement_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.submitted_at AS submitted_at_44, b0_.lastly_submitted_at AS lastly_submitted_at_45, b0_.verified_at AS verified_at_46, b0_.validated_at AS validated_at_47, b0_.status AS status_48, b0_.authenticated_at AS authenticated_at_49, b0_.printed_at AS printed_at_50, b0_.billed_at AS billed_at_51, b0_.paid_at AS paid_at_52, b0_.is_completed AS is_completed_53, b0_.is_locked AS is_locked_54, b0_.locked_at AS locked_at_55, b0_.is_suspended AS is_suspended_56, b0_.suspended_at AS suspended_at_57, b0_.motif_rejet AS motif_rejet_58, b0_.is_regul AS is_regul_59, b0_.pdf_data AS pdf_data_60, b0_.xml_data AS xml_data_61, b0_.classe_tarifaire AS classe_tarifaire_62, b0_.is_transit AS is_transit_63, b0_.country_of_transit AS country_of_transit_64, b0_.tarification_zone AS tarification_zone_65, b0_.integrity AS integrity_66, b0_.must_zip AS must_zip_67, b0_.is_files_converted AS is_files_converted_68, u1_.id AS id_69, u1_.company_uuid AS company_uuid_70, u1_.email AS email_71, u1_.name AS name_72, u1_.company_name AS company_name_73, u1_.roles AS roles_74, u1_.distant_id AS distant_id_75, u1_.token AS token_76, u1_.token_expired_at AS token_expired_at_77, u1_.is_consignataire_vehicule AS is_consignataire_vehicule_78, e2_.id AS id_79, e2_.ref AS ref_80, e2_.is_used AS is_used_81, e2_.created_at AS created_at_82, r3_.id AS id_83, r3_.valeur AS valeur_84, r3_.devise_valeur AS devise_valeur_85, r3_.status AS status_86, r3_.validated_at AS validated_at_87, r3_.description AS description_88, r3_.is_paid AS is_paid_89, r3_.is_main_paid AS is_main_paid_90, r3_.created_at AS created_at_91, r3_.paid_at AS paid_at_92, e4_.id AS id_93, e4_.description AS description_94, e4_.is_cancelled AS is_cancelled_95, e4_.valeur AS valeur_96, e4_.devise_valeur AS devise_valeur_97, e4_.created_at AS created_at_98, e4_.updated_at AS updated_at_99, e4_.validated_at AS validated_at_100, b5_.id AS id_101, b5_.demande AS demande_102, b5_.number AS number_103, b5_.mode AS mode_104, b5_.sens AS sens_105, b5_.valeur AS valeur_106, b5_.valeur_finale AS valeur_finale_107, b5_.devise_valeur AS devise_valeur_108, b5_.reference_doc_number AS reference_doc_number_109, b5_.reference_doc_child_number AS reference_doc_child_number_110, b5_.shipper AS shipper_111, b5_.foreign_shipper AS foreign_shipper_112, b5_.forwarding_agent AS forwarding_agent_113, b5_.carrier AS carrier_114, b5_.country_of_origin AS country_of_origin_115, b5_.country_of_loading AS country_of_loading_116, b5_.port_of_loading AS port_of_loading_117, b5_.country_of_discharge AS country_of_discharge_118, b5_.port_of_discharge AS port_of_discharge_119, b5_.final_destination AS final_destination_120, b5_.loaded_at AS loaded_at_121, b5_.discharged_at AS discharged_at_122, b5_.eta AS eta_123, b5_.ata AS ata_124, b5_.etd AS etd_125, b5_.atd AS atd_126, b5_.incoterm AS incoterm_127, b5_.vessel AS vessel_128, b5_.voyage AS voyage_129, b5_.freight AS freight_130, b5_.freight_cur AS freight_cur_131, b5_.insurance AS insurance_132, b5_.insurance_cur AS insurance_cur_133, b5_.baf AS baf_134, b5_.baf_cur AS baf_cur_135, b5_.caf AS caf_136, b5_.caf_cur AS caf_cur_137, b5_.thc AS thc_138, b5_.thc_cur AS thc_cur_139, b5_.frais_sup AS frais_sup_140, b5_.frais_sup_cur AS frais_sup_cur_141, b5_.conditionnement AS conditionnement_142, b5_.created_at AS created_at_143, b5_.updated_at AS updated_at_144, b5_.submitted_at AS submitted_at_145, b5_.lastly_submitted_at AS lastly_submitted_at_146, b5_.status AS status_147, b5_.invoice_value AS invoice_value_148, b5_.invoice_value_cur AS invoice_value_cur_149, b5_.fob_value AS fob_value_150, b5_.weight AS weight_151, b5_.volume AS volume_152, b5_.description AS description_153, b5_.number_of_vehicules AS number_of_vehicules_154, b5_.number_of_motos AS number_of_motos_155, b5_.number_of_container_fourty AS number_of_container_fourty_156, b5_.number_of_container_twenty AS number_of_container_twenty_157, b5_.number_of_pkgs AS number_of_pkgs_158, b5_.is_completed AS is_completed_159, b5_.motif_rejet AS motif_rejet_160, b5_.commercial_transactions AS commercial_transactions_161, b5_.classe_tarifaire AS classe_tarifaire_162, b5_.is_transit AS is_transit_163, b5_.country_of_transit AS country_of_transit_164, b5_.tarification_zone AS tarification_zone_165, b5_.is_initiated AS is_initiated_166, b5_.initiated_at AS initiated_at_167, b0_.created_by_id AS created_by_id_168, b0_.updated_by_id AS updated_by_id_169, b0_.submitted_by_id AS submitted_by_id_170, b0_.verified_by_id AS verified_by_id_171, b0_.validated_by_id AS validated_by_id_172, b0_.authenticated_by_id AS authenticated_by_id_173, b0_.printed_by_id AS printed_by_id_174, b0_.billed_by_id AS billed_by_id_175, b0_.paid_by_id AS paid_by_id_176, b0_.ref_doc_file_id AS ref_doc_file_id_177, b0_.ref_doc_child_file_id AS ref_doc_child_file_id_178, b0_.commercial_file_id AS commercial_file_id_179, b0_.fret_file_id AS fret_file_id_180, b0_.custom_declaration_file_id AS custom_declaration_file_id_181, b0_.packing_list_file_id AS packing_list_file_id_182, b0_.origin_certificate_file_id AS origin_certificate_file_id_183, b0_.special_authorisation_file_id AS special_authorisation_file_id_184, b0_.certificat_empotage_file_id AS certificat_empotage_file_id_185, b0_.vgm_file_id AS vgm_file_id_186, b0_.locked_by_id AS locked_by_id_187, b0_.suspended_by_id AS suspended_by_id_188, b0_.temp_ref_id AS temp_ref_id_189, b0_.redressement_id AS redressement_id_190, b0_.exoneration_id AS exoneration_id_191, e2_.user_id AS user_id_192, r3_.validated_by_id AS validated_by_id_193, e4_.exoneration_file_id AS exoneration_file_id_194, e4_.validated_by_id AS validated_by_id_195, e4_.updated_by_id AS updated_by_id_196, b5_.created_by_id AS created_by_id_197, b5_.updated_by_id AS updated_by_id_198, b5_.ref_doc_file_id AS ref_doc_file_id_199, b5_.ref_doc_child_file_id AS ref_doc_child_file_id_200, b5_.commercial_file_id AS commercial_file_id_201, b5_.fret_file_id AS fret_file_id_202, b5_.custom_declaration_file_id AS custom_declaration_file_id_203, b5_.packing_list_file_id AS packing_list_file_id_204, b5_.origin_certificate_file_id AS origin_certificate_file_id_205, b5_.special_authorisation_file_id AS special_authorisation_file_id_206, b5_.certificat_empotage_file_id AS certificat_empotage_file_id_207, b5_.vgm_file_id AS vgm_file_id_208, b5_.besc_id AS besc_id_209 FROM besc b0_ INNER JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN extra_reference e2_ ON b0_.temp_ref_id = e2_.id LEFT JOIN redressement r3_ ON b0_.redressement_id = r3_.id LEFT JOIN exoneration e4_ ON b0_.exoneration_id = e4_.id LEFT JOIN besc_mask b5_ ON b0_.id = b5_.besc_id WHERE b0_.created_by_id IN (SELECT b6_.created_by_id AS sclr_210 FROM user u7_ INNER JOIN besc b6_ ON u7_.id = b6_.created_by_id WHERE u7_.id = ?) ORDER BY b0_.created_at DESC LIMIT 10
Parameters: [
b"Q/V˜MVF@´¾à£¼òüT"
]
SELECT
b0_.id AS id_0,
b0_.demande AS demande_1,
b0_.number AS number_2,
b0_.mode AS mode_3,
b0_.sens AS sens_4,
b0_.valeur AS valeur_5,
b0_.valeur_finale AS valeur_finale_6,
b0_.devise_valeur AS devise_valeur_7,
b0_.reference_doc_number AS reference_doc_number_8,
b0_.reference_doc_child_number AS reference_doc_child_number_9,
b0_.shipper AS shipper_10,
b0_.foreign_shipper AS foreign_shipper_11,
b0_.forwarding_agent AS forwarding_agent_12,
b0_.carrier AS carrier_13,
b0_.country_of_origin AS country_of_origin_14,
b0_.country_of_loading AS country_of_loading_15,
b0_.port_of_loading AS port_of_loading_16,
b0_.country_of_discharge AS country_of_discharge_17,
b0_.port_of_discharge AS port_of_discharge_18,
b0_.final_destination AS final_destination_19,
b0_.loaded_at AS loaded_at_20,
b0_.discharged_at AS discharged_at_21,
b0_.eta AS eta_22,
b0_.ata AS ata_23,
b0_.etd AS etd_24,
b0_.atd AS atd_25,
b0_.incoterm AS incoterm_26,
b0_.vessel AS vessel_27,
b0_.voyage AS voyage_28,
b0_.freight AS freight_29,
b0_.freight_cur AS freight_cur_30,
b0_.insurance AS insurance_31,
b0_.insurance_cur AS insurance_cur_32,
b0_.baf AS baf_33,
b0_.baf_cur AS baf_cur_34,
b0_.caf AS caf_35,
b0_.caf_cur AS caf_cur_36,
b0_.thc AS thc_37,
b0_.thc_cur AS thc_cur_38,
b0_.frais_sup AS frais_sup_39,
b0_.frais_sup_cur AS frais_sup_cur_40,
b0_.conditionnement AS conditionnement_41,
b0_.created_at AS created_at_42,
b0_.updated_at AS updated_at_43,
b0_.submitted_at AS submitted_at_44,
b0_.lastly_submitted_at AS lastly_submitted_at_45,
b0_.verified_at AS verified_at_46,
b0_.validated_at AS validated_at_47,
b0_.status AS status_48,
b0_.authenticated_at AS authenticated_at_49,
b0_.printed_at AS printed_at_50,
b0_.billed_at AS billed_at_51,
b0_.paid_at AS paid_at_52,
b0_.is_completed AS is_completed_53,
b0_.is_locked AS is_locked_54,
b0_.locked_at AS locked_at_55,
b0_.is_suspended AS is_suspended_56,
b0_.suspended_at AS suspended_at_57,
b0_.motif_rejet AS motif_rejet_58,
b0_.is_regul AS is_regul_59,
b0_.pdf_data AS pdf_data_60,
b0_.xml_data AS xml_data_61,
b0_.classe_tarifaire AS classe_tarifaire_62,
b0_.is_transit AS is_transit_63,
b0_.country_of_transit AS country_of_transit_64,
b0_.tarification_zone AS tarification_zone_65,
b0_.integrity AS integrity_66,
b0_.must_zip AS must_zip_67,
b0_.is_files_converted AS is_files_converted_68,
u1_.id AS id_69,
u1_.company_uuid AS company_uuid_70,
u1_.email AS email_71,
u1_.name AS name_72,
u1_.company_name AS company_name_73,
u1_.roles AS roles_74,
u1_.distant_id AS distant_id_75,
u1_.token AS token_76,
u1_.token_expired_at AS token_expired_at_77,
u1_.is_consignataire_vehicule AS is_consignataire_vehicule_78,
e2_.id AS id_79,
e2_.ref AS ref_80,
e2_.is_used AS is_used_81,
e2_.created_at AS created_at_82,
r3_.id AS id_83,
r3_.valeur AS valeur_84,
r3_.devise_valeur AS devise_valeur_85,
r3_.status AS status_86,
r3_.validated_at AS validated_at_87,
r3_.description AS description_88,
r3_.is_paid AS is_paid_89,
r3_.is_main_paid AS is_main_paid_90,
r3_.created_at AS created_at_91,
r3_.paid_at AS paid_at_92,
e4_.id AS id_93,
e4_.description AS description_94,
e4_.is_cancelled AS is_cancelled_95,
e4_.valeur AS valeur_96,
e4_.devise_valeur AS devise_valeur_97,
e4_.created_at AS created_at_98,
e4_.updated_at AS updated_at_99,
e4_.validated_at AS validated_at_100,
b5_.id AS id_101,
b5_.demande AS demande_102,
b5_.number AS number_103,
b5_.mode AS mode_104,
b5_.sens AS sens_105,
b5_.valeur AS valeur_106,
b5_.valeur_finale AS valeur_finale_107,
b5_.devise_valeur AS devise_valeur_108,
b5_.reference_doc_number AS reference_doc_number_109,
b5_.reference_doc_child_number AS reference_doc_child_number_110,
b5_.shipper AS shipper_111,
b5_.foreign_shipper AS foreign_shipper_112,
b5_.forwarding_agent AS forwarding_agent_113,
b5_.carrier AS carrier_114,
b5_.country_of_origin AS country_of_origin_115,
b5_.country_of_loading AS country_of_loading_116,
b5_.port_of_loading AS port_of_loading_117,
b5_.country_of_discharge AS country_of_discharge_118,
b5_.port_of_discharge AS port_of_discharge_119,
b5_.final_destination AS final_destination_120,
b5_.loaded_at AS loaded_at_121,
b5_.discharged_at AS discharged_at_122,
b5_.eta AS eta_123,
b5_.ata AS ata_124,
b5_.etd AS etd_125,
b5_.atd AS atd_126,
b5_.incoterm AS incoterm_127,
b5_.vessel AS vessel_128,
b5_.voyage AS voyage_129,
b5_.freight AS freight_130,
b5_.freight_cur AS freight_cur_131,
b5_.insurance AS insurance_132,
b5_.insurance_cur AS insurance_cur_133,
b5_.baf AS baf_134,
b5_.baf_cur AS baf_cur_135,
b5_.caf AS caf_136,
b5_.caf_cur AS caf_cur_137,
b5_.thc AS thc_138,
b5_.thc_cur AS thc_cur_139,
b5_.frais_sup AS frais_sup_140,
b5_.frais_sup_cur AS frais_sup_cur_141,
b5_.conditionnement AS conditionnement_142,
b5_.created_at AS created_at_143,
b5_.updated_at AS updated_at_144,
b5_.submitted_at AS submitted_at_145,
b5_.lastly_submitted_at AS lastly_submitted_at_146,
b5_.status AS status_147,
b5_.invoice_value AS invoice_value_148,
b5_.invoice_value_cur AS invoice_value_cur_149,
b5_.fob_value AS fob_value_150,
b5_.weight AS weight_151,
b5_.volume AS volume_152,
b5_.description AS description_153,
b5_.number_of_vehicules AS number_of_vehicules_154,
b5_.number_of_motos AS number_of_motos_155,
b5_.number_of_container_fourty AS number_of_container_fourty_156,
b5_.number_of_container_twenty AS number_of_container_twenty_157,
b5_.number_of_pkgs AS number_of_pkgs_158,
b5_.is_completed AS is_completed_159,
b5_.motif_rejet AS motif_rejet_160,
b5_.commercial_transactions AS commercial_transactions_161,
b5_.classe_tarifaire AS classe_tarifaire_162,
b5_.is_transit AS is_transit_163,
b5_.country_of_transit AS country_of_transit_164,
b5_.tarification_zone AS tarification_zone_165,
b5_.is_initiated AS is_initiated_166,
b5_.initiated_at AS initiated_at_167,
b0_.created_by_id AS created_by_id_168,
b0_.updated_by_id AS updated_by_id_169,
b0_.submitted_by_id AS submitted_by_id_170,
b0_.verified_by_id AS verified_by_id_171,
b0_.validated_by_id AS validated_by_id_172,
b0_.authenticated_by_id AS authenticated_by_id_173,
b0_.printed_by_id AS printed_by_id_174,
b0_.billed_by_id AS billed_by_id_175,
b0_.paid_by_id AS paid_by_id_176,
b0_.ref_doc_file_id AS ref_doc_file_id_177,
b0_.ref_doc_child_file_id AS ref_doc_child_file_id_178,
b0_.commercial_file_id AS commercial_file_id_179,
b0_.fret_file_id AS fret_file_id_180,
b0_.custom_declaration_file_id AS custom_declaration_file_id_181,
b0_.packing_list_file_id AS packing_list_file_id_182,
b0_.origin_certificate_file_id AS origin_certificate_file_id_183,
b0_.special_authorisation_file_id AS special_authorisation_file_id_184,
b0_.certificat_empotage_file_id AS certificat_empotage_file_id_185,
b0_.vgm_file_id AS vgm_file_id_186,
b0_.locked_by_id AS locked_by_id_187,
b0_.suspended_by_id AS suspended_by_id_188,
b0_.temp_ref_id AS temp_ref_id_189,
b0_.redressement_id AS redressement_id_190,
b0_.exoneration_id AS exoneration_id_191,
e2_.user_id AS user_id_192,
r3_.validated_by_id AS validated_by_id_193,
e4_.exoneration_file_id AS exoneration_file_id_194,
e4_.validated_by_id AS validated_by_id_195,
e4_.updated_by_id AS updated_by_id_196,
b5_.created_by_id AS created_by_id_197,
b5_.updated_by_id AS updated_by_id_198,
b5_.ref_doc_file_id AS ref_doc_file_id_199,
b5_.ref_doc_child_file_id AS ref_doc_child_file_id_200,
b5_.commercial_file_id AS commercial_file_id_201,
b5_.fret_file_id AS fret_file_id_202,
b5_.custom_declaration_file_id AS custom_declaration_file_id_203,
b5_.packing_list_file_id AS packing_list_file_id_204,
b5_.origin_certificate_file_id AS origin_certificate_file_id_205,
b5_.special_authorisation_file_id AS special_authorisation_file_id_206,
b5_.certificat_empotage_file_id AS certificat_empotage_file_id_207,
b5_.vgm_file_id AS vgm_file_id_208,
b5_.besc_id AS besc_id_209
FROM
besc b0_
INNER JOIN user u1_ ON b0_.created_by_id = u1_.id
LEFT JOIN extra_reference e2_ ON b0_.temp_ref_id = e2_.id
LEFT JOIN redressement r3_ ON b0_.redressement_id = r3_.id
LEFT JOIN exoneration e4_ ON b0_.exoneration_id = e4_.id
LEFT JOIN besc_mask b5_ ON b0_.id = b5_.besc_id
WHERE
b0_.created_by_id IN (
SELECT
b6_.created_by_id AS sclr_210
FROM
user u7_
INNER JOIN besc b6_ ON u7_.id = b6_.created_by_id
WHERE
u7_.id = ?
)
ORDER BY
b0_.created_at DESC
LIMIT
10
SELECT b0_.id AS id_0, b0_.demande AS demande_1, b0_.number AS number_2, b0_.mode AS mode_3, b0_.sens AS sens_4, b0_.valeur AS valeur_5, b0_.valeur_finale AS valeur_finale_6, b0_.devise_valeur AS devise_valeur_7, b0_.reference_doc_number AS reference_doc_number_8, b0_.reference_doc_child_number AS reference_doc_child_number_9, b0_.shipper AS shipper_10, b0_.foreign_shipper AS foreign_shipper_11, b0_.forwarding_agent AS forwarding_agent_12, b0_.carrier AS carrier_13, b0_.country_of_origin AS country_of_origin_14, b0_.country_of_loading AS country_of_loading_15, b0_.port_of_loading AS port_of_loading_16, b0_.country_of_discharge AS country_of_discharge_17, b0_.port_of_discharge AS port_of_discharge_18, b0_.final_destination AS final_destination_19, b0_.loaded_at AS loaded_at_20, b0_.discharged_at AS discharged_at_21, b0_.eta AS eta_22, b0_.ata AS ata_23, b0_.etd AS etd_24, b0_.atd AS atd_25, b0_.incoterm AS incoterm_26, b0_.vessel AS vessel_27, b0_.voyage AS voyage_28, b0_.freight AS freight_29, b0_.freight_cur AS freight_cur_30, b0_.insurance AS insurance_31, b0_.insurance_cur AS insurance_cur_32, b0_.baf AS baf_33, b0_.baf_cur AS baf_cur_34, b0_.caf AS caf_35, b0_.caf_cur AS caf_cur_36, b0_.thc AS thc_37, b0_.thc_cur AS thc_cur_38, b0_.frais_sup AS frais_sup_39, b0_.frais_sup_cur AS frais_sup_cur_40, b0_.conditionnement AS conditionnement_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.submitted_at AS submitted_at_44, b0_.lastly_submitted_at AS lastly_submitted_at_45, b0_.verified_at AS verified_at_46, b0_.validated_at AS validated_at_47, b0_.status AS status_48, b0_.authenticated_at AS authenticated_at_49, b0_.printed_at AS printed_at_50, b0_.billed_at AS billed_at_51, b0_.paid_at AS paid_at_52, b0_.is_completed AS is_completed_53, b0_.is_locked AS is_locked_54, b0_.locked_at AS locked_at_55, b0_.is_suspended AS is_suspended_56, b0_.suspended_at AS suspended_at_57, b0_.motif_rejet AS motif_rejet_58, b0_.is_regul AS is_regul_59, b0_.pdf_data AS pdf_data_60, b0_.xml_data AS xml_data_61, b0_.classe_tarifaire AS classe_tarifaire_62, b0_.is_transit AS is_transit_63, b0_.country_of_transit AS country_of_transit_64, b0_.tarification_zone AS tarification_zone_65, b0_.integrity AS integrity_66, b0_.must_zip AS must_zip_67, b0_.is_files_converted AS is_files_converted_68, u1_.id AS id_69, u1_.company_uuid AS company_uuid_70, u1_.email AS email_71, u1_.name AS name_72, u1_.company_name AS company_name_73, u1_.roles AS roles_74, u1_.distant_id AS distant_id_75, u1_.token AS token_76, u1_.token_expired_at AS token_expired_at_77, u1_.is_consignataire_vehicule AS is_consignataire_vehicule_78, e2_.id AS id_79, e2_.ref AS ref_80, e2_.is_used AS is_used_81, e2_.created_at AS created_at_82, r3_.id AS id_83, r3_.valeur AS valeur_84, r3_.devise_valeur AS devise_valeur_85, r3_.status AS status_86, r3_.validated_at AS validated_at_87, r3_.description AS description_88, r3_.is_paid AS is_paid_89, r3_.is_main_paid AS is_main_paid_90, r3_.created_at AS created_at_91, r3_.paid_at AS paid_at_92, e4_.id AS id_93, e4_.description AS description_94, e4_.is_cancelled AS is_cancelled_95, e4_.valeur AS valeur_96, e4_.devise_valeur AS devise_valeur_97, e4_.created_at AS created_at_98, e4_.updated_at AS updated_at_99, e4_.validated_at AS validated_at_100, b5_.id AS id_101, b5_.demande AS demande_102, b5_.number AS number_103, b5_.mode AS mode_104, b5_.sens AS sens_105, b5_.valeur AS valeur_106, b5_.valeur_finale AS valeur_finale_107, b5_.devise_valeur AS devise_valeur_108, b5_.reference_doc_number AS reference_doc_number_109, b5_.reference_doc_child_number AS reference_doc_child_number_110, b5_.shipper AS shipper_111, b5_.foreign_shipper AS foreign_shipper_112, b5_.forwarding_agent AS forwarding_agent_113, b5_.carrier AS carrier_114, b5_.country_of_origin AS country_of_origin_115, b5_.country_of_loading AS country_of_loading_116, b5_.port_of_loading AS port_of_loading_117, b5_.country_of_discharge AS country_of_discharge_118, b5_.port_of_discharge AS port_of_discharge_119, b5_.final_destination AS final_destination_120, b5_.loaded_at AS loaded_at_121, b5_.discharged_at AS discharged_at_122, b5_.eta AS eta_123, b5_.ata AS ata_124, b5_.etd AS etd_125, b5_.atd AS atd_126, b5_.incoterm AS incoterm_127, b5_.vessel AS vessel_128, b5_.voyage AS voyage_129, b5_.freight AS freight_130, b5_.freight_cur AS freight_cur_131, b5_.insurance AS insurance_132, b5_.insurance_cur AS insurance_cur_133, b5_.baf AS baf_134, b5_.baf_cur AS baf_cur_135, b5_.caf AS caf_136, b5_.caf_cur AS caf_cur_137, b5_.thc AS thc_138, b5_.thc_cur AS thc_cur_139, b5_.frais_sup AS frais_sup_140, b5_.frais_sup_cur AS frais_sup_cur_141, b5_.conditionnement AS conditionnement_142, b5_.created_at AS created_at_143, b5_.updated_at AS updated_at_144, b5_.submitted_at AS submitted_at_145, b5_.lastly_submitted_at AS lastly_submitted_at_146, b5_.status AS status_147, b5_.invoice_value AS invoice_value_148, b5_.invoice_value_cur AS invoice_value_cur_149, b5_.fob_value AS fob_value_150, b5_.weight AS weight_151, b5_.volume AS volume_152, b5_.description AS description_153, b5_.number_of_vehicules AS number_of_vehicules_154, b5_.number_of_motos AS number_of_motos_155, b5_.number_of_container_fourty AS number_of_container_fourty_156, b5_.number_of_container_twenty AS number_of_container_twenty_157, b5_.number_of_pkgs AS number_of_pkgs_158, b5_.is_completed AS is_completed_159, b5_.motif_rejet AS motif_rejet_160, b5_.commercial_transactions AS commercial_transactions_161, b5_.classe_tarifaire AS classe_tarifaire_162, b5_.is_transit AS is_transit_163, b5_.country_of_transit AS country_of_transit_164, b5_.tarification_zone AS tarification_zone_165, b5_.is_initiated AS is_initiated_166, b5_.initiated_at AS initiated_at_167, b0_.created_by_id AS created_by_id_168, b0_.updated_by_id AS updated_by_id_169, b0_.submitted_by_id AS submitted_by_id_170, b0_.verified_by_id AS verified_by_id_171, b0_.validated_by_id AS validated_by_id_172, b0_.authenticated_by_id AS authenticated_by_id_173, b0_.printed_by_id AS printed_by_id_174, b0_.billed_by_id AS billed_by_id_175, b0_.paid_by_id AS paid_by_id_176, b0_.ref_doc_file_id AS ref_doc_file_id_177, b0_.ref_doc_child_file_id AS ref_doc_child_file_id_178, b0_.commercial_file_id AS commercial_file_id_179, b0_.fret_file_id AS fret_file_id_180, b0_.custom_declaration_file_id AS custom_declaration_file_id_181, b0_.packing_list_file_id AS packing_list_file_id_182, b0_.origin_certificate_file_id AS origin_certificate_file_id_183, b0_.special_authorisation_file_id AS special_authorisation_file_id_184, b0_.certificat_empotage_file_id AS certificat_empotage_file_id_185, b0_.vgm_file_id AS vgm_file_id_186, b0_.locked_by_id AS locked_by_id_187, b0_.suspended_by_id AS suspended_by_id_188, b0_.temp_ref_id AS temp_ref_id_189, b0_.redressement_id AS redressement_id_190, b0_.exoneration_id AS exoneration_id_191, e2_.user_id AS user_id_192, r3_.validated_by_id AS validated_by_id_193, e4_.exoneration_file_id AS exoneration_file_id_194, e4_.validated_by_id AS validated_by_id_195, e4_.updated_by_id AS updated_by_id_196, b5_.created_by_id AS created_by_id_197, b5_.updated_by_id AS updated_by_id_198, b5_.ref_doc_file_id AS ref_doc_file_id_199, b5_.ref_doc_child_file_id AS ref_doc_child_file_id_200, b5_.commercial_file_id AS commercial_file_id_201, b5_.fret_file_id AS fret_file_id_202, b5_.custom_declaration_file_id AS custom_declaration_file_id_203, b5_.packing_list_file_id AS packing_list_file_id_204, b5_.origin_certificate_file_id AS origin_certificate_file_id_205, b5_.special_authorisation_file_id AS special_authorisation_file_id_206, b5_.certificat_empotage_file_id AS certificat_empotage_file_id_207, b5_.vgm_file_id AS vgm_file_id_208, b5_.besc_id AS besc_id_209 FROM besc b0_ INNER JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN extra_reference e2_ ON b0_.temp_ref_id = e2_.id LEFT JOIN redressement r3_ ON b0_.redressement_id = r3_.id LEFT JOIN exoneration e4_ ON b0_.exoneration_id = e4_.id LEFT JOIN besc_mask b5_ ON b0_.id = b5_.besc_id WHERE b0_.created_by_id IN (SELECT b6_.created_by_id AS sclr_210 FROM user u7_ INNER JOIN besc b6_ ON u7_.id = b6_.created_by_id WHERE u7_.id = 0x512F56984D564640B4BEE0A3BCF2FC54) ORDER BY b0_.created_at DESC LIMIT 10;
|