select * from cotisations_commande where id = "7686" select * from cms_frontusers where identifiant = "l.tamponnet28" 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 = "7686" select * from cotisations where identifiant = "l.tamponnet28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082506 payment_means : VISA transmission_date : 20151010062506 payment_time : 082644 payment_date : 20151010 response_code : 00 payment_certificate : 0bc90b423682 authorisation_id : 546061 currency_code : 978 card_number : 4976.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 : l.tamponnet28 order_id : 7686 customer_email : l.tamponnet28@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 = "7687" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7687" select * from cotisations where identifiant = "n.bacci12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090253 payment_means : MASTERCARD transmission_date : 20151010070253 payment_time : 090434 payment_date : 20151010 response_code : 00 payment_certificate : 23da245d925f authorisation_id : 345736 currency_code : 978 card_number : 5136.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.coudin04 order_id : 7687 customer_email : l.coudin04@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 = "7689" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7689" select * from cotisations where identifiant = "j.rousset25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091556 payment_means : MASTERCARD transmission_date : 20151010071556 payment_time : 091720 payment_date : 20151010 response_code : 00 payment_certificate : 85c43431a564 authorisation_id : 456575 currency_code : 978 card_number : 5131.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 : l.coudin04 order_id : 7689 customer_email : l.coudin04@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 = "7690" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7690" select * from cotisations where identifiant = "m.bougain20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091905 payment_means : VISA transmission_date : 20151010071905 payment_time : 092052 payment_date : 20151010 response_code : 00 payment_certificate : 89bb14b094ca authorisation_id : 540809 currency_code : 978 card_number : 4970.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 : l.coudin04 order_id : 7690 customer_email : l.coudin04@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 : ------------------------------------------- select * from cotisations_commande where id = "7691" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7691" select * from cotisations where identifiant = "p.servy11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092437 payment_means : VISA transmission_date : 20151010072437 payment_time : 092722 payment_date : 20151010 response_code : 00 payment_certificate : 8cb145f7bd30 authorisation_id : 329632 currency_code : 978 card_number : 4975.26 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.coudin04 order_id : 7691 customer_email : l.coudin04@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 = "7692" select * from cms_frontusers where identifiant = "m.baillon25" 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 = "7692" select * from cotisations where identifiant = "m.baillon25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100550 payment_means : MASTERCARD transmission_date : 20151010080550 payment_time : 100743 payment_date : 20151010 response_code : 00 payment_certificate : 8e58d49d8bfd authorisation_id : 131621 currency_code : 978 card_number : 5136.98 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.baillon25 order_id : 7692 customer_email : m.baillon25@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 = "7693" select * from cms_frontusers where identifiant = "s.truchet29" 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 = "7693" select * from cotisations where identifiant = "s.truchet29" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "s.truchet29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 103940 payment_means : MASTERCARD transmission_date : 20151010083940 payment_time : 104336 payment_date : 20151010 response_code : 00 payment_certificate : dee18ee5e4f4 authorisation_id : 532331 currency_code : 978 card_number : 5131.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 : s.truchet29 order_id : 7693 customer_email : s.truchet29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104053 payment_means : MASTERCARD transmission_date : 20151010084053 payment_time : 104428 payment_date : 20151010 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.44 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.defournas27 order_id : 7694 customer_email : d.defournas27@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7696" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7696" select * from cotisations where identifiant = "l.mouzin30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105848 payment_means : MASTERCARD transmission_date : 20151010085848 payment_time : 110228 payment_date : 20151010 response_code : 00 payment_certificate : 89fcaca81008 authorisation_id : 836223 currency_code : 978 card_number : 5131.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 : l.coudin04 order_id : 7696 customer_email : l.coudin04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7697" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7697" select * from cotisations where identifiant = "a.barrera01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110359 payment_means : VISA transmission_date : 20151010090359 payment_time : 110938 payment_date : 20151010 response_code : 00 payment_certificate : d25c85fd4372 authorisation_id : 692335 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 : l.coudin04 order_id : 7697 customer_email : l.coudin04@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 = "7698" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7698" select * from cotisations where identifiant = "v.martin04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111103 payment_means : MASTERCARD transmission_date : 20151010091103 payment_time : 111313 payment_date : 20151010 response_code : 00 payment_certificate : d2d718235aa1 authorisation_id : 102662 currency_code : 978 card_number : 5137.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.coudin04 order_id : 7698 customer_email : l.coudin04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7699" select * from cms_frontusers where identifiant = "l.coudin04" 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 = "7699" select * from cotisations where identifiant = "c.lauriol24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111510 payment_means : MASTERCARD transmission_date : 20151010091510 payment_time : 111659 payment_date : 20151010 response_code : 00 payment_certificate : c70f5dbeb73a authorisation_id : 095423 currency_code : 978 card_number : 5137.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.coudin04 order_id : 7699 customer_email : l.coudin04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113727 payment_means : MASTERCARD transmission_date : 20151010093727 payment_time : 113830 payment_date : 20151010 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5136.00 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 : e.hardy27 order_id : 7700 customer_email : e.hardy27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7701" select * from cms_frontusers where identifiant = "f.menochet26" 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 = "7701" select * from cotisations where identifiant = "c.posseme27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120713 payment_means : VISA transmission_date : 20151010100713 payment_time : 120923 payment_date : 20151010 response_code : 00 payment_certificate : 2245cb2e9b99 authorisation_id : 642609 currency_code : 978 card_number : 4972.55 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.menochet26 order_id : 7701 customer_email : f.menochet26@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 = "7702" select * from cms_frontusers where identifiant = "f.menochet26" 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 = "7702" select * from cotisations where identifiant = "a.quimper07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121126 payment_means : MASTERCARD transmission_date : 20151010101126 payment_time : 121309 payment_date : 20151010 response_code : 00 payment_certificate : 8fc01c0a3801 authorisation_id : 450223 currency_code : 978 card_number : 5131.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 : f.menochet26 order_id : 7702 customer_email : f.menochet26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7704" select * from cms_frontusers where identifiant = "g.percheron08" 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 = "7704" select * from cotisations where identifiant = "t.vanexem24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133152 payment_means : VISA transmission_date : 20151010113152 payment_time : 133300 payment_date : 20151010 response_code : 00 payment_certificate : 30352cf7719d authorisation_id : 542556 currency_code : 978 card_number : 4978.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.percheron08 order_id : 7704 customer_email : g.percheron08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7707" select * from cms_frontusers where identifiant = "m.marcon16" 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 = "7707" select * from cotisations where identifiant = "m.marcon16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150104 payment_means : VISA transmission_date : 20151010130104 payment_time : 150341 payment_date : 20151010 response_code : 00 payment_certificate : cf23674f15a5 authorisation_id : 399252 currency_code : 978 card_number : 4970.74 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.marcon16 order_id : 7707 customer_email : m.marcon16@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 = "7708" select * from cms_frontusers where identifiant = "c.camici11" 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 = "7708" select * from cotisations where identifiant = "c.camici11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 151129 payment_means : VISA transmission_date : 20151010131129 payment_time : 151309 payment_date : 20151010 response_code : 00 payment_certificate : ba625e5aa0a0 authorisation_id : 156769 currency_code : 978 card_number : 4974.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 : c.camici11 order_id : 7708 customer_email : c.camici11@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 = "7709" 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 = "7709" select * from cotisations where identifiant = "v.benigaud21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 161816 payment_means : VISA transmission_date : 20151010141816 payment_time : 161931 payment_date : 20151010 response_code : 00 payment_certificate : db058f988776 authorisation_id : 276273 currency_code : 978 card_number : 4970.36 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 : 7709 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 : 201709 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------