select * from cotisations_commande where id = "4838" select * from cms_frontusers where identifiant = "l.viale25" 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 = "4838" select * from cotisations where identifiant = "l.viale25" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104519 payment_means : MASTERCARD transmission_date : 20141226094519 payment_time : 104918 payment_date : 20141226 response_code : 00 payment_certificate : bd49b40db2c6 authorisation_id : 135735 currency_code : 978 card_number : 5132.23 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.viale25 order_id : 4838 customer_email : l.viale25@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 = "4839" select * from cms_frontusers where identifiant = "j.porchet23" 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 = "4839" select * from cotisations where identifiant = "j.porchet23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104715 payment_means : VISA transmission_date : 20141226094715 payment_time : 104925 payment_date : 20141226 response_code : 00 payment_certificate : bf8eabd754a4 authorisation_id : 143220 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 : j.porchet23 order_id : 4839 customer_email : j.porchet23@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 = "4840" select * from cms_frontusers where identifiant = "l.viale25" 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 = "4840" select * from cotisations where identifiant = "l.viale25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 105000 payment_means : MASTERCARD transmission_date : 20141226095000 payment_time : 105123 payment_date : 20141226 response_code : 00 payment_certificate : c7ce03f212d1 authorisation_id : 743254 currency_code : 978 card_number : 5132.01 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.viale25 order_id : 4840 customer_email : l.viale25@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 = "4841" select * from cms_frontusers where identifiant = "a.dupin20" 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 = "4841" select * from cotisations where identifiant = "a.dupin20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 110157 payment_means : MASTERCARD transmission_date : 20141226100157 payment_time : 110648 payment_date : 20141226 response_code : 00 payment_certificate : 15d3a2aa342c authorisation_id : 599634 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 : a.dupin20 order_id : 4841 customer_email : a.dupin20@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 = "4842" 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 = "4842" select * from cotisations where identifiant = "c.camici11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 111455 payment_means : VISA transmission_date : 20141226101455 payment_time : 111629 payment_date : 20141226 response_code : 00 payment_certificate : cda51610f35e authorisation_id : 038175 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 : 4842 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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113632 payment_means : VISA transmission_date : 20141226103632 payment_time : 113746 payment_date : 20141226 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 : g.coutant27 order_id : 4844 customer_email : g.coutant27@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4844" select * from cms_frontusers where identifiant = "g.coutant27" 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 = "4844" select * from cotisations where identifiant = "i.delongueville23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113753 payment_means : VISA transmission_date : 20141226103753 payment_time : 113915 payment_date : 20141226 response_code : 00 payment_certificate : ed8e508e4cb2 authorisation_id : 841572 currency_code : 978 card_number : 4970.30 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.coutant27 order_id : 4844 customer_email : g.coutant27@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 = "4845" select * from cms_frontusers where identifiant = "g.coutant27" 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 = "4845" select * from cotisations where identifiant = "g.coutant27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113932 payment_means : VISA transmission_date : 20141226103932 payment_time : 114227 payment_date : 20141226 response_code : 00 payment_certificate : ab0b5e63dfb9 authorisation_id : 523472 currency_code : 978 card_number : 4970.30 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.coutant27 order_id : 4845 customer_email : g.coutant27@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 : 124521 payment_means : MASTERCARD transmission_date : 20141226114521 payment_time : 124824 payment_date : 20141226 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.79 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 : p.gautier24 order_id : 4848 customer_email : p.gautier24@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 = "4849" select * from cms_frontusers where identifiant = "l.larquier16" 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 = "4849" select * from cotisations where identifiant = "l.larquier16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135727 payment_means : VISA transmission_date : 20141226125727 payment_time : 135924 payment_date : 20141226 response_code : 00 payment_certificate : 52326fb129c8 authorisation_id : 278142 currency_code : 978 card_number : 4978.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.larquier16 order_id : 4849 customer_email : l.larquier16@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 = "4850" select * from cms_frontusers where identifiant = "m.douerin29" 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 = "4850" select * from cotisations where identifiant = "m.douerin29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145508 payment_means : MASTERCARD transmission_date : 20141226135508 payment_time : 145753 payment_date : 20141226 response_code : 00 payment_certificate : f8095140eb90 authorisation_id : 698552 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 : m.douerin29 order_id : 4850 customer_email : m.douerin29@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 = "4851" select * from cms_frontusers where identifiant = "b.bricaud19" 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 = "4851" select * from cotisations where identifiant = "b.bricaud19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152916 payment_means : MASTERCARD transmission_date : 20141226142916 payment_time : 153321 payment_date : 20141226 response_code : 00 payment_certificate : 6a8f57d5ad28 authorisation_id : 630646 currency_code : 978 card_number : 5132.01 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.bricaud19 order_id : 4851 customer_email : b.bricaud19@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 : 153610 payment_means : VISA transmission_date : 20141226143610 payment_time : 154228 payment_date : 20141226 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.27 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.vermont17 order_id : 4852 customer_email : a.vermont17@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 : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4853" select * from cms_frontusers where identifiant = "v.dailly11" 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 = "4853" select * from cotisations where identifiant = "v.dailly11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154552 payment_means : MASTERCARD transmission_date : 20141226144552 payment_time : 162700 payment_date : 20141226 response_code : 00 payment_certificate : 47ec84021c86 authorisation_id : 234243 currency_code : 978 card_number : 5132.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 : v.dailly11 order_id : 4853 customer_email : v.dailly11@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 = "4855" select * from cms_frontusers where identifiant = "j.levain18" 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 = "4855" select * from cotisations where identifiant = "j.levain18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170517 payment_means : VISA transmission_date : 20141226160517 payment_time : 170703 payment_date : 20141226 response_code : 00 payment_certificate : 823bd448341a authorisation_id : 263424 currency_code : 978 card_number : 4977.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.levain18 order_id : 4855 customer_email : j.levain18@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 = "4856" select * from cms_frontusers where identifiant = "d.chautard08" 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 = "4856" select * from cotisations where identifiant = "d.chautard08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183826 payment_means : VISA transmission_date : 20141226173826 payment_time : 184308 payment_date : 20141226 response_code : 00 payment_certificate : c37f6568e407 authorisation_id : 589634 currency_code : 978 card_number : 4970.08 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.chautard08 order_id : 4856 customer_email : d.chautard08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193443 payment_means : MASTERCARD transmission_date : 20141226183443 payment_time : 193730 payment_date : 20141226 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.79 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 : p.gautier24 order_id : 4857 customer_email : p.gautier24@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 = "4857" select * from cms_frontusers where identifiant = "p.gautier24" 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 = "4857" select * from cotisations where identifiant = "p.gautier24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193832 payment_means : MASTERCARD transmission_date : 20141226183832 payment_time : 193948 payment_date : 20141226 response_code : 00 payment_certificate : ba367cf3cf96 authorisation_id : 471434 currency_code : 978 card_number : 5137.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 : p.gautier24 order_id : 4857 customer_email : p.gautier24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4858" select * from cms_frontusers where identifiant = "l.budka29" 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 = "4858" select * from cotisations where identifiant = "l.budka29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201415 payment_means : VISA transmission_date : 20141226191415 payment_time : 201629 payment_date : 20141226 response_code : 00 payment_certificate : bbbd3811e4cc authorisation_id : 463355 currency_code : 978 card_number : 4978.07 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.budka29 order_id : 4858 customer_email : l.budka29@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 : -------------------------------------------