select * from cotisations_commande where id = "2468" select * from cms_frontusers where identifiant = "p.vielle16" 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 = "2468" select * from cotisations where identifiant = "p.vielle16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082202 payment_means : VISA transmission_date : 20141110072202 payment_time : 082621 payment_date : 20141110 response_code : 00 payment_certificate : 228de60f64bf authorisation_id : 623543 currency_code : 978 card_number : 4970.25 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.vielle16 order_id : 2468 customer_email : p.vielle16@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 = "2469" select * from cms_frontusers where identifiant = "fx.salazar31" 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 = "2469" select * from cotisations where identifiant = "fx.salazar31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 090006 payment_means : VISA transmission_date : 20141110080006 payment_time : 090143 payment_date : 20141110 response_code : 00 payment_certificate : 49a21c88a9e3 authorisation_id : 572102 currency_code : 978 card_number : 4978.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : fx.salazar31 order_id : 2469 customer_email : fx.salazar31@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 = "2470" select * from cms_frontusers where identifiant = "r.blavet22" 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 = "2470" select * from cotisations where identifiant = "r.blavet22" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102133 payment_means : VISA transmission_date : 20141110092133 payment_time : 102442 payment_date : 20141110 response_code : 00 payment_certificate : ded498711ed0 authorisation_id : 331629 currency_code : 978 card_number : 4979.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.blavet22 order_id : 2470 customer_email : r.blavet22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201503 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2471" select * from cms_frontusers where identifiant = "g.bailly05" 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 = "2471" select * from cotisations where identifiant = "g.bailly05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105104 payment_means : VISA transmission_date : 20141110095104 payment_time : 105235 payment_date : 20141110 response_code : 00 payment_certificate : 2b48a82e02db authorisation_id : 737359 currency_code : 978 card_number : 4533.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 : g.bailly05 order_id : 2471 customer_email : g.bailly05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2472" select * from cms_frontusers where identifiant = "ph.dumontet17" 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 = "2472" select * from cotisations where identifiant = "ph.dumontet17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115140 payment_means : MASTERCARD transmission_date : 20141110105140 payment_time : 115328 payment_date : 20141110 response_code : 00 payment_certificate : 5b73981227e1 authorisation_id : 607702 currency_code : 978 card_number : 5131.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 : ph.dumontet17 order_id : 2472 customer_email : ph.dumontet17@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 = "2473" select * from cms_frontusers where identifiant = "b.vincent16" 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 = "2473" select * from cotisations where identifiant = "b.vincent16" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 120213 payment_means : MASTERCARD transmission_date : 20141110110213 payment_time : 120424 payment_date : 20141110 response_code : 00 payment_certificate : 15053156f5d8 authorisation_id : 652452 currency_code : 978 card_number : 5133.09 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.vincent16 order_id : 2473 customer_email : b.vincent16@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 = "2474" select * from cms_frontusers where identifiant = "s.diaz02" 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 = "2474" select * from cotisations where identifiant = "s.diaz02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130036 payment_means : VISA transmission_date : 20141110120036 payment_time : 130159 payment_date : 20141110 response_code : 00 payment_certificate : d8708ddf4386 authorisation_id : 252840 currency_code : 978 card_number : 4970.80 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.diaz02 order_id : 2474 customer_email : s.diaz02@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 = "2475" select * from cms_frontusers where identifiant = "l.chranuski31" 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 = "2475" select * from cotisations where identifiant = "l.chranuski31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141554 payment_means : VISA transmission_date : 20141110131554 payment_time : 141740 payment_date : 20141110 response_code : 00 payment_certificate : 3732cd381941 authorisation_id : 916403 currency_code : 978 card_number : 4971.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 : l.chranuski31 order_id : 2475 customer_email : l.chranuski31@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2477" select * from cms_frontusers where identifiant = "e.fant18" 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 = "2477" select * from cotisations where identifiant = "e.fant18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143217 payment_means : VISA transmission_date : 20141110133217 payment_time : 143551 payment_date : 20141110 response_code : 00 payment_certificate : 06d3a5b01063 authorisation_id : 811079 currency_code : 978 card_number : 4977.76 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.fant18 order_id : 2477 customer_email : e.fant18@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 = "2479" select * from cms_frontusers where identifiant = "f.jourdan16" 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 = "2479" select * from cotisations where identifiant = "f.jourdan16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170950 payment_means : MASTERCARD transmission_date : 20141110160950 payment_time : 171144 payment_date : 20141110 response_code : 00 payment_certificate : 42410fe35a1d authorisation_id : 119715 currency_code : 978 card_number : 5137.10 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.jourdan16 order_id : 2479 customer_email : f.jourdan16@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 : 182013 payment_means : VISA transmission_date : 20141110172013 payment_time : 182104 payment_date : 20141110 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 : 2481 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 = "2483" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "2483" select * from cotisations where identifiant = "f.bureau27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184845 payment_means : VISA transmission_date : 20141110174845 payment_time : 185252 payment_date : 20141110 response_code : 00 payment_certificate : e19f4c6ab058 authorisation_id : 416553 currency_code : 978 card_number : 4970.43 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.bureau27 order_id : 2483 customer_email : f.bureau27@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 = "2484" select * from cms_frontusers where identifiant = "a.berton11" 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 = "2484" select * from cotisations where identifiant = "a.berton11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190137 payment_means : MASTERCARD transmission_date : 20141110180137 payment_time : 190346 payment_date : 20141110 response_code : 00 payment_certificate : c87c84189be2 authorisation_id : 600597 currency_code : 978 card_number : 5137.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 : a.berton11 order_id : 2484 customer_email : a.berton11@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 = "2485" select * from cms_frontusers where identifiant = "d.valroff21" 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 = "2485" select * from cotisations where identifiant = "d.valroff21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190557 payment_means : MASTERCARD transmission_date : 20141110180557 payment_time : 190938 payment_date : 20141110 response_code : 00 payment_certificate : 58575615a416 authorisation_id : 485281 currency_code : 978 card_number : 5131.10 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.valroff21 order_id : 2485 customer_email : d.valroff21@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 = "2486" select * from cms_frontusers where identifiant = "j.bellina13" 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 = "2486" select * from cotisations where identifiant = "j.bellina13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190856 payment_means : VISA transmission_date : 20141110180856 payment_time : 191058 payment_date : 20141110 response_code : 00 payment_certificate : bb3c70487b5d authorisation_id : 662912 currency_code : 978 card_number : 4970.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.bellina13 order_id : 2486 customer_email : j.bellina13@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 = "2487" select * from cms_frontusers where identifiant = "t.faivre12" 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 = "2487" select * from cotisations where identifiant = "t.faivre12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203833 payment_means : VISA transmission_date : 20141110193833 payment_time : 204114 payment_date : 20141110 response_code : 00 payment_certificate : 9e58efcb417b authorisation_id : 613721 currency_code : 978 card_number : 4201.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 : t.faivre12 order_id : 2487 customer_email : t.faivre12@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 = "2489" select * from cms_frontusers where identifiant = "p.lamy10" 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 = "2489" select * from cotisations where identifiant = "p.lamy10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214335 payment_means : VISA transmission_date : 20141110204335 payment_time : 214559 payment_date : 20141110 response_code : 00 payment_certificate : 44b5bf6189c8 authorisation_id : 546145 currency_code : 978 card_number : 4150.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 : p.lamy10 order_id : 2489 customer_email : p.lamy10@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 = "2491" select * from cms_frontusers where identifiant = "jc.pennequin03" 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 = "2491" select * from cotisations where identifiant = "jc.pennequin03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225809 payment_means : MASTERCARD transmission_date : 20141110215809 payment_time : 230046 payment_date : 20141110 response_code : 00 payment_certificate : 6bf190767d00 authorisation_id : 290304 currency_code : 978 card_number : 5612.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 : jc.pennequin03 order_id : 2491 customer_email : jc.pennequin03@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 : -------------------------------------------