Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 062839 payment_means : VISA transmission_date : 20141109052839 payment_time : 063128 payment_date : 20141109 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.huard12 order_id : 2438 customer_email : j.huard12@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2439" select * from cms_frontusers where identifiant = "t.rigot22" 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 = "2439" select * from cotisations where identifiant = "t.rigot22" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "t.rigot22" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112829 payment_means : MASTERCARD transmission_date : 20141109102829 payment_time : 113211 payment_date : 20141109 response_code : 00 payment_certificate : ca4edb4d1ebf authorisation_id : 583543 currency_code : 978 card_number : 5133.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.rigot22 order_id : 2439 customer_email : t.rigot22@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 = "2440" select * from cms_frontusers where identifiant = "p.leroy13" 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 = "2440" select * from cotisations where identifiant = "p.leroy13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130901 payment_means : MASTERCARD transmission_date : 20141109120901 payment_time : 131115 payment_date : 20141109 response_code : 00 payment_certificate : db2fbb6815e2 authorisation_id : 101204 currency_code : 978 card_number : 5131.69 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.leroy13 order_id : 2440 customer_email : p.leroy13@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 = "2441" select * from cms_frontusers where identifiant = "j.huard12" 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 = "2441" select * from cotisations where identifiant = "f.beaudoin09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131020 payment_means : MASTERCARD transmission_date : 20141109121020 payment_time : 131227 payment_date : 20141109 response_code : 00 payment_certificate : d5fff90ebbf6 authorisation_id : 885542 currency_code : 978 card_number : 5132.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.huard12 order_id : 2441 customer_email : j.huard12@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 = "2442" select * from cms_frontusers where identifiant = "j.garcia06" 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 = "2442" select * from cotisations where identifiant = "j.garcia06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135204 payment_means : MASTERCARD transmission_date : 20141109125204 payment_time : 135412 payment_date : 20141109 response_code : 00 payment_certificate : 3f9a2ba68c4b authorisation_id : 558264 currency_code : 978 card_number : 5132.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.garcia06 order_id : 2442 customer_email : j.garcia06@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 : 143500 payment_means : VISA transmission_date : 20141109133500 payment_time : 143718 payment_date : 20141109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.96 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 : y.nussbaum21 order_id : 2443 customer_email : y.nussbaum21@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2443" select * from cms_frontusers where identifiant = "y.nussbaum21" 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 = "2443" select * from cotisations where identifiant = "y.nussbaum21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 143730 payment_means : VISA transmission_date : 20141109133730 payment_time : 144316 payment_date : 20141109 response_code : 00 payment_certificate : 34fa22fcdcc5 authorisation_id : 245144 currency_code : 978 card_number : 4970.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 : y.nussbaum21 order_id : 2443 customer_email : y.nussbaum21@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 = "2449" select * from cms_frontusers where identifiant = "e.bodenan26" 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 = "2449" select * from cotisations where identifiant = "e.bodenan26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162244 payment_means : VISA transmission_date : 20141109152244 payment_time : 162522 payment_date : 20141109 response_code : 00 payment_certificate : a17be5902a8c authorisation_id : 358103 currency_code : 978 card_number : 4976.81 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.bodenan26 order_id : 2449 customer_email : e.bodenan26@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 : 4000 transaction_id : 162241 payment_means : MASTERCARD transmission_date : 20141109152241 payment_time : 162816 payment_date : 20141109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.dubois16 order_id : 2448 customer_email : a.dubois16@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2451" select * from cms_frontusers where identifiant = "e.peridy17" 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 = "2451" select * from cotisations where identifiant = "e.peridy17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163250 payment_means : MASTERCARD transmission_date : 20141109153250 payment_time : 163439 payment_date : 20141109 response_code : 00 payment_certificate : def11f96763f authorisation_id : 311201 currency_code : 978 card_number : 5138.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 : e.peridy17 order_id : 2451 customer_email : e.peridy17@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 = "2450" select * from cms_frontusers where identifiant = "n.roy20" 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 = "2450" select * from cotisations where identifiant = "n.roy20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163052 payment_means : MASTERCARD transmission_date : 20141109153052 payment_time : 163625 payment_date : 20141109 response_code : 00 payment_certificate : bec20eed36a1 authorisation_id : 154281 currency_code : 978 card_number : 5132.92 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.roy20 order_id : 2450 customer_email : n.roy20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201412 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2452" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2452" select * from cotisations where identifiant = "c.bele10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163808 payment_means : VISA transmission_date : 20141109153808 payment_time : 164039 payment_date : 20141109 response_code : 00 payment_certificate : de10637d9cc6 authorisation_id : 322487 currency_code : 978 card_number : 4978.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2452 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2453" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2453" select * from cotisations where identifiant = "j.manceau17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164233 payment_means : MASTERCARD transmission_date : 20141109154233 payment_time : 164417 payment_date : 20141109 response_code : 00 payment_certificate : 0c0549b3ab5a authorisation_id : 002165 currency_code : 978 card_number : 5132.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 : l.haeringer25 order_id : 2453 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2454" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2454" select * from cotisations where identifiant = "o.debuisne26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164559 payment_means : MASTERCARD transmission_date : 20141109154559 payment_time : 165037 payment_date : 20141109 response_code : 00 payment_certificate : 404b979ffa96 authorisation_id : 307156 currency_code : 978 card_number : 5131.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2454 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2455" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2455" select * from cotisations where identifiant = "l.bouffard19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165122 payment_means : MASTERCARD transmission_date : 20141109155122 payment_time : 165235 payment_date : 20141109 response_code : 00 payment_certificate : 4857e522cc1d authorisation_id : 544242 currency_code : 978 card_number : 5131.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2455 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2456" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2456" select * from cotisations where identifiant = "d.bresard02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165321 payment_means : MASTERCARD transmission_date : 20141109155321 payment_time : 165448 payment_date : 20141109 response_code : 00 payment_certificate : c08d63896ac6 authorisation_id : 006217 currency_code : 978 card_number : 5131.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2456 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2457" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2457" select * from cotisations where identifiant = "g.lebon16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165526 payment_means : VISA transmission_date : 20141109155526 payment_time : 165650 payment_date : 20141109 response_code : 00 payment_certificate : 0fbe1265e395 authorisation_id : 836369 currency_code : 978 card_number : 4970.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2457 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2458" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2458" select * from cotisations where identifiant = "a.perrier28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165857 payment_means : MASTERCARD transmission_date : 20141109155857 payment_time : 170030 payment_date : 20141109 response_code : 00 payment_certificate : dd79fbd22d09 authorisation_id : 266541 currency_code : 978 card_number : 5132.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2458 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201510 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 : 170137 payment_means : MASTERCARD transmission_date : 20141109160137 payment_time : 170401 payment_date : 20141109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.01 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 : l.haeringer25 order_id : 2459 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201602 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 : 170544 payment_means : VISA transmission_date : 20141109160544 payment_time : 170733 payment_date : 20141109 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2461 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201506 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2460" select * from cms_frontusers where identifiant = "m.autret06" 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 = "2460" select * from cotisations where identifiant = "m.autret06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 170531 payment_means : VISA transmission_date : 20141109160531 payment_time : 170851 payment_date : 20141109 response_code : 00 payment_certificate : 46b83b493383 authorisation_id : 368665 currency_code : 978 card_number : 4973.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.autret06 order_id : 2460 customer_email : m.autret06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2462" select * from cms_frontusers where identifiant = "l.haeringer25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2462" select * from cotisations where identifiant = "a.loucheux25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170942 payment_means : MASTERCARD transmission_date : 20141109160942 payment_time : 171131 payment_date : 20141109 response_code : 00 payment_certificate : ab86aea0a681 authorisation_id : 342082 currency_code : 978 card_number : 5136.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 2462 customer_email : l.haeringer25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2463" select * from cms_frontusers where identifiant = "f.warolus29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2463" select * from cotisations where identifiant = "f.warolus29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181711 payment_means : VISA transmission_date : 20141109171711 payment_time : 181953 payment_date : 20141109 response_code : 00 payment_certificate : 52dbd145b68f authorisation_id : 455140 currency_code : 978 card_number : 4974.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.warolus29 order_id : 2463 customer_email : f.warolus29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201608 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 : 220428 payment_means : VISA transmission_date : 20141109210428 payment_time : 220657 payment_date : 20141109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.meyer25 order_id : 2465 customer_email : g.meyer25@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 : ------------------------------------------- select * from cotisations_commande where id = "2466" select * from cms_frontusers where identifiant = "m.chevret27" 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 = "2466" select * from cotisations where identifiant = "m.chevret27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223006 payment_means : VISA transmission_date : 20141109213006 payment_time : 223332 payment_date : 20141109 response_code : 00 payment_certificate : 116b36076dc5 authorisation_id : 441946 currency_code : 978 card_number : 4970.54 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.chevret27 order_id : 2466 customer_email : m.chevret27@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2467" select * from cms_frontusers where identifiant = "o.blanchard30" 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 = "2467" select * from cotisations where identifiant = "o.blanchard30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 231924 payment_means : VISA transmission_date : 20141109221924 payment_time : 232205 payment_date : 20141109 response_code : 00 payment_certificate : 359be2b9436c authorisation_id : 134413 currency_code : 978 card_number : 4970.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : o.blanchard30 order_id : 2467 customer_email : o.blanchard30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201503 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------