select * from cotisations_commande where id = "3647" select * from cms_frontusers where identifiant = "c.martz28" 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 = "3647" select * from cotisations where identifiant = "c.martz28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 014834 payment_means : MASTERCARD transmission_date : 20141203004834 payment_time : 015435 payment_date : 20141203 response_code : 00 payment_certificate : 275a4d5f77fa authorisation_id : 535681 currency_code : 978 card_number : 5132.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 : c.martz28 order_id : 3647 customer_email : c.martz28@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3648" select * from cms_frontusers where identifiant = "h.pointillart06" 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 = "3648" select * from cotisations where identifiant = "h.pointillart06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071530 payment_means : MASTERCARD transmission_date : 20141203061530 payment_time : 071755 payment_date : 20141203 response_code : 00 payment_certificate : 27cba9190f7f authorisation_id : 565122 currency_code : 978 card_number : 5131.50 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.pointillart06 order_id : 3648 customer_email : h.pointillart06@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 : 201509 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 : 093114 payment_means : MASTERCARD transmission_date : 20141203083114 payment_time : 093249 payment_date : 20141203 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.herault19 order_id : 3651 customer_email : c.herault19@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 = "3652" select * from cms_frontusers where identifiant = "e.francois26" 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 = "3652" select * from cotisations where identifiant = "e.francois26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093204 payment_means : MASTERCARD transmission_date : 20141203083204 payment_time : 093432 payment_date : 20141203 response_code : 00 payment_certificate : 5b4ce173b202 authorisation_id : 120523 currency_code : 978 card_number : 5137.87 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.francois26 order_id : 3652 customer_email : e.francois26@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3653" select * from cms_frontusers where identifiant = "l.huault31" 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 = "3653" select * from cotisations where identifiant = "l.huault31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101319 payment_means : MASTERCARD transmission_date : 20141203091319 payment_time : 101905 payment_date : 20141203 response_code : 00 payment_certificate : adb23287b001 authorisation_id : 242013 currency_code : 978 card_number : 5131.93 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.huault31 order_id : 3653 customer_email : l.huault31@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 : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3654" select * from cms_frontusers where identifiant = "p.voisin09" 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 = "3654" select * from cotisations where identifiant = "p.voisin09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102732 payment_means : VISA transmission_date : 20141203092732 payment_time : 102914 payment_date : 20141203 response_code : 00 payment_certificate : 7b36dedc94dd authorisation_id : 673854 currency_code : 978 card_number : 4972.22 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.voisin09 order_id : 3654 customer_email : p.voisin09@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 : 201505 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3655" select * from cms_frontusers where identifiant = "f.gillier08" 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 = "3655" select * from cotisations where identifiant = "f.gillier08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110125 payment_means : MASTERCARD transmission_date : 20141203100125 payment_time : 110247 payment_date : 20141203 response_code : 00 payment_certificate : f6ac8b91ab01 authorisation_id : 533153 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 : f.gillier08 order_id : 3655 customer_email : f.gillier08@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 : 201505 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 : 134505 payment_means : MASTERCARD transmission_date : 20141203124505 payment_time : 134709 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.84 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 : g.dumez15 order_id : 3657 customer_email : g.dumez15@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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3658" select * from cms_frontusers where identifiant = "l.daheron18" 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 = "3658" select * from cotisations where identifiant = "l.guguin24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134755 payment_means : VISA transmission_date : 20141203124755 payment_time : 134908 payment_date : 20141203 response_code : 00 payment_certificate : df9bdc20d654 authorisation_id : 175222 currency_code : 978 card_number : 4972.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 : l.daheron18 order_id : 3658 customer_email : l.daheron18@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 : 201503 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 : 143117 payment_means : MASTERCARD transmission_date : 20141203133117 payment_time : 143527 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5134.11 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 : m1.vidal02 order_id : 3659 customer_email : m1.vidal02@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3659" select * from cms_frontusers where identifiant = "m1.vidal02" 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 = "3659" select * from cotisations where identifiant = "m1.vidal02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143550 payment_means : MASTERCARD transmission_date : 20141203133550 payment_time : 143925 payment_date : 20141203 response_code : 00 payment_certificate : 8d140d1e7fa7 authorisation_id : 172002 currency_code : 978 card_number : 5134.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 : m1.vidal02 order_id : 3659 customer_email : m1.vidal02@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3661" select * from cms_frontusers where identifiant = "p.guilbaud27" 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 = "3661" select * from cotisations where identifiant = "p.guilbaud27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162507 payment_means : MASTERCARD transmission_date : 20141203152507 payment_time : 162637 payment_date : 20141203 response_code : 00 payment_certificate : 96d258f7ea02 authorisation_id : 620632 currency_code : 978 card_number : 5132.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 : p.guilbaud27 order_id : 3661 customer_email : p.guilbaud27@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3663" select * from cms_frontusers where identifiant = "m.rousseau07" 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 = "3663" select * from cotisations where identifiant = "m.rousseau07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172136 payment_means : VISA transmission_date : 20141203162136 payment_time : 172311 payment_date : 20141203 response_code : 00 payment_certificate : 7d04640b77e1 authorisation_id : 263522 currency_code : 978 card_number : 4978.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 : m.rousseau07 order_id : 3663 customer_email : m.rousseau07@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3664" select * from cms_frontusers where identifiant = "jm.schaffner20" 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 = "3664" select * from cotisations where identifiant = "jm.schaffner20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172957 payment_means : MASTERCARD transmission_date : 20141203162957 payment_time : 173205 payment_date : 20141203 response_code : 00 payment_certificate : 35b26dac06cb authorisation_id : 145174 currency_code : 978 card_number : 5137.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 : jm.schaffner20 order_id : 3664 customer_email : jm.schaffner20@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 : 173639 payment_means : VISA transmission_date : 20141203163639 payment_time : 173802 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.14 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 : f.bretton20 order_id : 3665 customer_email : f.bretton20@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 : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3665" select * from cms_frontusers where identifiant = "f.bretton20" 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 = "3665" select * from cotisations where identifiant = "f.bretton20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173825 payment_means : MASTERCARD transmission_date : 20141203163825 payment_time : 174024 payment_date : 20141203 response_code : 00 payment_certificate : 30f1b768aa4b authorisation_id : 300554 currency_code : 978 card_number : 5131.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 : f.bretton20 order_id : 3665 customer_email : f.bretton20@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3667" select * from cms_frontusers where identifiant = "n.henry16" 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 = "3667" select * from cotisations where identifiant = "n.henry16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183210 payment_means : VISA transmission_date : 20141203173210 payment_time : 183410 payment_date : 20141203 response_code : 00 payment_certificate : 8f919e395297 authorisation_id : 562461 currency_code : 978 card_number : 4150.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 : n.henry16 order_id : 3667 customer_email : n.henry16@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 : 201503 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3668" select * from cms_frontusers where identifiant = "e.durand05" 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 = "3668" select * from cotisations where identifiant = "e.durand05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185202 payment_means : MASTERCARD transmission_date : 20141203175202 payment_time : 185447 payment_date : 20141203 response_code : 00 payment_certificate : da97e9c76ec9 authorisation_id : 647295 currency_code : 978 card_number : 5131.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 : e.durand05 order_id : 3668 customer_email : e.durand05@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 = "3669" select * from cms_frontusers where identifiant = "l.haeringer25" 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 = "3669" select * from cotisations where identifiant = "v.martins25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185302 payment_means : MASTERCARD transmission_date : 20141203175302 payment_time : 185528 payment_date : 20141203 response_code : 00 payment_certificate : c45169e1d73e authorisation_id : 796594 currency_code : 978 card_number : 5341.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 : l.haeringer25 order_id : 3669 customer_email : l.haeringer25@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3670" select * from cms_frontusers where identifiant = "l.haeringer25" 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 = "3670" select * from cotisations where identifiant = "p.sonzogni03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185641 payment_means : MASTERCARD transmission_date : 20141203175641 payment_time : 185935 payment_date : 20141203 response_code : 00 payment_certificate : 7cffcebbc2ba authorisation_id : 148545 currency_code : 978 card_number : 5341.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 : l.haeringer25 order_id : 3670 customer_email : l.haeringer25@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 : 201501 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3672" select * from cms_frontusers where identifiant = "v.herrbach24" 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 = "3672" select * from cotisations where identifiant = "v.herrbach24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 191053 payment_means : VISA transmission_date : 20141203181053 payment_time : 191223 payment_date : 20141203 response_code : 00 payment_certificate : 5fc0dea5407f authorisation_id : 003489 currency_code : 978 card_number : 4762.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 : v.herrbach24 order_id : 3672 customer_email : v.herrbach24@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 = "3675" select * from cms_frontusers where identifiant = "r.tavernier01" 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 = "3675" select * from cotisations where identifiant = "r.tavernier01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193958 payment_means : MASTERCARD transmission_date : 20141203183958 payment_time : 194334 payment_date : 20141203 response_code : 00 payment_certificate : 61c0170bf166 authorisation_id : 541641 currency_code : 978 card_number : 5132.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 : r.tavernier01 order_id : 3675 customer_email : r.tavernier01@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 : 201501 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 : 194052 payment_means : MASTERCARD transmission_date : 20141203184052 payment_time : 194614 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.46 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 : a.theroude02 order_id : 3674 customer_email : a.theroude02@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 : 201601 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 : 201749 payment_means : MASTERCARD transmission_date : 20141203191749 payment_time : 201857 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.21 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 : t.cortes09 order_id : 3677 customer_email : t.cortes09@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 : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3678" select * from cms_frontusers where identifiant = "g.vernagut05" 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 = "3678" select * from cotisations where identifiant = "g.vernagut05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201930 payment_means : MASTERCARD transmission_date : 20141203191930 payment_time : 202043 payment_date : 20141203 response_code : 00 payment_certificate : 20e78cb58e68 authorisation_id : 335016 currency_code : 978 card_number : 5132.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 : g.vernagut05 order_id : 3678 customer_email : g.vernagut05@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3680" select * from cms_frontusers where identifiant = "c.pichierri03" 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 = "3680" select * from cotisations where identifiant = "h.mercier01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205146 payment_means : MASTERCARD transmission_date : 20141203195146 payment_time : 205355 payment_date : 20141203 response_code : 00 payment_certificate : 696ed99848ec authorisation_id : 114920 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 : c.pichierri03 order_id : 3680 customer_email : c.pichierri03@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3681" select * from cms_frontusers where identifiant = "n.servage24" 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 = "3681" select * from cotisations where identifiant = "n.servage24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210257 payment_means : MASTERCARD transmission_date : 20141203200257 payment_time : 210923 payment_date : 20141203 response_code : 00 payment_certificate : 30ef6ff1e790 authorisation_id : 414219 currency_code : 978 card_number : 5131.37 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.servage24 order_id : 3681 customer_email : n.servage24@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3682" select * from cms_frontusers where identifiant = "c.leguernic20" 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 = "3682" select * from cotisations where identifiant = "c.leguernic20" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "c.leguernic20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211531 payment_means : VISA transmission_date : 20141203201531 payment_time : 211704 payment_date : 20141203 response_code : 00 payment_certificate : 53d1b2bb26ba authorisation_id : 155712 currency_code : 978 card_number : 4978.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 : c.leguernic20 order_id : 3682 customer_email : c.leguernic20@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 : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3683" select * from cms_frontusers where identifiant = "k.binet16" 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 = "3683" select * from cotisations where identifiant = "k.binet16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212221 payment_means : VISA transmission_date : 20141203202221 payment_time : 212728 payment_date : 20141203 response_code : 00 payment_certificate : 6aeedaaa078f authorisation_id : 150524 currency_code : 978 card_number : 4973.67 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.binet16 order_id : 3683 customer_email : k.binet16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213010 payment_means : MASTERCARD transmission_date : 20141203203010 payment_time : 213154 payment_date : 20141203 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.poulet19 order_id : 3686 customer_email : a.poulet19@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 : 201412 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 : 213330 payment_means : MASTERCARD transmission_date : 20141203203330 payment_time : 213911 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5136.04 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 : a.bachelet08 order_id : 3687 customer_email : a.bachelet08@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3689" select * from cms_frontusers where identifiant = "t.royer29" 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 = "3689" select * from cotisations where identifiant = "t.royer29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215522 payment_means : VISA transmission_date : 20141203205522 payment_time : 215753 payment_date : 20141203 response_code : 00 payment_certificate : 284901539068 authorisation_id : 736693 currency_code : 978 card_number : 4978.67 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.royer29 order_id : 3689 customer_email : t.royer29@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 = "3693" select * from cms_frontusers where identifiant = "r.paugois20" 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 = "3693" select * from cotisations where identifiant = "r.paugois20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222712 payment_means : VISA transmission_date : 20141203212712 payment_time : 223723 payment_date : 20141203 response_code : 00 payment_certificate : 60795f5c5682 authorisation_id : 276655 currency_code : 978 card_number : 4978.49 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.paugois20 order_id : 3693 customer_email : r.paugois20@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3694" select * from cms_frontusers where identifiant = "r.paugois20" 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 = "3694" select * from cotisations where identifiant = "l.terrien14" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223930 payment_means : VISA transmission_date : 20141203213930 payment_time : 224047 payment_date : 20141203 response_code : 00 payment_certificate : a6acfcd5db3c authorisation_id : 232119 currency_code : 978 card_number : 4978.49 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.paugois20 order_id : 3694 customer_email : r.paugois20@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 : 201609 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 : 230348 payment_means : VISA transmission_date : 20141203220348 payment_time : 231343 payment_date : 20141203 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.31 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.bresch24 order_id : 3696 customer_email : m.bresch24@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 : 201511 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------