select * from cotisations_commande where id = "18164" select * from cms_frontusers where identifiant = "m.blon10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18164" select * from cotisations where identifiant = "m.blon10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 000721 payment_means : MASTERCARD transmission_date : 20161212230721 payment_time : 001019 payment_date : 20161213 response_code : 00 payment_certificate : d4f6eeb5a952 authorisation_id : 746024 currency_code : 978 card_number : 5133.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.blon10 order_id : 18164 customer_email : m.blon10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18165" select * from cms_frontusers where identifiant = "f.legrand30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18165" select * from cotisations where identifiant = "f.legrand30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 060740 payment_means : VISA transmission_date : 20161213050740 payment_time : 060937 payment_date : 20161213 response_code : 00 payment_certificate : 04d1817dabf1 authorisation_id : 015813 currency_code : 978 card_number : 4970.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.legrand30 order_id : 18165 customer_email : f.legrand30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18166" select * from cms_frontusers where identifiant = "f.legrand30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18166" select * from cotisations where identifiant = "b.heim14" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "b.heim14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 061543 payment_means : VISA transmission_date : 20161213051543 payment_time : 061706 payment_date : 20161213 response_code : 00 payment_certificate : 2b725aac9d38 authorisation_id : 031526 currency_code : 978 card_number : 4970.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.legrand30 order_id : 18166 customer_email : f.legrand30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 074117 payment_means : VISA transmission_date : 20161213064117 payment_time : 074600 payment_date : 20161213 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.tatu11 order_id : 18169 customer_email : e.tatu11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18170" select * from cms_frontusers where identifiant = "jc.bellanger31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18170" select * from cotisations where identifiant = "jc.bellanger31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082106 payment_means : MASTERCARD transmission_date : 20161213072106 payment_time : 082258 payment_date : 20161213 response_code : 00 payment_certificate : 76440320c82e authorisation_id : 254746 currency_code : 978 card_number : 5131.45 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.bellanger31 order_id : 18170 customer_email : jc.bellanger31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18172" select * from cms_frontusers where identifiant = "d.gugole10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18172" select * from cotisations where identifiant = "d.gugole10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085530 payment_means : VISA transmission_date : 20161213075530 payment_time : 085747 payment_date : 20161213 response_code : 00 payment_certificate : 441418273706 authorisation_id : 933321 currency_code : 978 card_number : 4970.58 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.gugole10 order_id : 18172 customer_email : d.gugole10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18173" select * from cms_frontusers where identifiant = "c.quarena21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18173" select * from cotisations where identifiant = "c.quarena21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090705 payment_means : VISA transmission_date : 20161213080705 payment_time : 091102 payment_date : 20161213 response_code : 00 payment_certificate : 38f9c2961027 authorisation_id : 261601 currency_code : 978 card_number : 4533.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.quarena21 order_id : 18173 customer_email : c.quarena21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18174" select * from cms_frontusers where identifiant = "g.bonnin28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18174" select * from cotisations where identifiant = "g.bonnin28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091626 payment_means : VISA transmission_date : 20161213081626 payment_time : 091917 payment_date : 20161213 response_code : 00 payment_certificate : db53d8c9fdd4 authorisation_id : 641592 currency_code : 978 card_number : 4975.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.bonnin28 order_id : 18174 customer_email : g.bonnin28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18177" select * from cms_frontusers where identifiant = "k.nonet19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18177" select * from cotisations where identifiant = "k.nonet19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094542 payment_means : VISA transmission_date : 20161213084542 payment_time : 094959 payment_date : 20161213 response_code : 00 payment_certificate : ed2d9e1acc6b authorisation_id : 421381 currency_code : 978 card_number : 4970.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.nonet19 order_id : 18177 customer_email : k.nonet19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18178" select * from cms_frontusers where identifiant = "t.tranchard03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18178" select * from cotisations where identifiant = "t.tranchard03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102602 payment_means : VISA transmission_date : 20161213092602 payment_time : 102727 payment_date : 20161213 response_code : 00 payment_certificate : 53a556a29d8d authorisation_id : 636368 currency_code : 978 card_number : 4975.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.tranchard03 order_id : 18178 customer_email : t.tranchard03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18181" select * from cms_frontusers where identifiant = "t.tranchard03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18181" select * from cotisations where identifiant = "v.macquet24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103226 payment_means : VISA transmission_date : 20161213093226 payment_time : 103352 payment_date : 20161213 response_code : 00 payment_certificate : c3d0ac2ae574 authorisation_id : 612136 currency_code : 978 card_number : 4975.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.tranchard03 order_id : 18181 customer_email : t.tranchard03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18182" select * from cms_frontusers where identifiant = "t.tranchard03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18182" select * from cotisations where identifiant = "a.peuch02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103505 payment_means : VISA transmission_date : 20161213093505 payment_time : 103608 payment_date : 20161213 response_code : 00 payment_certificate : d7185b99a193 authorisation_id : 464641 currency_code : 978 card_number : 4975.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.tranchard03 order_id : 18182 customer_email : t.tranchard03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18184" select * from cms_frontusers where identifiant = "j.baudoin07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18184" select * from cotisations where identifiant = "j.baudoin07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105031 payment_means : MASTERCARD transmission_date : 20161213095031 payment_time : 105129 payment_date : 20161213 response_code : 00 payment_certificate : 9e8a509162a6 authorisation_id : 133682 currency_code : 978 card_number : 5132.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.baudoin07 order_id : 18184 customer_email : j.baudoin07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18185" select * from cms_frontusers where identifiant = "t.tranchard03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18185" select * from cotisations where identifiant = "g.maugey20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105046 payment_means : VISA transmission_date : 20161213095046 payment_time : 105140 payment_date : 20161213 response_code : 00 payment_certificate : f9d84a7b192a authorisation_id : 442546 currency_code : 978 card_number : 4975.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.tranchard03 order_id : 18185 customer_email : t.tranchard03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18186" select * from cms_frontusers where identifiant = "jp.brehier14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18186" select * from cotisations where identifiant = "jp.brehier14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110238 payment_means : VISA transmission_date : 20161213100238 payment_time : 110426 payment_date : 20161213 response_code : 00 payment_certificate : 6b7d77838ec1 authorisation_id : 932551 currency_code : 978 card_number : 4972.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.brehier14 order_id : 18186 customer_email : jp.brehier14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18187" select * from cms_frontusers where identifiant = "e.buffard15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18187" select * from cotisations where identifiant = "e.buffard15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111106 payment_means : VISA transmission_date : 20161213101106 payment_time : 111251 payment_date : 20161213 response_code : 00 payment_certificate : d8359883530e authorisation_id : 165714 currency_code : 978 card_number : 4973.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.buffard15 order_id : 18187 customer_email : e.buffard15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18189" select * from cms_frontusers where identifiant = "r.magne02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18189" select * from cotisations where identifiant = "r.magne02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 112107 payment_means : MASTERCARD transmission_date : 20161213102107 payment_time : 112534 payment_date : 20161213 response_code : 00 payment_certificate : 05e5b902b100 authorisation_id : 393653 currency_code : 978 card_number : 5138.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.magne02 order_id : 18189 customer_email : r.magne02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18190" select * from cms_frontusers where identifiant = "a.mainguene09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18190" select * from cotisations where identifiant = "a.mainguene09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112450 payment_means : VISA transmission_date : 20161213102450 payment_time : 112707 payment_date : 20161213 response_code : 00 payment_certificate : 6592758041e7 authorisation_id : 649338 currency_code : 978 card_number : 4974.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.mainguene09 order_id : 18190 customer_email : a.mainguene09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18188" select * from cms_frontusers where identifiant = "a.gleizes05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18188" select * from cotisations where identifiant = "a.gleizes05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112011 payment_means : MASTERCARD transmission_date : 20161213102011 payment_time : 112744 payment_date : 20161213 response_code : 00 payment_certificate : 85e2d60e4097 authorisation_id : 881471 currency_code : 978 card_number : 5131.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gleizes05 order_id : 18188 customer_email : a.gleizes05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18191" select * from cms_frontusers where identifiant = "n.reynes27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18191" select * from cotisations where identifiant = "n.reynes27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112741 payment_means : MASTERCARD transmission_date : 20161213102741 payment_time : 112938 payment_date : 20161213 response_code : 00 payment_certificate : 51c68441da24 authorisation_id : 940126 currency_code : 978 card_number : 5137.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.reynes27 order_id : 18191 customer_email : n.reynes27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18193" select * from cms_frontusers where identifiant = "g.sourisseau26" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18193" select * from cotisations where identifiant = "l.milesi02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 114455 payment_means : MASTERCARD transmission_date : 20161213104455 payment_time : 114827 payment_date : 20161213 response_code : 00 payment_certificate : f334569336d9 authorisation_id : 109213 currency_code : 978 card_number : 5137.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.sourisseau26 order_id : 18193 customer_email : g.sourisseau26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18194" select * from cms_frontusers where identifiant = "h.dubreucq19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18194" select * from cotisations where identifiant = "h.dubreucq19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122640 payment_means : VISA transmission_date : 20161213112640 payment_time : 122839 payment_date : 20161213 response_code : 00 payment_certificate : d7a3986c9566 authorisation_id : 350657 currency_code : 978 card_number : 4976.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.dubreucq19 order_id : 18194 customer_email : h.dubreucq19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124616 payment_means : MASTERCARD transmission_date : 20161213114616 payment_time : 125046 payment_date : 20161213 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5365.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.colin03 order_id : 18195 customer_email : q.colin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18196" select * from cms_frontusers where identifiant = "q.colin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18196" select * from cotisations where identifiant = "s.delaruyelle17" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "s.delaruyelle17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 125452 payment_means : VISA transmission_date : 20161213115452 payment_time : 125726 payment_date : 20161213 response_code : 00 payment_certificate : c2f0fac73fb2 authorisation_id : 228202 currency_code : 978 card_number : 4975.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.colin03 order_id : 18196 customer_email : q.colin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18197" select * from cms_frontusers where identifiant = "y.cordet09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18197" select * from cotisations where identifiant = "y.cordet09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125704 payment_means : MASTERCARD transmission_date : 20161213115704 payment_time : 125842 payment_date : 20161213 response_code : 00 payment_certificate : 909352954934 authorisation_id : 494691 currency_code : 978 card_number : 5132.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.cordet09 order_id : 18197 customer_email : y.cordet09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18198" select * from cms_frontusers where identifiant = "q.colin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18198" select * from cotisations where identifiant = "q.colin03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125839 payment_means : VISA transmission_date : 20161213115839 payment_time : 130041 payment_date : 20161213 response_code : 00 payment_certificate : edf0f4f4c58c authorisation_id : 642061 currency_code : 978 card_number : 4974.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.colin03 order_id : 18198 customer_email : q.colin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18199" select * from cms_frontusers where identifiant = "s.auder24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18199" select * from cotisations where identifiant = "s.auder24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125926 payment_means : MASTERCARD transmission_date : 20161213115926 payment_time : 130305 payment_date : 20161213 response_code : 00 payment_certificate : fd33d156a009 authorisation_id : 805379 currency_code : 978 card_number : 5137.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.auder24 order_id : 18199 customer_email : s.auder24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18200" select * from cms_frontusers where identifiant = "m.cavory10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18200" select * from cotisations where identifiant = "m.cavory10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130650 payment_means : MASTERCARD transmission_date : 20161213120650 payment_time : 130839 payment_date : 20161213 response_code : 00 payment_certificate : 060ab5605dd4 authorisation_id : 015212 currency_code : 978 card_number : 5133.32 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.cavory10 order_id : 18200 customer_email : m.cavory10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18201" select * from cms_frontusers where identifiant = "m.rolland27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18201" select * from cotisations where identifiant = "m.rolland27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 132541 payment_means : VISA transmission_date : 20161213122541 payment_time : 132733 payment_date : 20161213 response_code : 00 payment_certificate : 4c3ba6efdbe7 authorisation_id : 166282 currency_code : 978 card_number : 4974.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.rolland27 order_id : 18201 customer_email : m.rolland27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18202" select * from cms_frontusers where identifiant = "q.colin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18202" select * from cotisations where identifiant = "p.padey07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132914 payment_means : MASTERCARD transmission_date : 20161213122914 payment_time : 133205 payment_date : 20161213 response_code : 00 payment_certificate : 96c03130be3a authorisation_id : 440251 currency_code : 978 card_number : 5365.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.colin03 order_id : 18202 customer_email : q.colin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18203" select * from cms_frontusers where identifiant = "j.olivier23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18203" select * from cotisations where identifiant = "j.olivier23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133719 payment_means : VISA transmission_date : 20161213123719 payment_time : 133937 payment_date : 20161213 response_code : 00 payment_certificate : 452e7773481a authorisation_id : 337652 currency_code : 978 card_number : 4972.32 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.olivier23 order_id : 18203 customer_email : j.olivier23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18204" select * from cms_frontusers where identifiant = "s.charrier21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18204" select * from cotisations where identifiant = "s.charrier21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143003 payment_means : MASTERCARD transmission_date : 20161213133003 payment_time : 143138 payment_date : 20161213 response_code : 00 payment_certificate : bdc5dc190bb3 authorisation_id : 024272 currency_code : 978 card_number : 5131.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.charrier21 order_id : 18204 customer_email : s.charrier21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18211" select * from cms_frontusers where identifiant = "p.paranthoine25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18211" select * from cotisations where identifiant = "p.paranthoine25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153553 payment_means : VISA transmission_date : 20161213143553 payment_time : 153946 payment_date : 20161213 response_code : 00 payment_certificate : 6b156effb459 authorisation_id : 216374 currency_code : 978 card_number : 4970.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.paranthoine25 order_id : 18211 customer_email : p.paranthoine25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18212" select * from cms_frontusers where identifiant = "s.peres14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18212" select * from cotisations where identifiant = "s.peres14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 153927 payment_means : VISA transmission_date : 20161213143927 payment_time : 154045 payment_date : 20161213 response_code : 00 payment_certificate : 8a4d8745a47d authorisation_id : 911601 currency_code : 978 card_number : 4974.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.peres14 order_id : 18212 customer_email : s.peres14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18213" select * from cms_frontusers where identifiant = "a.moreau06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18213" select * from cotisations where identifiant = "a.moreau06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154447 payment_means : VISA transmission_date : 20161213144447 payment_time : 154620 payment_date : 20161213 response_code : 00 payment_certificate : 6350f00d7559 authorisation_id : 922456 currency_code : 978 card_number : 4978.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.moreau06 order_id : 18213 customer_email : a.moreau06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18214" select * from cms_frontusers where identifiant = "j.perras06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18214" select * from cotisations where identifiant = "j.perras06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160141 payment_means : VISA transmission_date : 20161213150141 payment_time : 160302 payment_date : 20161213 response_code : 00 payment_certificate : 612bd88084d5 authorisation_id : 704331 currency_code : 978 card_number : 4975.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.perras06 order_id : 18214 customer_email : j.perras06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18215" select * from cms_frontusers where identifiant = "q.rousseau19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18215" select * from cotisations where identifiant = "q.rousseau19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161545 payment_means : MASTERCARD transmission_date : 20161213151545 payment_time : 162419 payment_date : 20161213 response_code : 00 payment_certificate : 428513759b3c authorisation_id : 261411 currency_code : 978 card_number : 5131.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.rousseau19 order_id : 18215 customer_email : q.rousseau19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18218" select * from cms_frontusers where identifiant = "q.petitjean23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18218" select * from cotisations where identifiant = "e.deforge25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171037 payment_means : VISA transmission_date : 20161213161037 payment_time : 171152 payment_date : 20161213 response_code : 00 payment_certificate : 4aeb9e2cfc10 authorisation_id : 873991 currency_code : 978 card_number : 4970.75 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.petitjean23 order_id : 18218 customer_email : q.petitjean23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18219" select * from cms_frontusers where identifiant = "a.chiffaudel16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18219" select * from cotisations where identifiant = "a.chiffaudel16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 171938 payment_means : VISA transmission_date : 20161213161938 payment_time : 172109 payment_date : 20161213 response_code : 00 payment_certificate : 296114bfc456 authorisation_id : 748254 currency_code : 978 card_number : 4970.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.chiffaudel16 order_id : 18219 customer_email : a.chiffaudel16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181510 payment_means : VISA transmission_date : 20161213171510 payment_time : 182348 payment_date : 20161213 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.roussel24 order_id : 18220 customer_email : j.roussel24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18220" select * from cms_frontusers where identifiant = "j.roussel24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18220" select * from cotisations where identifiant = "j.roussel24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182401 payment_means : VISA transmission_date : 20161213172401 payment_time : 182907 payment_date : 20161213 response_code : 00 payment_certificate : a88f27f9c846 authorisation_id : 353676 currency_code : 978 card_number : 4972.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.roussel24 order_id : 18220 customer_email : j.roussel24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18221" select * from cms_frontusers where identifiant = "fr.daubinet26" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18221" select * from cotisations where identifiant = "fr.daubinet26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183519 payment_means : VISA transmission_date : 20161213173519 payment_time : 183710 payment_date : 20161213 response_code : 00 payment_certificate : af7b5035d49f authorisation_id : 432586 currency_code : 978 card_number : 4561.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : fr.daubinet26 order_id : 18221 customer_email : fr.daubinet26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18222" select * from cms_frontusers where identifiant = "g.saramon06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18222" select * from cotisations where identifiant = "g.saramon06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185323 payment_means : MASTERCARD transmission_date : 20161213175323 payment_time : 185612 payment_date : 20161213 response_code : 00 payment_certificate : 58682909513b authorisation_id : 645342 currency_code : 978 card_number : 5131.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.saramon06 order_id : 18222 customer_email : g.saramon06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18223" select * from cms_frontusers where identifiant = "p.genevrier27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18223" select * from cotisations where identifiant = "p.genevrier27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185828 payment_means : MASTERCARD transmission_date : 20161213175828 payment_time : 190044 payment_date : 20161213 response_code : 00 payment_certificate : d807121cfdd9 authorisation_id : 713214 currency_code : 978 card_number : 5132.91 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.genevrier27 order_id : 18223 customer_email : p.genevrier27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18224" select * from cms_frontusers where identifiant = "m.couderc20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18224" select * from cotisations where identifiant = "m.couderc20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191327 payment_means : VISA transmission_date : 20161213181327 payment_time : 191459 payment_date : 20161213 response_code : 00 payment_certificate : d23b72d27c5b authorisation_id : 452365 currency_code : 978 card_number : 4533.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.couderc20 order_id : 18224 customer_email : m.couderc20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18225" select * from cms_frontusers where identifiant = "m.spieser25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18225" select * from cotisations where identifiant = "m.spieser25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191919 payment_means : VISA transmission_date : 20161213181919 payment_time : 192042 payment_date : 20161213 response_code : 00 payment_certificate : e9e9f05b62d8 authorisation_id : 119041 currency_code : 978 card_number : 4970.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.spieser25 order_id : 18225 customer_email : m.spieser25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18226" select * from cms_frontusers where identifiant = "d.plasse19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18226" select * from cotisations where identifiant = "d.plasse19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194949 payment_means : MASTERCARD transmission_date : 20161213184949 payment_time : 195036 payment_date : 20161213 response_code : 00 payment_certificate : b58e338be446 authorisation_id : 535414 currency_code : 978 card_number : 5132.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.plasse19 order_id : 18226 customer_email : d.plasse19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18227" select * from cms_frontusers where identifiant = "v.valera30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18227" select * from cotisations where identifiant = "v.valera30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195115 payment_means : VISA transmission_date : 20161213185115 payment_time : 195424 payment_date : 20161213 response_code : 00 payment_certificate : 214e69180442 authorisation_id : 243284 currency_code : 978 card_number : 4975.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.valera30 order_id : 18227 customer_email : v.valera30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18228" select * from cms_frontusers where identifiant = "h1.martin12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18228" select * from cotisations where identifiant = "h1.martin12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200046 payment_means : VISA transmission_date : 20161213190046 payment_time : 200227 payment_date : 20161213 response_code : 00 payment_certificate : fdddf067202d authorisation_id : 884926 currency_code : 978 card_number : 4978.00 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h1.martin12 order_id : 18228 customer_email : h1.martin12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18230" select * from cms_frontusers where identifiant = "r.planes24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18230" select * from cotisations where identifiant = "r.planes24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201331 payment_means : MASTERCARD transmission_date : 20161213191331 payment_time : 201502 payment_date : 20161213 response_code : 00 payment_certificate : 75a8cd3fd68e authorisation_id : 952641 currency_code : 978 card_number : 5131.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.planes24 order_id : 18230 customer_email : r.planes24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18229" select * from cms_frontusers where identifiant = "p.lebeller31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18229" select * from cotisations where identifiant = "p.lebeller31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201207 payment_means : MASTERCARD transmission_date : 20161213191207 payment_time : 201504 payment_date : 20161213 response_code : 00 payment_certificate : 8d5b595043ff authorisation_id : 824653 currency_code : 978 card_number : 5136.35 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lebeller31 order_id : 18229 customer_email : p.lebeller31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18233" select * from cms_frontusers where identifiant = "m.puyal28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18233" select * from cotisations where identifiant = "m.puyal28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202711 payment_means : VISA transmission_date : 20161213192711 payment_time : 202827 payment_date : 20161213 response_code : 00 payment_certificate : 1fa0556f0c11 authorisation_id : 282230 currency_code : 978 card_number : 4975.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.puyal28 order_id : 18233 customer_email : m.puyal28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18234" select * from cms_frontusers where identifiant = "j.fournier23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18234" select * from cotisations where identifiant = "j.fournier23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202752 payment_means : MASTERCARD transmission_date : 20161213192752 payment_time : 203048 payment_date : 20161213 response_code : 00 payment_certificate : 5a126fdb1295 authorisation_id : 519636 currency_code : 978 card_number : 5341.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.fournier23 order_id : 18234 customer_email : j.fournier23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18235" select * from cms_frontusers where identifiant = "j.minard20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18235" select * from cotisations where identifiant = "j.minard20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202921 payment_means : MASTERCARD transmission_date : 20161213192921 payment_time : 203213 payment_date : 20161213 response_code : 00 payment_certificate : 5a9f97628333 authorisation_id : 114237 currency_code : 978 card_number : 5131.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.minard20 order_id : 18235 customer_email : j.minard20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18237" select * from cms_frontusers where identifiant = "n.pezot25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18237" select * from cotisations where identifiant = "n.pezot25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203145 payment_means : MASTERCARD transmission_date : 20161213193145 payment_time : 203456 payment_date : 20161213 response_code : 00 payment_certificate : dfca6a5d1ffc authorisation_id : 340250 currency_code : 978 card_number : 5132.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.pezot25 order_id : 18237 customer_email : n.pezot25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18236" select * from cms_frontusers where identifiant = "t.dupin30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18236" select * from cotisations where identifiant = "t.dupin30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203118 payment_means : VISA transmission_date : 20161213193118 payment_time : 203524 payment_date : 20161213 response_code : 00 payment_certificate : 223e6d8db121 authorisation_id : 317302 currency_code : 978 card_number : 4978.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.dupin30 order_id : 18236 customer_email : t.dupin30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18238" select * from cms_frontusers where identifiant = "a.cueff09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18238" select * from cotisations where identifiant = "a.cueff09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203500 payment_means : MASTERCARD transmission_date : 20161213193500 payment_time : 203830 payment_date : 20161213 response_code : 00 payment_certificate : 535858c7e93a authorisation_id : 956330 currency_code : 978 card_number : 5135.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.cueff09 order_id : 18238 customer_email : a.cueff09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18239" select * from cms_frontusers where identifiant = "v.libert22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18239" select * from cotisations where identifiant = "v.libert22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204801 payment_means : VISA transmission_date : 20161213194801 payment_time : 205122 payment_date : 20161213 response_code : 00 payment_certificate : 2b5b28f977d0 authorisation_id : 093362 currency_code : 978 card_number : 4973.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.libert22 order_id : 18239 customer_email : v.libert22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18240" select * from cms_frontusers where identifiant = "n.vicat10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18240" select * from cotisations where identifiant = "n.vicat10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204918 payment_means : MASTERCARD transmission_date : 20161213194918 payment_time : 205221 payment_date : 20161213 response_code : 00 payment_certificate : 6b1cc78e92fa authorisation_id : 184678 currency_code : 978 card_number : 5137.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.vicat10 order_id : 18240 customer_email : n.vicat10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18241" select * from cms_frontusers where identifiant = "f.rivalan24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18241" select * from cotisations where identifiant = "f.rivalan24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205109 payment_means : VISA transmission_date : 20161213195109 payment_time : 205234 payment_date : 20161213 response_code : 00 payment_certificate : fd6565418488 authorisation_id : 228109 currency_code : 978 card_number : 4970.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.rivalan24 order_id : 18241 customer_email : f.rivalan24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18242" select * from cms_frontusers where identifiant = "m.panattoni12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18242" select * from cotisations where identifiant = "m.panattoni12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210115 payment_means : VISA transmission_date : 20161213200115 payment_time : 210257 payment_date : 20161213 response_code : 00 payment_certificate : 2cbe52195342 authorisation_id : 562414 currency_code : 978 card_number : 4977.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.panattoni12 order_id : 18242 customer_email : m.panattoni12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18231" select * from cms_frontusers where identifiant = "a.duboy31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18231" select * from cotisations where identifiant = "a.duboy31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201438 payment_means : VISA transmission_date : 20161213191438 payment_time : 211601 payment_date : 20161213 response_code : 00 payment_certificate : bd253f1b6be5 authorisation_id : 316641 currency_code : 978 card_number : 4974.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.duboy31 order_id : 18231 customer_email : a.duboy31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18244" select * from cms_frontusers where identifiant = "b.visse10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18244" select * from cotisations where identifiant = "b.visse10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211806 payment_means : MASTERCARD transmission_date : 20161213201806 payment_time : 212021 payment_date : 20161213 response_code : 00 payment_certificate : 8800d26b3df3 authorisation_id : 224019 currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.visse10 order_id : 18244 customer_email : b.visse10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18243" select * from cms_frontusers where identifiant = "t.dervin23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18243" select * from cotisations where identifiant = "t.dervin23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211743 payment_means : MASTERCARD transmission_date : 20161213201743 payment_time : 212258 payment_date : 20161213 response_code : 00 payment_certificate : 4c56a51dbaf0 authorisation_id : 366229 currency_code : 978 card_number : 5131.74 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.dervin23 order_id : 18243 customer_email : t.dervin23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212150 payment_means : MASTERCARD transmission_date : 20161213202150 payment_time : 212322 payment_date : 20161213 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.visse10 order_id : 18245 customer_email : b.visse10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18246" select * from cms_frontusers where identifiant = "m.lapalus21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18246" select * from cotisations where identifiant = "m.lapalus21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213206 payment_means : MASTERCARD transmission_date : 20161213203206 payment_time : 213401 payment_date : 20161213 response_code : 00 payment_certificate : d2327c8ea32d authorisation_id : 861150 currency_code : 978 card_number : 5131.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.lapalus21 order_id : 18246 customer_email : m.lapalus21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18247" select * from cms_frontusers where identifiant = "n.lebec10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18247" select * from cotisations where identifiant = "n.lebec10" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "18248" select * from cms_frontusers where identifiant = "d.helbringer10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18248" select * from cotisations where identifiant = "d.helbringer10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213701 payment_means : MASTERCARD transmission_date : 20161213203701 payment_time : 213820 payment_date : 20161213 response_code : 00 payment_certificate : 5dcf185e2ebd authorisation_id : 780569 currency_code : 978 card_number : 5136.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.lebec10 order_id : 18247 customer_email : n.lebec10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213648 payment_means : MASTERCARD transmission_date : 20161213203648 payment_time : 213841 payment_date : 20161213 response_code : 00 payment_certificate : bac648d9d4ad authorisation_id : 761549 currency_code : 978 card_number : 5130.32 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.helbringer10 order_id : 18248 customer_email : d.helbringer10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18249" select * from cms_frontusers where identifiant = "m.couavoux10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18249" select * from cotisations where identifiant = "m.couavoux10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214340 payment_means : VISA transmission_date : 20161213204340 payment_time : 214518 payment_date : 20161213 response_code : 00 payment_certificate : a21124b58353 authorisation_id : 319635 currency_code : 978 card_number : 4533.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.couavoux10 order_id : 18249 customer_email : m.couavoux10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214708 payment_means : MASTERCARD transmission_date : 20161213204708 payment_time : 214904 payment_date : 20161213 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.moser31 order_id : 18250 customer_email : c.moser31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18251" select * from cms_frontusers where identifiant = "b.bonnans31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18251" select * from cotisations where identifiant = "m.chaillou29" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "b.bonnans31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 220312 payment_means : MASTERCARD transmission_date : 20161213210312 payment_time : 220505 payment_date : 20161213 response_code : 00 payment_certificate : a9eac955625d authorisation_id : 589447 currency_code : 978 card_number : 5131.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.bonnans31 order_id : 18251 customer_email : b.bonnans31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18254" select * from cms_frontusers where identifiant = "m.phelpinruffie24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18254" select * from cotisations where identifiant = "m.phelpinruffie24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222110 payment_means : VISA transmission_date : 20161213212110 payment_time : 222309 payment_date : 20161213 response_code : 00 payment_certificate : 3b48cdc9cf47 authorisation_id : 512584 currency_code : 978 card_number : 4978.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.phelpinruffie24 order_id : 18254 customer_email : m.phelpinruffie24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18253" select * from cms_frontusers where identifiant = "p.vaillard10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18253" select * from cotisations where identifiant = "p.vaillard10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222106 payment_means : MASTERCARD transmission_date : 20161213212106 payment_time : 222419 payment_date : 20161213 response_code : 00 payment_certificate : dc095b83ed52 authorisation_id : 938612 currency_code : 978 card_number : 5131.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.vaillard10 order_id : 18253 customer_email : p.vaillard10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18255" select * from cms_frontusers where identifiant = "t.ramonet22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18255" select * from cotisations where identifiant = "t.ramonet22" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.ramonet22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223137 payment_means : MASTERCARD transmission_date : 20161213213137 payment_time : 223342 payment_date : 20161213 response_code : 00 payment_certificate : 50413e86ba00 authorisation_id : 440321 currency_code : 978 card_number : 5131.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.ramonet22 order_id : 18255 customer_email : t.ramonet22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18256" select * from cms_frontusers where identifiant = "r.goffinet10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18256" select * from cotisations where identifiant = "r.goffinet10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224903 payment_means : MASTERCARD transmission_date : 20161213214903 payment_time : 225027 payment_date : 20161213 response_code : 00 payment_certificate : bd8c9a2629c9 authorisation_id : 445151 currency_code : 978 card_number : 5132.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.goffinet10 order_id : 18256 customer_email : r.goffinet10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18259" select * from cms_frontusers where identifiant = "v.bordais16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18259" select * from cotisations where identifiant = "v.bordais16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 231948 payment_means : MASTERCARD transmission_date : 20161213221948 payment_time : 232158 payment_date : 20161213 response_code : 00 payment_certificate : 5e8112cc3f9b authorisation_id : 592986 currency_code : 978 card_number : 5132.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.bordais16 order_id : 18259 customer_email : v.bordais16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------