select * from cotisations_commande where id = "16184" select * from cms_frontusers where identifiant = "a.douet22" 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 = "16184" select * from cotisations where identifiant = "a.douet22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 002338 payment_means : MASTERCARD transmission_date : 20161117232338 payment_time : 002445 payment_date : 20161118 response_code : 00 payment_certificate : 63d9846c31ec authorisation_id : 553120 currency_code : 978 card_number : 5131.71 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.douet22 order_id : 16184 customer_email : a.douet22@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16187" select * from cms_frontusers where identifiant = "s.houdeau05" 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 = "16187" select * from cotisations where identifiant = "s.houdeau05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082217 payment_means : VISA transmission_date : 20161118072217 payment_time : 082516 payment_date : 20161118 response_code : 00 payment_certificate : 4d54c077ccdb authorisation_id : 454315 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 : s.houdeau05 order_id : 16187 customer_email : s.houdeau05@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 = "16188" select * from cms_frontusers where identifiant = "p.henriot16" 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 = "16188" select * from cotisations where identifiant = "p.henriot16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085147 payment_means : VISA transmission_date : 20161118075147 payment_time : 085421 payment_date : 20161118 response_code : 00 payment_certificate : b734da65edbd authorisation_id : 259964 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 : p.henriot16 order_id : 16188 customer_email : p.henriot16@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 = "16189" select * from cms_frontusers where identifiant = "p1.esteban28" 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 = "16189" select * from cotisations where identifiant = "p1.esteban28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091237 payment_means : MASTERCARD transmission_date : 20161118081237 payment_time : 091424 payment_date : 20161118 response_code : 00 payment_certificate : cd7021318f00 authorisation_id : 124413 currency_code : 978 card_number : 5137.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 : p1.esteban28 order_id : 16189 customer_email : p1.esteban28@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 = "16190" select * from cms_frontusers where identifiant = "f.warolus29" 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 = "16190" select * from cotisations where identifiant = "f.warolus29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091656 payment_means : VISA transmission_date : 20161118081656 payment_time : 091930 payment_date : 20161118 response_code : 00 payment_certificate : 02c194506ecf authorisation_id : 282124 currency_code : 978 card_number : 4974.15 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.warolus29 order_id : 16190 customer_email : f.warolus29@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103205 payment_means : VISA transmission_date : 20161118093205 payment_time : 104200 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4561.49 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 : s.angel05 order_id : 16193 customer_email : s.angel05@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16194" select * from cms_frontusers where identifiant = "sm.lu03" 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 = "16194" select * from cotisations where identifiant = "sm.lu03" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "sm.lu23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 111800 payment_means : VISA transmission_date : 20161118101800 payment_time : 112008 payment_date : 20161118 response_code : 00 payment_certificate : 867e83fe587c authorisation_id : 825365 currency_code : 978 card_number : 4978.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 : sm.lu03 order_id : 16194 customer_email : sm.lu03@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 = "16196" select * from cms_frontusers where identifiant = "g.agar01" 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 = "16196" select * from cotisations where identifiant = "g.agar01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114740 payment_means : VISA transmission_date : 20161118104740 payment_time : 115104 payment_date : 20161118 response_code : 00 payment_certificate : 92dfe381c1c8 authorisation_id : 041342 currency_code : 978 card_number : 4978.01 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.agar01 order_id : 16196 customer_email : g.agar01@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16197" select * from cms_frontusers where identifiant = "e.fuchs25" 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 = "16197" select * from cotisations where identifiant = "e.fuchs25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115708 payment_means : MASTERCARD transmission_date : 20161118105708 payment_time : 115853 payment_date : 20161118 response_code : 00 payment_certificate : ca4be8c47199 authorisation_id : 324303 currency_code : 978 card_number : 5132.16 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.fuchs25 order_id : 16197 customer_email : e.fuchs25@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 = "16199" select * from cms_frontusers where identifiant = "v.deroulede05" 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 = "16199" select * from cotisations where identifiant = "v.deroulede05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133213 payment_means : MASTERCARD transmission_date : 20161118123213 payment_time : 133406 payment_date : 20161118 response_code : 00 payment_certificate : 005dcb560e2e authorisation_id : 595698 currency_code : 978 card_number : 5131.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 : v.deroulede05 order_id : 16199 customer_email : v.deroulede05@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 = "16200" select * from cms_frontusers where identifiant = "w.culie15" 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 = "16200" select * from cotisations where identifiant = "w.culie15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135338 payment_means : VISA transmission_date : 20161118125338 payment_time : 135642 payment_date : 20161118 response_code : 00 payment_certificate : a996201ed7ac authorisation_id : 113195 currency_code : 978 card_number : 4975.31 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 : w.culie15 order_id : 16200 customer_email : w.culie15@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 : 135540 payment_means : VISA transmission_date : 20161118125540 payment_time : 135655 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.06 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 : d.legall21 order_id : 16201 customer_email : d.legall21@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16202" select * from cms_frontusers where identifiant = "a.loucheux25" 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 = "16202" select * from cotisations where identifiant = "a.loucheux25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135902 payment_means : MASTERCARD transmission_date : 20161118125902 payment_time : 140142 payment_date : 20161118 response_code : 00 payment_certificate : cf86caaffb93 authorisation_id : 604774 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 : a.loucheux25 order_id : 16202 customer_email : a.loucheux25@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 = "16203" select * from cms_frontusers where identifiant = "k.vergez20" 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 = "16203" select * from cotisations where identifiant = "k.vergez20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141654 payment_means : VISA transmission_date : 20161118131654 payment_time : 141852 payment_date : 20161118 response_code : 00 payment_certificate : e1323c7a653f authorisation_id : 617562 currency_code : 978 card_number : 4533.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.vergez20 order_id : 16203 customer_email : k.vergez20@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 = "16204" select * from cms_frontusers where identifiant = "a.cahu12" 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 = "16204" select * from cotisations where identifiant = "a.cahu12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142029 payment_means : VISA transmission_date : 20161118132029 payment_time : 142138 payment_date : 20161118 response_code : 00 payment_certificate : 6b86d261f7f8 authorisation_id : 329833 currency_code : 978 card_number : 4974.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 : a.cahu12 order_id : 16204 customer_email : a.cahu12@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 = "16205" select * from cms_frontusers where identifiant = "m.chemiere19" 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 = "16205" select * from cotisations where identifiant = "m.chemiere19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 142344 payment_means : VISA transmission_date : 20161118132344 payment_time : 142521 payment_date : 20161118 response_code : 00 payment_certificate : ae1ba04c6325 authorisation_id : 527416 currency_code : 978 card_number : 4978.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 : m.chemiere19 order_id : 16205 customer_email : m.chemiere19@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16206" select * from cms_frontusers where identifiant = "t.depoisson19" 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 = "16206" select * from cotisations where identifiant = "t.depoisson19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143825 payment_means : MASTERCARD transmission_date : 20161118133825 payment_time : 144144 payment_date : 20161118 response_code : 00 payment_certificate : 7eb75834e2c3 authorisation_id : 131145 currency_code : 978 card_number : 5131.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 : t.depoisson19 order_id : 16206 customer_email : t.depoisson19@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 = "16209" select * from cms_frontusers where identifiant = "p.joly10" 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 = "16209" select * from cotisations where identifiant = "p.joly10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151540 payment_means : MASTERCARD transmission_date : 20161118141540 payment_time : 151715 payment_date : 20161118 response_code : 00 payment_certificate : e263b96bf3e3 authorisation_id : 839959 currency_code : 978 card_number : 5136.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.joly10 order_id : 16209 customer_email : p.joly10@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 = "16212" select * from cms_frontusers where identifiant = "jp.conraud03" 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 = "16212" select * from cotisations where identifiant = "jp.conraud03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152148 payment_means : VISA transmission_date : 20161118142148 payment_time : 152625 payment_date : 20161118 response_code : 00 payment_certificate : 66e09aa30793 authorisation_id : 424355 currency_code : 978 card_number : 4976.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 : jp.conraud03 order_id : 16212 customer_email : jp.conraud03@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 = "16213" select * from cms_frontusers where identifiant = "g.gelin20" 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 = "16213" select * from cotisations where identifiant = "g.gelin20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155613 payment_means : MASTERCARD transmission_date : 20161118145613 payment_time : 155720 payment_date : 20161118 response_code : 00 payment_certificate : 932296f2d36a authorisation_id : 022327 currency_code : 978 card_number : 5131.76 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.gelin20 order_id : 16213 customer_email : g.gelin20@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 = "16215" select * from cms_frontusers where identifiant = "s.espinosa13" 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 = "16215" select * from cotisations where identifiant = "s.espinosa13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 155909 payment_means : VISA transmission_date : 20161118145909 payment_time : 160023 payment_date : 20161118 response_code : 00 payment_certificate : ce0c1e7d5496 authorisation_id : 974745 currency_code : 978 card_number : 4978.18 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.espinosa13 order_id : 16215 customer_email : s.espinosa13@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16216" select * from cms_frontusers where identifiant = "b.gaudin22" 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 = "16216" select * from cotisations where identifiant = "b.gaudin22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160422 payment_means : MASTERCARD transmission_date : 20161118150422 payment_time : 160831 payment_date : 20161118 response_code : 00 payment_certificate : fb22bed20a73 authorisation_id : 356251 currency_code : 978 card_number : 5131.60 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.gaudin22 order_id : 16216 customer_email : b.gaudin22@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 = "16217" select * from cms_frontusers where identifiant = "v.lesourne23" 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 = "16217" select * from cotisations where identifiant = "v.lesourne23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165731 payment_means : MASTERCARD transmission_date : 20161118155731 payment_time : 165859 payment_date : 20161118 response_code : 00 payment_certificate : 73134fdfb36d authorisation_id : 117242 currency_code : 978 card_number : 5131.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 : v.lesourne23 order_id : 16217 customer_email : v.lesourne23@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16218" select * from cms_frontusers where identifiant = "m.bronsard04" 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 = "16218" select * from cotisations where identifiant = "m.bronsard04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174426 payment_means : MASTERCARD transmission_date : 20161118164426 payment_time : 174645 payment_date : 20161118 response_code : 00 payment_certificate : b80831315b1c authorisation_id : 392101 currency_code : 978 card_number : 5130.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 : m.bronsard04 order_id : 16218 customer_email : m.bronsard04@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 = "16219" select * from cms_frontusers where identifiant = "v.bertrand30" 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 = "16219" select * from cotisations where identifiant = "c.gaume05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174855 payment_means : VISA transmission_date : 20161118164855 payment_time : 175024 payment_date : 20161118 response_code : 00 payment_certificate : 9918c7b92627 authorisation_id : 340556 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 : v.bertrand30 order_id : 16219 customer_email : v.bertrand30@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16221" select * from cms_frontusers where identifiant = "m.poupard27" 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 = "16221" select * from cotisations where identifiant = "m.poupard27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175548 payment_means : VISA transmission_date : 20161118165548 payment_time : 175644 payment_date : 20161118 response_code : 00 payment_certificate : 0ee32907d674 authorisation_id : 622132 currency_code : 978 card_number : 4970.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 : m.poupard27 order_id : 16221 customer_email : m.poupard27@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 = "16220" select * from cms_frontusers where identifiant = "y.sanchez21" 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 = "16220" select * from cotisations where identifiant = "y.sanchez21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175536 payment_means : VISA transmission_date : 20161118165536 payment_time : 175719 payment_date : 20161118 response_code : 00 payment_certificate : 2b3ffaa070e2 authorisation_id : 843941 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 : y.sanchez21 order_id : 16220 customer_email : y.sanchez21@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 = "16222" select * from cms_frontusers where identifiant = "jp.guerin21" 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 = "16222" select * from cotisations where identifiant = "jp.guerin21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175929 payment_means : MASTERCARD transmission_date : 20161118165929 payment_time : 180242 payment_date : 20161118 response_code : 00 payment_certificate : 1639b158dffc authorisation_id : 666103 currency_code : 978 card_number : 5137.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 : jp.guerin21 order_id : 16222 customer_email : jp.guerin21@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 = "16223" select * from cms_frontusers where identifiant = "p.james17" 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 = "16223" select * from cotisations where identifiant = "p.james17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185825 payment_means : VISA transmission_date : 20161118175825 payment_time : 190015 payment_date : 20161118 response_code : 00 payment_certificate : cd3fb0ad6dc5 authorisation_id : 500561 currency_code : 978 card_number : 4975.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.james17 order_id : 16223 customer_email : p.james17@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 = "16224" select * from cms_frontusers where identifiant = "d.bertrand10" 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 = "16224" select * from cotisations where identifiant = "d.bertrand10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190323 payment_means : MASTERCARD transmission_date : 20161118180323 payment_time : 190515 payment_date : 20161118 response_code : 00 payment_certificate : f9735f30b6a1 authorisation_id : 226600 currency_code : 978 card_number : 5137.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 : d.bertrand10 order_id : 16224 customer_email : d.bertrand10@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 = "16225" select * from cms_frontusers where identifiant = "c.behra30" 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 = "16225" select * from cotisations where identifiant = "c.behra30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194211 payment_means : MASTERCARD transmission_date : 20161118184211 payment_time : 194420 payment_date : 20161118 response_code : 00 payment_certificate : f8094955e8bd authorisation_id : 811224 currency_code : 978 card_number : 5131.19 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.behra30 order_id : 16225 customer_email : c.behra30@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 = "16227" select * from cms_frontusers where identifiant = "d.barthelemy01" 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 = "16227" select * from cotisations where identifiant = "d.barthelemy01" and annee = "2016" and montant <> 0 select * from cotisations_commande where id = "16229" select * from cms_frontusers where identifiant = "t.ostermann17" 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 = "16229" select * from cotisations_commande where id = "16228" select * from cms_frontusers where identifiant = "c.rodrigues02" select * from cotisations where identifiant = "t.ostermann17" and annee = "2016" and montant <> 0 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 = "16228" select * from cotisations where identifiant = "c.rodrigues02" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "d.barthelemy01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200931 payment_means : MASTERCARD transmission_date : 20161118190931 payment_time : 201402 payment_date : 20161118 response_code : 00 payment_certificate : 655ad4e022a2 authorisation_id : 111953 currency_code : 978 card_number : 5132.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 : c.rodrigues02 order_id : 16228 customer_email : c.rodrigues02@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 : ------------------------------------------- code : 0 code : 0 error : error : merchant_id : 077566202600019 merchant_id : 077566202600019 merchant_country : fr merchant_country : fr amount : 8000 amount : 4000 transaction_id : 200850 transaction_id : 200949 payment_means : VISA payment_means : MASTERCARD transmission_date : 20161118190850 transmission_date : 20161118190949 payment_time : 201146 payment_time : 201159 payment_date : 20161118 payment_date : 20161118 response_code : 00 response_code : 00 payment_certificate : 54abe3dfbc07 payment_certificate : 068fa31a7259 authorisation_id : 582496 authorisation_id : 610675 currency_code : 978 currency_code : 978 card_number : 4970.05 card_number : 5133.00 cvv_flag : 1 cvv_flag : 1 cvv_response_code : ?? cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 bank_response_code : 00 complementary_info : complementary_code : 00 return_context : complementary_info : caddie : return_context : receipt_complement : caddie : merchant_language : fr receipt_complement : language : fr merchant_language : fr customer_id : d.barthelemy01 order_id : 16227 language : fr customer_email : d.barthelemy01@compagnons-du-devoir.fr customer_id : t.ostermann17 customer_ip_address : order_id : 16229 capture_day : 0 customer_email : t.ostermann17@compagnons-du-devoir.fr capture_mode : AUTHOR_CAPTURE customer_ip_address : data : capture_day : 0 order_validity : 02 capture_mode : AUTHOR_CAPTURE transaction_condition : 3D_SUCCESS data : statement_reference : order_validity : 02 card_validity : 201809 transaction_condition : 3D_SUCCESS score_value : statement_reference : score_color : card_validity : 201804 score_info : score_value : score_threshold : score_color : score_profile : score_info : ------------------------------------------- score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16234" select * from cms_frontusers where identifiant = "e.grollier09" 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 = "16234" select * from cotisations where identifiant = "e.grollier09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201911 payment_means : MASTERCARD transmission_date : 20161118191911 payment_time : 202018 payment_date : 20161118 response_code : 00 payment_certificate : d648c1734c7b authorisation_id : 399739 currency_code : 978 card_number : 5131.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 : e.grollier09 order_id : 16234 customer_email : e.grollier09@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 = "16237" select * from cms_frontusers where identifiant = "t.ostermann17" 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 = "16237" select * from cotisations where identifiant = "t.ostermann17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202411 payment_means : MASTERCARD transmission_date : 20161118192411 payment_time : 202554 payment_date : 20161118 response_code : 00 payment_certificate : f09b2b7e7ab5 authorisation_id : 151734 currency_code : 978 card_number : 5133.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 : t.ostermann17 order_id : 16237 customer_email : t.ostermann17@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 = "16238" select * from cms_frontusers where identifiant = "a.troux20" 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 = "16238" select * from cotisations where identifiant = "a.troux20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202427 payment_means : MASTERCARD transmission_date : 20161118192427 payment_time : 202556 payment_date : 20161118 response_code : 00 payment_certificate : a766762dd399 authorisation_id : 535916 currency_code : 978 card_number : 5136.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.troux20 order_id : 16238 customer_email : a.troux20@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 = "16235" select * from cms_frontusers where identifiant = "c.pierre23" 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 = "16235" select * from cotisations where identifiant = "c.pierre23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202140 payment_means : VISA transmission_date : 20161118192140 payment_time : 202604 payment_date : 20161118 response_code : 00 payment_certificate : b1dbb82f4388 authorisation_id : 765836 currency_code : 978 card_number : 4978.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 : c.pierre23 order_id : 16235 customer_email : c.pierre23@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 = "16239" select * from cms_frontusers where identifiant = "c.beauchamps24" 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 = "16239" select * from cotisations where identifiant = "c.beauchamps24" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "c.beauchamps24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202438 payment_means : MASTERCARD transmission_date : 20161118192438 payment_time : 202715 payment_date : 20161118 response_code : 00 payment_certificate : d45820ad0a8e authorisation_id : 468336 currency_code : 978 card_number : 5134.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 : c.beauchamps24 order_id : 16239 customer_email : c.beauchamps24@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 = "16240" select * from cms_frontusers where identifiant = "g.storai01" 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 = "16240" select * from cotisations where identifiant = "g.storai01" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "g.storai01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202454 payment_means : VISA transmission_date : 20161118192454 payment_time : 202722 payment_date : 20161118 response_code : 00 payment_certificate : 89774a718b3f authorisation_id : 864463 currency_code : 978 card_number : 4972.11 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.storai01 order_id : 16240 customer_email : g.storai01@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 = "16242" select * from cms_frontusers where identifiant = "l.dodin03" 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 = "16242" select * from cotisations where identifiant = "l.dodin03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202623 payment_means : MASTERCARD transmission_date : 20161118192623 payment_time : 202757 payment_date : 20161118 response_code : 00 payment_certificate : 8ba30d608f85 authorisation_id : 821545 currency_code : 978 card_number : 5131.28 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 : l.dodin03 order_id : 16242 customer_email : l.dodin03@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 = "16241" select * from cms_frontusers where identifiant = "m.mottin26" 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 = "16241" select * from cotisations where identifiant = "m.mottin26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202620 payment_means : VISA transmission_date : 20161118192620 payment_time : 202901 payment_date : 20161118 response_code : 00 payment_certificate : 812856c975cd authorisation_id : 131432 currency_code : 978 card_number : 4562.06 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.mottin26 order_id : 16241 customer_email : m.mottin26@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 : 4000 transaction_id : 202927 payment_means : MASTERCARD transmission_date : 20161118192927 payment_time : 203124 payment_date : 20161118 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.blehaut09 order_id : 16243 customer_email : a.blehaut09@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16245" select * from cms_frontusers where identifiant = "a.castelain07" 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 = "16245" select * from cotisations where identifiant = "a.castelain07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203034 payment_means : VISA transmission_date : 20161118193034 payment_time : 203205 payment_date : 20161118 response_code : 00 payment_certificate : 60081cd2142c authorisation_id : 654156 currency_code : 978 card_number : 4978.48 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.castelain07 order_id : 16245 customer_email : a.castelain07@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 = "16244" select * from cms_frontusers where identifiant = "d.taupin15" 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 = "16244" select * from cotisations where identifiant = "d.taupin15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202946 payment_means : VISA transmission_date : 20161118192946 payment_time : 203233 payment_date : 20161118 response_code : 00 payment_certificate : 1f41df7a36d2 authorisation_id : 115126 currency_code : 978 card_number : 4978.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 : d.taupin15 order_id : 16244 customer_email : d.taupin15@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 = "16247" select * from cms_frontusers where identifiant = "v.tusseau21" 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 = "16247" select * from cotisations where identifiant = "v.tusseau21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203247 payment_means : MASTERCARD transmission_date : 20161118193247 payment_time : 203617 payment_date : 20161118 response_code : 00 payment_certificate : 5a3d0c95fa8f authorisation_id : 244192 currency_code : 978 card_number : 5132.15 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.tusseau21 order_id : 16247 customer_email : v.tusseau21@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 : 4000 transaction_id : 203422 payment_means : MASTERCARD transmission_date : 20161118193422 payment_time : 203755 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.83 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 : f.cronier27 order_id : 16248 customer_email : f.cronier27@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16249" select * from cms_frontusers where identifiant = "a.blehaut09" 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 = "16249" select * from cotisations where identifiant = "a.blehaut09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203654 payment_means : MASTERCARD transmission_date : 20161118193654 payment_time : 203806 payment_date : 20161118 response_code : 00 payment_certificate : ff7891c499c1 authorisation_id : 151291 currency_code : 978 card_number : 5131.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 : a.blehaut09 order_id : 16249 customer_email : a.blehaut09@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 : 201904 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 : 4000 transaction_id : 203123 payment_means : MASTERCARD transmission_date : 20161118193123 payment_time : 203834 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.16 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 : h.aubry08 order_id : 16246 customer_email : h.aubry08@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 : 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 : 4000 transaction_id : 203902 payment_means : MASTERCARD transmission_date : 20161118193902 payment_time : 204240 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.16 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 : h.aubry08 order_id : 16246 customer_email : h.aubry08@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16252" select * from cms_frontusers where identifiant = "s.denis13" 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 = "16252" select * from cotisations where identifiant = "s.denis13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204033 payment_means : MASTERCARD transmission_date : 20161118194033 payment_time : 204343 payment_date : 20161118 response_code : 00 payment_certificate : fcd934db3606 authorisation_id : 056441 currency_code : 978 card_number : 5132.86 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.denis13 order_id : 16252 customer_email : s.denis13@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 = "16253" select * from cms_frontusers where identifiant = "m.stephan01" 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 = "16253" select * from cotisations where identifiant = "m.stephan01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204323 payment_means : MASTERCARD transmission_date : 20161118194323 payment_time : 204511 payment_date : 20161118 response_code : 00 payment_certificate : aaa946cc6043 authorisation_id : 246672 currency_code : 978 card_number : 5137.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 : m.stephan01 order_id : 16253 customer_email : m.stephan01@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 = "16251" select * from cms_frontusers where identifiant = "p.very15" 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 = "16251" select * from cotisations where identifiant = "p.very15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204146 payment_means : VISA transmission_date : 20161118194146 payment_time : 204734 payment_date : 20161118 response_code : 00 payment_certificate : 2d84e2c4e59b authorisation_id : 557373 currency_code : 978 card_number : 4972.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 : p.very15 order_id : 16251 customer_email : p.very15@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 = "16236" select * from cms_frontusers where identifiant = "c.jeuland28" 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 = "16236" select * from cotisations where identifiant = "c.jeuland28" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "c.jeuland28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202351 payment_means : MASTERCARD transmission_date : 20161118192351 payment_time : 204738 payment_date : 20161118 response_code : 00 payment_certificate : 32ee340bd268 authorisation_id : 524344 currency_code : 978 card_number : 5130.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 : c.jeuland28 order_id : 16236 customer_email : c.jeuland28@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 = "16256" select * from cms_frontusers where identifiant = "t.hugues02" 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 = "16256" select * from cotisations where identifiant = "t.hugues02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204914 payment_means : MASTERCARD transmission_date : 20161118194914 payment_time : 205055 payment_date : 20161118 response_code : 00 payment_certificate : fc144285c060 authorisation_id : 126215 currency_code : 978 card_number : 5131.83 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.hugues02 order_id : 16256 customer_email : t.hugues02@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 = "16254" select * from cms_frontusers where identifiant = "h.aubry08" 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 = "16254" select * from cotisations where identifiant = "h.aubry08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204732 payment_means : MASTERCARD transmission_date : 20161118194732 payment_time : 205106 payment_date : 20161118 response_code : 00 payment_certificate : 2d73ec81de7c authorisation_id : 520069 currency_code : 978 card_number : 5341.16 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.aubry08 order_id : 16254 customer_email : h.aubry08@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 = "16255" select * from cms_frontusers where identifiant = "v.dumont25" 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 = "16255" select * from cotisations where identifiant = "v.dumont25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204917 payment_means : VISA transmission_date : 20161118194917 payment_time : 205152 payment_date : 20161118 response_code : 00 payment_certificate : 01cf551b0333 authorisation_id : 646934 currency_code : 978 card_number : 4562.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 : v.dumont25 order_id : 16255 customer_email : v.dumont25@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 = "16257" select * from cms_frontusers where identifiant = "a.guilbert25" 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 = "16257" select * from cotisations where identifiant = "a.guilbert25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205254 payment_means : MASTERCARD transmission_date : 20161118195254 payment_time : 205634 payment_date : 20161118 response_code : 00 payment_certificate : 00bdbfadd619 authorisation_id : 573336 currency_code : 978 card_number : 5131.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 : a.guilbert25 order_id : 16257 customer_email : a.guilbert25@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 = "16259" select * from cms_frontusers where identifiant = "d.dasilva28" 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 = "16259" select * from cotisations where identifiant = "d.dasilva28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205421 payment_means : MASTERCARD transmission_date : 20161118195421 payment_time : 210029 payment_date : 20161118 response_code : 00 payment_certificate : 899abc49909b authorisation_id : 662653 currency_code : 978 card_number : 5135.21 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.dasilva28 order_id : 16259 customer_email : d.dasilva28@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211535 payment_means : MASTERCARD transmission_date : 20161118201535 payment_time : 211740 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.83 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 : f.cronier27 order_id : 16264 customer_email : f.cronier27@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16266" select * from cms_frontusers where identifiant = "t.bachelet19" 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 = "16266" select * from cotisations where identifiant = "t.bachelet19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211808 payment_means : VISA transmission_date : 20161118201808 payment_time : 212041 payment_date : 20161118 response_code : 00 payment_certificate : 0ab13637460f authorisation_id : 681222 currency_code : 978 card_number : 4976.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 : t.bachelet19 order_id : 16266 customer_email : t.bachelet19@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 = "16267" select * from cms_frontusers where identifiant = "a.damiens18" 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 = "16267" select * from cotisations where identifiant = "a.damiens18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211948 payment_means : VISA transmission_date : 20161118201948 payment_time : 212236 payment_date : 20161118 response_code : 00 payment_certificate : e6a4f6e11a5d authorisation_id : 346235 currency_code : 978 card_number : 4201.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 : a.damiens18 order_id : 16267 customer_email : a.damiens18@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 : 201702 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 : 212749 payment_means : CB transmission_date : 20161118202749 payment_time : 212955 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5141.76 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 : m.guillier10 order_id : 16268 customer_email : m.guillier10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED 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 : 213004 payment_means : MASTERCARD transmission_date : 20161118203004 payment_time : 213516 payment_date : 20161118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.76 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 : m.guillier10 order_id : 16268 customer_email : m.guillier10@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16271" select * from cms_frontusers where identifiant = "d.berthome21" 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 = "16271" select * from cotisations where identifiant = "d.berthome21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214120 payment_means : MASTERCARD transmission_date : 20161118204120 payment_time : 214408 payment_date : 20161118 response_code : 00 payment_certificate : 585b1576ca76 authorisation_id : 515746 currency_code : 978 card_number : 5137.02 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.berthome21 order_id : 16271 customer_email : d.berthome21@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 = "16272" select * from cms_frontusers where identifiant = "j.globig11" 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 = "16272" select * from cotisations where identifiant = "j.globig11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214851 payment_means : VISA transmission_date : 20161118204851 payment_time : 215209 payment_date : 20161118 response_code : 00 payment_certificate : e28574ec2bf6 authorisation_id : 280681 currency_code : 978 card_number : 4974.41 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.globig11 order_id : 16272 customer_email : j.globig11@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 : 201907 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16273" select * from cms_frontusers where identifiant = "e.layouni10" 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 = "16273" select * from cotisations where identifiant = "e.layouni10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215224 payment_means : MASTERCARD transmission_date : 20161118205224 payment_time : 215443 payment_date : 20161118 response_code : 00 payment_certificate : 211d6159cac7 authorisation_id : 154414 currency_code : 978 card_number : 5341.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 : e.layouni10 order_id : 16273 customer_email : e.layouni10@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16274" select * from cms_frontusers where identifiant = "c.fredou12" 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 = "16274" select * from cotisations where identifiant = "c.fredou12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215657 payment_means : MASTERCARD transmission_date : 20161118205657 payment_time : 220041 payment_date : 20161118 response_code : 00 payment_certificate : 7d4397b6b522 authorisation_id : 154548 currency_code : 978 card_number : 5130.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 : c.fredou12 order_id : 16274 customer_email : c.fredou12@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 = "16275" select * from cms_frontusers where identifiant = "d.franquebalme09" 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 = "16275" select * from cotisations where identifiant = "d.franquebalme09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221046 payment_means : VISA transmission_date : 20161118211046 payment_time : 221510 payment_date : 20161118 response_code : 00 payment_certificate : e0ea0c03d598 authorisation_id : 322458 currency_code : 978 card_number : 4970.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 : d.franquebalme09 order_id : 16275 customer_email : d.franquebalme09@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16276" select * from cms_frontusers where identifiant = "t.degrange10" 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 = "16276" select * from cotisations where identifiant = "t.degrange10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221709 payment_means : VISA transmission_date : 20161118211709 payment_time : 222011 payment_date : 20161118 response_code : 00 payment_certificate : 3126952536cb authorisation_id : 348652 currency_code : 978 card_number : 4978.21 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.degrange10 order_id : 16276 customer_email : t.degrange10@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 : -------------------------------------------