select * from cotisations_commande where id = "11422" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11422" select * from cotisations where identifiant = "p.bedu20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 074505 payment_means : MASTERCARD transmission_date : 20151224064505 payment_time : 074636 payment_date : 20151224 response_code : 00 payment_certificate : c129883e5c28 authorisation_id : 433550 currency_code : 978 card_number : 5131.27 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 : jl.masurier14 order_id : 11422 customer_email : jl.masurier14@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 = "11423" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11423" select * from cotisations where identifiant = "s.benoit09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 074936 payment_means : MASTERCARD transmission_date : 20151224064936 payment_time : 075053 payment_date : 20151224 response_code : 00 payment_certificate : 58e15fac982d authorisation_id : 365836 currency_code : 978 card_number : 5131.27 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 : jl.masurier14 order_id : 11423 customer_email : jl.masurier14@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 = "11424" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11424" select * from cotisations where identifiant = "jp.blanc01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075456 payment_means : MASTERCARD transmission_date : 20151224065456 payment_time : 075629 payment_date : 20151224 response_code : 00 payment_certificate : a820a5bbe2e5 authorisation_id : 642674 currency_code : 978 card_number : 5131.27 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 : jl.masurier14 order_id : 11424 customer_email : jl.masurier14@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 = "11425" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11425" select * from cotisations where identifiant = "fd.canonge29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080039 payment_means : MASTERCARD transmission_date : 20151224070039 payment_time : 080152 payment_date : 20151224 response_code : 00 payment_certificate : 137b42ca9a4b authorisation_id : 605415 currency_code : 978 card_number : 5131.27 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 : jl.masurier14 order_id : 11425 customer_email : jl.masurier14@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 = "11426" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11426" select * from cotisations where identifiant = "a.cure27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080413 payment_means : MASTERCARD transmission_date : 20151224070413 payment_time : 080513 payment_date : 20151224 response_code : 00 payment_certificate : 5efcd7f2831b authorisation_id : 363626 currency_code : 978 card_number : 5131.27 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 : jl.masurier14 order_id : 11426 customer_email : jl.masurier14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080814 payment_means : MASTERCARD transmission_date : 20151224070814 payment_time : 080929 payment_date : 20151224 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11427 customer_email : jl.masurier14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080937 payment_means : MASTERCARD transmission_date : 20151224070937 payment_time : 081057 payment_date : 20151224 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11427 customer_email : jl.masurier14@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 = "11429" select * from cms_frontusers where identifiant = "p.fabbro21" 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 = "11429" select * from cotisations where identifiant = "p.fabbro21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082505 payment_means : VISA transmission_date : 20151224072505 payment_time : 082649 payment_date : 20151224 response_code : 00 payment_certificate : 455ff793db4c authorisation_id : 652125 currency_code : 978 card_number : 4771.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 : p.fabbro21 order_id : 11429 customer_email : p.fabbro21@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084721 payment_means : MASTERCARD transmission_date : 20151224074721 payment_time : 084841 payment_date : 20151224 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11430 customer_email : jl.masurier14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092204 payment_means : MASTERCARD transmission_date : 20151224082204 payment_time : 092314 payment_date : 20151224 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11431 customer_email : jl.masurier14@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 = "11433" select * from cms_frontusers where identifiant = "pa.chinot13" 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 = "11433" select * from cotisations where identifiant = "pa.chinot13" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "pa.chinot13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095136 payment_means : MASTERCARD transmission_date : 20151224085136 payment_time : 095415 payment_date : 20151224 response_code : 00 payment_certificate : c8149d5f47b6 authorisation_id : 232239 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 : pa.chinot13 order_id : 11433 customer_email : pa.chinot13@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 : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11434" select * from cms_frontusers where identifiant = "j.gouil29" 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 = "11434" select * from cotisations where identifiant = "j.gouil29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102643 payment_means : VISA transmission_date : 20151224092643 payment_time : 103039 payment_date : 20151224 response_code : 00 payment_certificate : 90125bef4b23 authorisation_id : 165338 currency_code : 978 card_number : 4978.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 : j.gouil29 order_id : 11434 customer_email : j.gouil29@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 = "11435" select * from cms_frontusers where identifiant = "m.suray28" 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 = "11435" select * from cotisations where identifiant = "m.suray28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105046 payment_means : MASTERCARD transmission_date : 20151224095046 payment_time : 105237 payment_date : 20151224 response_code : 00 payment_certificate : 53b7d558513c authorisation_id : 644609 currency_code : 978 card_number : 5131.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.suray28 order_id : 11435 customer_email : m.suray28@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 = "11436" select * from cms_frontusers where identifiant = "c.bauchart31" 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 = "11436" select * from cotisations where identifiant = "c.bauchart31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110528 payment_means : VISA transmission_date : 20151224100528 payment_time : 110732 payment_date : 20151224 response_code : 00 payment_certificate : 00adaded21e4 authorisation_id : 142367 currency_code : 978 card_number : 4970.63 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.bauchart31 order_id : 11436 customer_email : c.bauchart31@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 = "11437" select * from cms_frontusers where identifiant = "o.sibaud25" 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 = "11437" select * from cotisations where identifiant = "o.sibaud25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 111254 payment_means : VISA transmission_date : 20151224101254 payment_time : 111548 payment_date : 20151224 response_code : 00 payment_certificate : 6b66c9b4d194 authorisation_id : 127553 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 : o.sibaud25 order_id : 11437 customer_email : o.sibaud25@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 : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11438" select * from cms_frontusers where identifiant = "n.digaire24" 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 = "11438" select * from cotisations where identifiant = "l.houmard02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112501 payment_means : VISA transmission_date : 20151224102501 payment_time : 112603 payment_date : 20151224 response_code : 00 payment_certificate : d56ecef25cb7 authorisation_id : 114139 currency_code : 978 card_number : 4970.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 : n.digaire24 order_id : 11438 customer_email : n.digaire24@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113444 payment_means : VISA transmission_date : 20151224103444 payment_time : 114056 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.wilhelm07 order_id : 11439 customer_email : y.wilhelm07@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 : 201605 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 : 114411 payment_means : CB transmission_date : 20151224104411 payment_time : 114710 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.wilhelm07 order_id : 11440 customer_email : y.wilhelm07@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11441" select * from cms_frontusers where identifiant = "j.baron10" 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 = "11441" select * from cotisations where identifiant = "j.baron10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114907 payment_means : VISA transmission_date : 20151224104907 payment_time : 115118 payment_date : 20151224 response_code : 00 payment_certificate : 465523948c59 authorisation_id : 582230 currency_code : 978 card_number : 4978.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.baron10 order_id : 11441 customer_email : j.baron10@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 = "11442" select * from cms_frontusers where identifiant = "m.coistia23" 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 = "11442" select * from cotisations where identifiant = "m.coistia23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 115259 payment_means : MASTERCARD transmission_date : 20151224105259 payment_time : 115521 payment_date : 20151224 response_code : 00 payment_certificate : f34b466075cb authorisation_id : 305961 currency_code : 978 card_number : 5131.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.coistia23 order_id : 11442 customer_email : m.coistia23@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 = "11443" select * from cms_frontusers where identifiant = "x.lombart18" 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 = "11443" select * from cotisations where identifiant = "x.lombart18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 121644 payment_means : VISA transmission_date : 20151224111644 payment_time : 122015 payment_date : 20151224 response_code : 00 payment_certificate : 0ee2eae75649 authorisation_id : 146239 currency_code : 978 card_number : 4970.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 : x.lombart18 order_id : 11443 customer_email : x.lombart18@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 = "11444" select * from cms_frontusers where identifiant = "jp.pages02" 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 = "11444" select * from cotisations where identifiant = "n.butelle23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123431 payment_means : VISA transmission_date : 20151224113431 payment_time : 123646 payment_date : 20151224 response_code : 00 payment_certificate : 66af46d8140b authorisation_id : 498256 currency_code : 978 card_number : 4975.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.pages02 order_id : 11444 customer_email : jp.pages02@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 = "11446" select * from cms_frontusers where identifiant = "jp.casala18" 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 = "11446" select * from cotisations where identifiant = "m.poidras09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132158 payment_means : VISA transmission_date : 20151224122158 payment_time : 132701 payment_date : 20151224 response_code : 00 payment_certificate : e6c4bd2c3375 authorisation_id : 077333 currency_code : 978 card_number : 4975.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 : jp.casala18 order_id : 11446 customer_email : jp.casala18@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 = "11448" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11448" select * from cotisations where identifiant = "s.turban06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135745 payment_means : VISA transmission_date : 20151224125745 payment_time : 135918 payment_date : 20151224 response_code : 00 payment_certificate : ae56409dce61 authorisation_id : 553217 currency_code : 978 card_number : 4978.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 : g.dumez15 order_id : 11448 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_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11449" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11449" select * from cotisations where identifiant = "m.poulard30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140007 payment_means : VISA transmission_date : 20151224130007 payment_time : 140048 payment_date : 20151224 response_code : 00 payment_certificate : 19c81e31b69a authorisation_id : 997047 currency_code : 978 card_number : 4978.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 : g.dumez15 order_id : 11449 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_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11450" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11450" select * from cotisations where identifiant = "d.leblois23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140138 payment_means : VISA transmission_date : 20151224130138 payment_time : 140228 payment_date : 20151224 response_code : 00 payment_certificate : c8ff3bab34a8 authorisation_id : 810553 currency_code : 978 card_number : 4978.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 : g.dumez15 order_id : 11450 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_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11451" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11451" select * from cotisations where identifiant = "j.cheyrol29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140303 payment_means : VISA transmission_date : 20151224130303 payment_time : 140346 payment_date : 20151224 response_code : 00 payment_certificate : df1a88945c0e authorisation_id : 706246 currency_code : 978 card_number : 4978.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.dumez15 order_id : 11451 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_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11452" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11452" select * from cotisations where identifiant = "j.maccard31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140602 payment_means : VISA transmission_date : 20151224130602 payment_time : 140658 payment_date : 20151224 response_code : 00 payment_certificate : c3522da3cf3c authorisation_id : 026481 currency_code : 978 card_number : 4978.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.dumez15 order_id : 11452 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_SUCCESS statement_reference : card_validity : 201806 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 : 140740 payment_means : VISA transmission_date : 20151224130740 payment_time : 140901 payment_date : 20151224 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.beuzon05 order_id : 11454 customer_email : n.beuzon05@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 = "11453" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11453" select * from cotisations where identifiant = "jm.carriere28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140620 payment_means : MASTERCARD transmission_date : 20151224130620 payment_time : 140920 payment_date : 20151224 response_code : 00 payment_certificate : b27cec4930f8 authorisation_id : 046240 currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11453 customer_email : jl.masurier14@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 = "11456" select * from cms_frontusers where identifiant = "g.dumez15" 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 = "11456" select * from cotisations where identifiant = "jn.leroy01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141340 payment_means : VISA transmission_date : 20151224131340 payment_time : 141426 payment_date : 20151224 response_code : 00 payment_certificate : 13560026e332 authorisation_id : 712623 currency_code : 978 card_number : 4978.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.dumez15 order_id : 11456 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_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11455" select * from cms_frontusers where identifiant = "jl.masurier14" 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 = "11455" select * from cotisations where identifiant = "b.perrin31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141238 payment_means : MASTERCARD transmission_date : 20151224131238 payment_time : 141426 payment_date : 20151224 response_code : 00 payment_certificate : 755939f4be23 authorisation_id : 854311 currency_code : 978 card_number : 5131.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.masurier14 order_id : 11455 customer_email : jl.masurier14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145837 payment_means : MASTERCARD transmission_date : 20151224135837 payment_time : 150405 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11457 customer_email : r.flachard15@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150413 payment_means : MASTERCARD transmission_date : 20151224140413 payment_time : 151135 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11457 customer_email : r.flachard15@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151317 payment_means : MASTERCARD transmission_date : 20151224141317 payment_time : 151820 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11458 customer_email : r.flachard15@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 = "11459" select * from cms_frontusers where identifiant = "r.flachard15" 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 = "11459" select * from cotisations where identifiant = "r.flachard15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152144 payment_means : MASTERCARD transmission_date : 20151224142144 payment_time : 152315 payment_date : 20151224 response_code : 00 payment_certificate : 5a15970c5f71 authorisation_id : 285496 currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11459 customer_email : r.flachard15@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 = "11460" select * from cms_frontusers where identifiant = "r.flachard15" 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 = "11460" select * from cotisations where identifiant = "a.my22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152651 payment_means : MASTERCARD transmission_date : 20151224142651 payment_time : 152808 payment_date : 20151224 response_code : 00 payment_certificate : 4ee062140714 authorisation_id : 279432 currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11460 customer_email : r.flachard15@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 = "11461" select * from cms_frontusers where identifiant = "b.rozier12" 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 = "11461" select * from cotisations where identifiant = "b.rozier12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152833 payment_means : VISA transmission_date : 20151224142833 payment_time : 153056 payment_date : 20151224 response_code : 00 payment_certificate : 8e8d6d449935 authorisation_id : 461230 currency_code : 978 card_number : 4978.64 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.rozier12 order_id : 11461 customer_email : b.rozier12@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 = "11463" select * from cms_frontusers where identifiant = "r.flachard15" 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 = "11463" select * from cotisations where identifiant = "m.foriat02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153038 payment_means : MASTERCARD transmission_date : 20151224143038 payment_time : 153155 payment_date : 20151224 response_code : 00 payment_certificate : 7aacaccecaee authorisation_id : 772427 currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.flachard15 order_id : 11463 customer_email : r.flachard15@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 = "11464" select * from cms_frontusers where identifiant = "jm.desbordes24" 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 = "11464" select * from cotisations where identifiant = "jm.desbordes24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153749 payment_means : VISA transmission_date : 20151224143749 payment_time : 154012 payment_date : 20151224 response_code : 00 payment_certificate : fb413dca4a86 authorisation_id : 371503 currency_code : 978 card_number : 4979.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.desbordes24 order_id : 11464 customer_email : jm.desbordes24@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 = "11462" select * from cms_frontusers where identifiant = "r.vee31" 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 = "11462" select * from cotisations where identifiant = "r.vee31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 153000 payment_means : VISA transmission_date : 20151224143000 payment_time : 154029 payment_date : 20151224 response_code : 00 payment_certificate : fa1de9bd4eca authorisation_id : 425021 currency_code : 978 card_number : 4978.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.vee31 order_id : 11462 customer_email : r.vee31@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 = "11465" select * from cms_frontusers where identifiant = "r.vee31" 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 = "11465" select * from cotisations where identifiant = "r.vee31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154105 payment_means : VISA transmission_date : 20151224144105 payment_time : 154153 payment_date : 20151224 response_code : 00 payment_certificate : bfaa9ac12a61 authorisation_id : 812991 currency_code : 978 card_number : 4978.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.vee31 order_id : 11465 customer_email : r.vee31@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 = "11466" select * from cms_frontusers where identifiant = "c.michon05" 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 = "11466" select * from cotisations where identifiant = "c.michon05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 155443 payment_means : MASTERCARD transmission_date : 20151224145443 payment_time : 155631 payment_date : 20151224 response_code : 00 payment_certificate : 1adb4f928800 authorisation_id : 251513 currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.michon05 order_id : 11466 customer_email : c.michon05@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 = "11467" select * from cms_frontusers where identifiant = "l.belin01" 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 = "11467" select * from cotisations where identifiant = "l.belin01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161322 payment_means : VISA transmission_date : 20151224151322 payment_time : 161604 payment_date : 20151224 response_code : 00 payment_certificate : 38c1b452ef8b authorisation_id : 618065 currency_code : 978 card_number : 4976.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.belin01 order_id : 11467 customer_email : l.belin01@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 = "11468" select * from cms_frontusers where identifiant = "js.demilly01" 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 = "11468" select * from cotisations where identifiant = "js.demilly01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162559 payment_means : MASTERCARD transmission_date : 20151224152559 payment_time : 162846 payment_date : 20151224 response_code : 00 payment_certificate : d1a222574ff0 authorisation_id : 567316 currency_code : 978 card_number : 5137.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : js.demilly01 order_id : 11468 customer_email : js.demilly01@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 = "11469" select * from cms_frontusers where identifiant = "m.claparede08" 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 = "11469" select * from cotisations where identifiant = "m.claparede08" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.claparede08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165645 payment_means : MASTERCARD transmission_date : 20151224155645 payment_time : 170149 payment_date : 20151224 response_code : 00 payment_certificate : 9db06e050748 authorisation_id : 960269 currency_code : 978 card_number : 5132.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.claparede08 order_id : 11469 customer_email : m.claparede08@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 : 201603 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 : 180101 payment_means : VISA transmission_date : 20151224170101 payment_time : 180518 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.fenet06 order_id : 11472 customer_email : j.fenet06@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11472" select * from cms_frontusers where identifiant = "j.fenet06" 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 = "11472" select * from cotisations where identifiant = "j.fenet06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180526 payment_means : VISA transmission_date : 20151224170526 payment_time : 180909 payment_date : 20151224 response_code : 00 payment_certificate : 8b78868bd72f authorisation_id : 614350 currency_code : 978 card_number : 4973.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.fenet06 order_id : 11472 customer_email : j.fenet06@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 = "11473" select * from cms_frontusers where identifiant = "e.guaine18" 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 = "11473" select * from cotisations where identifiant = "e.guaine18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182506 payment_means : MASTERCARD transmission_date : 20151224172506 payment_time : 182923 payment_date : 20151224 response_code : 00 payment_certificate : dc60528eafb6 authorisation_id : 974813 currency_code : 978 card_number : 5137.97 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.guaine18 order_id : 11473 customer_email : e.guaine18@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 = "11475" select * from cms_frontusers where identifiant = "a.alves10" 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 = "11475" select * from cotisations where identifiant = "a.alves10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184632 payment_means : VISA transmission_date : 20151224174632 payment_time : 184910 payment_date : 20151224 response_code : 00 payment_certificate : 1e1c9d13abe4 authorisation_id : 952660 currency_code : 978 card_number : 4975.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.alves10 order_id : 11475 customer_email : a.alves10@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11476" select * from cms_frontusers where identifiant = "j.beneteau30" 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 = "11476" select * from cotisations where identifiant = "j.beneteau30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190628 payment_means : MASTERCARD transmission_date : 20151224180628 payment_time : 191006 payment_date : 20151224 response_code : 00 payment_certificate : 5072aee91e79 authorisation_id : 235516 currency_code : 978 card_number : 5131.74 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.beneteau30 order_id : 11476 customer_email : j.beneteau30@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192535 payment_means : MASTERCARD transmission_date : 20151224182535 payment_time : 182920 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.peter30 order_id : 11477 customer_email : jp.peter30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : 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 : 193040 payment_means : MASTERCARD transmission_date : 20151224183040 payment_time : 183400 payment_date : 20151224 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.peter30 order_id : 11477 customer_email : jp.peter30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------