select * from cotisations_commande where id = "4952" select * from cms_frontusers where identifiant = "x.bonnet28" 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 = "4952" select * from cotisations where identifiant = "x.bonnet28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094011 payment_means : VISA transmission_date : 20141230084011 payment_time : 094149 payment_date : 20141230 response_code : 00 payment_certificate : 660f87138efd authorisation_id : 513534 currency_code : 978 card_number : 4973.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.bonnet28 order_id : 4952 customer_email : x.bonnet28@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 = "4953" select * from cms_frontusers where identifiant = "b.romano30" 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 = "4953" select * from cotisations where identifiant = "b.romano30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095517 payment_means : VISA transmission_date : 20141230085517 payment_time : 095654 payment_date : 20141230 response_code : 00 payment_certificate : 2d2f47958403 authorisation_id : 135722 currency_code : 978 card_number : 4975.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.romano30 order_id : 4953 customer_email : b.romano30@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 : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4954" select * from cms_frontusers where identifiant = "r.geoffray26" 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 = "4954" select * from cotisations where identifiant = "r.geoffray26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101419 payment_means : VISA transmission_date : 20141230091419 payment_time : 101613 payment_date : 20141230 response_code : 00 payment_certificate : 6ce46640d301 authorisation_id : 325124 currency_code : 978 card_number : 4970.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 : r.geoffray26 order_id : 4954 customer_email : r.geoffray26@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 = "4955" select * from cms_frontusers where identifiant = "n.lalibert10" 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 = "4955" select * from cotisations where identifiant = "n.lalibert10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102507 payment_means : VISA transmission_date : 20141230092507 payment_time : 102753 payment_date : 20141230 response_code : 00 payment_certificate : 5fcf0a10c215 authorisation_id : 238503 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 : n.lalibert10 order_id : 4955 customer_email : n.lalibert10@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 = "4956" select * from cms_frontusers where identifiant = "g.kodische06" 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 = "4956" select * from cotisations where identifiant = "g.kodische06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104417 payment_means : VISA transmission_date : 20141230094417 payment_time : 104915 payment_date : 20141230 response_code : 00 payment_certificate : 3591daf6e366 authorisation_id : 142234 currency_code : 978 card_number : 4978.17 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.kodische06 order_id : 4956 customer_email : g.kodische06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4957" select * from cms_frontusers where identifiant = "f.duval20" 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 = "4957" select * from cotisations where identifiant = "f.duval20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112057 payment_means : MASTERCARD transmission_date : 20141230102057 payment_time : 112232 payment_date : 20141230 response_code : 00 payment_certificate : f694f86bad36 authorisation_id : 528486 currency_code : 978 card_number : 5132.64 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.duval20 order_id : 4957 customer_email : f.duval20@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 : 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 : 4000 transaction_id : 112918 payment_means : VISA transmission_date : 20141230102918 payment_time : 113523 payment_date : 20141230 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.80 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 : r.naudot19 order_id : 4958 customer_email : r.naudot19@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 : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4959" select * from cms_frontusers where identifiant = "p.pagnon13" 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 = "4959" select * from cotisations where identifiant = "p.pagnon13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114524 payment_means : VISA transmission_date : 20141230104524 payment_time : 114758 payment_date : 20141230 response_code : 00 payment_certificate : 23126ac5d7da authorisation_id : 432838 currency_code : 978 card_number : 4973.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.pagnon13 order_id : 4959 customer_email : p.pagnon13@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 = "4962" 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 = "4962" select * from cotisations where identifiant = "l.rougier25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123236 payment_means : MASTERCARD transmission_date : 20141230113236 payment_time : 123428 payment_date : 20141230 response_code : 00 payment_certificate : b736c0b6a195 authorisation_id : 254623 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 : jl.masurier14 order_id : 4962 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4963" select * from cms_frontusers where identifiant = "h.migeon20" 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 = "4963" select * from cotisations where identifiant = "h.migeon20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123534 payment_means : MASTERCARD transmission_date : 20141230113534 payment_time : 123719 payment_date : 20141230 response_code : 00 payment_certificate : 8a19d36ed7d7 authorisation_id : 713462 currency_code : 978 card_number : 5131.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.migeon20 order_id : 4963 customer_email : h.migeon20@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 = "4964" 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 = "4964" select * from cotisations where identifiant = "a.boudard01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124202 payment_means : MASTERCARD transmission_date : 20141230114202 payment_time : 124349 payment_date : 20141230 response_code : 00 payment_certificate : ad2e39941648 authorisation_id : 111206 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 : jl.masurier14 order_id : 4964 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4965" select * from cms_frontusers where identifiant = "l.grolier30" 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 = "4965" select * from cotisations where identifiant = "l.grolier30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124445 payment_means : MASTERCARD transmission_date : 20141230114445 payment_time : 125005 payment_date : 20141230 response_code : 00 payment_certificate : cea2f256e913 authorisation_id : 249116 currency_code : 978 card_number : 5138.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 : l.grolier30 order_id : 4965 customer_email : l.grolier30@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 = "4966" 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 = "4966" select * from cotisations where identifiant = "p.bedu20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125535 payment_means : MASTERCARD transmission_date : 20141230115535 payment_time : 125745 payment_date : 20141230 response_code : 00 payment_certificate : d2481fbd810b authorisation_id : 116638 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 : jl.masurier14 order_id : 4966 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4967" 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 = "4967" select * from cotisations where identifiant = "a.baltazar16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130145 payment_means : MASTERCARD transmission_date : 20141230120145 payment_time : 130300 payment_date : 20141230 response_code : 00 payment_certificate : b2ccd63e8bcf authorisation_id : 708761 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 : jl.masurier14 order_id : 4967 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 : 201504 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 : 133550 payment_means : VISA transmission_date : 20141230123550 payment_time : 133737 payment_date : 20141230 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4561.97 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 : c.gouret14 order_id : 4968 customer_email : c.gouret14@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 : 201412 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4968" select * from cms_frontusers where identifiant = "c.gouret14" 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 = "4968" select * from cotisations where identifiant = "c.gouret14" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133743 payment_means : VISA transmission_date : 20141230123743 payment_time : 133956 payment_date : 20141230 response_code : 00 payment_certificate : 60070eb320da authorisation_id : 505352 currency_code : 978 card_number : 4561.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.gouret14 order_id : 4968 customer_email : c.gouret14@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 = "4969" select * from cms_frontusers where identifiant = "n.dietsch19" 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 = "4969" select * from cotisations where identifiant = "n.dietsch19" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "n.dietsch19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134924 payment_means : MASTERCARD transmission_date : 20141230124924 payment_time : 135117 payment_date : 20141230 response_code : 00 payment_certificate : 2c9c456aac5b authorisation_id : 482054 currency_code : 978 card_number : 5132.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 : n.dietsch19 order_id : 4969 customer_email : n.dietsch19@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 = "4970" select * from cms_frontusers where identifiant = "p.hamon16" 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 = "4970" select * from cotisations where identifiant = "p.hamon16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135846 payment_means : MASTERCARD transmission_date : 20141230125846 payment_time : 140049 payment_date : 20141230 response_code : 00 payment_certificate : 8e457cf36557 authorisation_id : 334365 currency_code : 978 card_number : 5132.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.hamon16 order_id : 4970 customer_email : p.hamon16@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4971" select * from cms_frontusers where identifiant = "o.grenon29" 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 = "4971" select * from cotisations where identifiant = "o.grenon29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143202 payment_means : MASTERCARD transmission_date : 20141230133202 payment_time : 143529 payment_date : 20141230 response_code : 00 payment_certificate : 4a95bb1f2f60 authorisation_id : 238834 currency_code : 978 card_number : 5131.64 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.grenon29 order_id : 4971 customer_email : o.grenon29@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 = "4972" select * from cms_frontusers where identifiant = "o.grenon29" 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 = "4972" select * from cotisations where identifiant = "t.norroy23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143720 payment_means : MASTERCARD transmission_date : 20141230133720 payment_time : 143840 payment_date : 20141230 response_code : 00 payment_certificate : a4391dacc80e authorisation_id : 613522 currency_code : 978 card_number : 5131.64 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.grenon29 order_id : 4972 customer_email : o.grenon29@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 = "4973" select * from cms_frontusers where identifiant = "g.uetwiller16" 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 = "4973" select * from cotisations where identifiant = "g.uetwiller16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 160102 payment_means : VISA transmission_date : 20141230150102 payment_time : 160313 payment_date : 20141230 response_code : 00 payment_certificate : 30013d119180 authorisation_id : 274281 currency_code : 978 card_number : 4556.39 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.uetwiller16 order_id : 4973 customer_email : g.uetwiller16@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 = "4975" select * from cms_frontusers where identifiant = "m.guyader27" 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 = "4975" select * from cotisations where identifiant = "m.guyader27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163106 payment_means : VISA transmission_date : 20141230153106 payment_time : 163228 payment_date : 20141230 response_code : 00 payment_certificate : 369b39253651 authorisation_id : 044388 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 : m.guyader27 order_id : 4975 customer_email : m.guyader27@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 = "4976" select * from cms_frontusers where identifiant = "v.hissler10" 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 = "4976" select * from cotisations where identifiant = "v.hissler10" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163611 payment_means : MASTERCARD transmission_date : 20141230153611 payment_time : 164009 payment_date : 20141230 response_code : 00 payment_certificate : eb5e2e4f1b6d authorisation_id : 655701 currency_code : 978 card_number : 5133.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.hissler10 order_id : 4976 customer_email : v.hissler10@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 = "4977" select * from cms_frontusers where identifiant = "v.hissler10" 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 = "4977" select * from cotisations where identifiant = "v.hissler10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 164103 payment_means : MASTERCARD transmission_date : 20141230154103 payment_time : 164315 payment_date : 20141230 response_code : 00 payment_certificate : dc164c41ebd1 authorisation_id : 804365 currency_code : 978 card_number : 5133.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.hissler10 order_id : 4977 customer_email : v.hissler10@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 = "4978" select * from cms_frontusers where identifiant = "e.leclercq01" 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 = "4978" select * from cotisations where identifiant = "e.leclercq01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164141 payment_means : VISA transmission_date : 20141230154141 payment_time : 164317 payment_date : 20141230 response_code : 00 payment_certificate : 6bfcbd992db2 authorisation_id : 423258 currency_code : 978 card_number : 4975.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.leclercq01 order_id : 4978 customer_email : e.leclercq01@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 = "4979" select * from cms_frontusers where identifiant = "b.denoel12" 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 = "4979" select * from cotisations where identifiant = "b.denoel12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 174246 payment_means : MASTERCARD transmission_date : 20141230164246 payment_time : 174406 payment_date : 20141230 response_code : 00 payment_certificate : 149f9152e754 authorisation_id : 935464 currency_code : 978 card_number : 5131.00 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.denoel12 order_id : 4979 customer_email : b.denoel12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4980" select * from cms_frontusers where identifiant = "f.borie09" 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 = "4980" select * from cotisations where identifiant = "f.borie09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180809 payment_means : VISA transmission_date : 20141230170809 payment_time : 180936 payment_date : 20141230 response_code : 00 payment_certificate : 45349baf4480 authorisation_id : 030203 currency_code : 978 card_number : 4659.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.borie09 order_id : 4980 customer_email : f.borie09@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 = "4981" 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 = "4981" select * from cotisations where identifiant = "jp.blanc01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182137 payment_means : MASTERCARD transmission_date : 20141230172137 payment_time : 182325 payment_date : 20141230 response_code : 00 payment_certificate : ad4113a24756 authorisation_id : 439445 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 : jl.masurier14 order_id : 4981 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 : 201504 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 : 182442 payment_means : MASTERCARD transmission_date : 20141230172442 payment_time : 182551 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4982 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 : 201504 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 : 182608 payment_means : MASTERCARD transmission_date : 20141230172608 payment_time : 182745 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4982 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 : 201504 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 : 182811 payment_means : MASTERCARD transmission_date : 20141230172811 payment_time : 183047 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4982 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 : 201504 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 : 183302 payment_means : MASTERCARD transmission_date : 20141230173302 payment_time : 183436 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4983 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 : 201504 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 : 183515 payment_means : MASTERCARD transmission_date : 20141230173515 payment_time : 183637 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4984 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4985" select * from cms_frontusers where identifiant = "v.benigaud21" 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 = "4985" select * from cotisations where identifiant = "v.benigaud21" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "v.benigaud21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183732 payment_means : VISA transmission_date : 20141230173732 payment_time : 184246 payment_date : 20141230 response_code : 00 payment_certificate : ca2d51a02036 authorisation_id : 614220 currency_code : 978 card_number : 4970.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.benigaud21 order_id : 4985 customer_email : v.benigaud21@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 : 201511 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 : 184421 payment_means : MASTERCARD transmission_date : 20141230174421 payment_time : 184540 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4986 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4987" select * from cms_frontusers where identifiant = "j.picardat25" 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 = "4987" select * from cotisations where identifiant = "j.picardat25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184425 payment_means : VISA transmission_date : 20141230174425 payment_time : 184613 payment_date : 20141230 response_code : 00 payment_certificate : 1ac282a531ed authorisation_id : 140545 currency_code : 978 card_number : 4970.33 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.picardat25 order_id : 4987 customer_email : j.picardat25@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 : 185308 payment_means : MASTERCARD transmission_date : 20141230175308 payment_time : 185442 payment_date : 20141230 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 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 : 4988 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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4989" select * from cms_frontusers where identifiant = "b.galichet25" 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 = "4989" select * from cotisations where identifiant = "d.gil03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185759 payment_means : VISA transmission_date : 20141230175759 payment_time : 190003 payment_date : 20141230 response_code : 00 payment_certificate : 95dcd4f84701 authorisation_id : 882359 currency_code : 978 card_number : 4561.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.galichet25 order_id : 4989 customer_email : b.galichet25@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 : 8000 transaction_id : 191350 payment_means : MASTERCARD transmission_date : 20141230181350 payment_time : 191928 payment_date : 20141230 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.galichet25 order_id : 4990 customer_email : b.galichet25@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 : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4991" select * from cms_frontusers where identifiant = "b.galichet25" 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 = "4991" select * from cotisations where identifiant = "jr.maurel01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192323 payment_means : MASTERCARD transmission_date : 20141230182323 payment_time : 192604 payment_date : 20141230 response_code : 00 payment_certificate : 1cfebbb2ef4f authorisation_id : 511542 currency_code : 978 card_number : 5137.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.galichet25 order_id : 4991 customer_email : b.galichet25@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 = "4992" select * from cms_frontusers where identifiant = "y.pannelay06" 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 = "4992" select * from cotisations where identifiant = "d.martinez14" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202914 payment_means : VISA transmission_date : 20141230192914 payment_time : 203402 payment_date : 20141230 response_code : 00 payment_certificate : 0c9d13e55018 authorisation_id : 839891 currency_code : 978 card_number : 4973.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.pannelay06 order_id : 4992 customer_email : y.pannelay06@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4993" select * from cms_frontusers where identifiant = "c.lamrani12" 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 = "4993" select * from cotisations where identifiant = "c.lamrani12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203442 payment_means : VISA transmission_date : 20141230193442 payment_time : 203842 payment_date : 20141230 response_code : 00 payment_certificate : 1761548d3a29 authorisation_id : 742314 currency_code : 978 card_number : 4973.29 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.lamrani12 order_id : 4993 customer_email : c.lamrani12@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 = "4994" select * from cms_frontusers where identifiant = "b.galichet25" 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 = "4994" select * from cotisations where identifiant = "d.pierre08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203707 payment_means : MASTERCARD transmission_date : 20141230193707 payment_time : 204210 payment_date : 20141230 response_code : 00 payment_certificate : 4cd25fc8bed0 authorisation_id : 251065 currency_code : 978 card_number : 5137.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.galichet25 order_id : 4994 customer_email : b.galichet25@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 = "4995" select * from cms_frontusers where identifiant = "a.marian12" 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 = "4995" select * from cotisations where identifiant = "a.marian12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204902 payment_means : VISA transmission_date : 20141230194902 payment_time : 205241 payment_date : 20141230 response_code : 00 payment_certificate : c0370927dc1a authorisation_id : 916367 currency_code : 978 card_number : 4970.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.marian12 order_id : 4995 customer_email : a.marian12@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 : 4000 transaction_id : 213626 payment_means : MASTERCARD transmission_date : 20141230203626 payment_time : 215417 payment_date : 20141230 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.78 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 : d.jayle03 order_id : 4997 customer_email : d.jayle03@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 = "4998" select * from cms_frontusers where identifiant = "d.jayle03" 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 = "4998" select * from cotisations where identifiant = "d.jayle03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220849 payment_means : MASTERCARD transmission_date : 20141230210849 payment_time : 221129 payment_date : 20141230 response_code : 00 payment_certificate : c4932fe90725 authorisation_id : 870146 currency_code : 978 card_number : 5137.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.jayle03 order_id : 4998 customer_email : d.jayle03@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 = "4999" select * from cms_frontusers where identifiant = "g.weissgerber18" 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 = "4999" select * from cotisations where identifiant = "g.weissgerber18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225959 payment_means : MASTERCARD transmission_date : 20141230215959 payment_time : 230309 payment_date : 20141230 response_code : 00 payment_certificate : ed0bb60d54e3 authorisation_id : 973236 currency_code : 978 card_number : 5490.45 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.weissgerber18 order_id : 4999 customer_email : g.weissgerber18@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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------