Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083408 payment_means : MASTERCARD transmission_date : 20141211073408 payment_time : 083756 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.35 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.chiarami18 order_id : 4151 customer_email : l.chiarami18@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 : 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 : 083802 payment_means : MASTERCARD transmission_date : 20141211073802 payment_time : 084017 payment_date : 20141211 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.59 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.chiarami18 order_id : 4151 customer_email : l.chiarami18@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 : ------------------------------------------- select * from cotisations_commande where id = "4151" select * from cms_frontusers where identifiant = "l.chiarami18" 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 = "4151" select * from cotisations where identifiant = "l.chiarami18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084033 payment_means : MASTERCARD transmission_date : 20141211074033 payment_time : 084513 payment_date : 20141211 response_code : 00 payment_certificate : 371b2af311f8 authorisation_id : 366415 currency_code : 978 card_number : 5132.03 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.chiarami18 order_id : 4151 customer_email : l.chiarami18@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 = "4153" select * from cms_frontusers where identifiant = "r.houdussepicard21" 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 = "4153" select * from cotisations where identifiant = "r.houdussepicard21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100458 payment_means : VISA transmission_date : 20141211090458 payment_time : 100623 payment_date : 20141211 response_code : 00 payment_certificate : df42275f41cf authorisation_id : 130965 currency_code : 978 card_number : 4975.58 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.houdussepicard21 order_id : 4153 customer_email : r.houdussepicard21@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 = "4152" select * from cms_frontusers where identifiant = "s.mollard13" 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 = "4152" select * from cotisations where identifiant = "a.gabard28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 100323 payment_means : MASTERCARD transmission_date : 20141211090323 payment_time : 100659 payment_date : 20141211 response_code : 00 payment_certificate : fb61adae2374 authorisation_id : 605530 currency_code : 978 card_number : 5131.65 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.mollard13 order_id : 4152 customer_email : s.mollard13@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 = "4154" select * from cms_frontusers where identifiant = "s.mollard13" 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 = "4154" select * from cotisations where identifiant = "n.giroud05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104609 payment_means : MASTERCARD transmission_date : 20141211094609 payment_time : 104830 payment_date : 20141211 response_code : 00 payment_certificate : 3c89c94f9266 authorisation_id : 414843 currency_code : 978 card_number : 5131.65 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.mollard13 order_id : 4154 customer_email : s.mollard13@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 = "4155" select * from cms_frontusers where identifiant = "s.mollard13" 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 = "4155" select * from cotisations where identifiant = "a.donny13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 105417 payment_means : MASTERCARD transmission_date : 20141211095417 payment_time : 105710 payment_date : 20141211 response_code : 00 payment_certificate : 829501040b26 authorisation_id : 604618 currency_code : 978 card_number : 5131.65 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.mollard13 order_id : 4155 customer_email : s.mollard13@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 = "4156" select * from cms_frontusers where identifiant = "p.houdas02" 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 = "4156" select * from cotisations where identifiant = "p.houdas02" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "p.houdas02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 112008 payment_means : VISA transmission_date : 20141211102008 payment_time : 112200 payment_date : 20141211 response_code : 00 payment_certificate : 1acd698efaac authorisation_id : 115064 currency_code : 978 card_number : 4974.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 : p.houdas02 order_id : 4156 customer_email : p.houdas02@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 : ------------------------------------------- select * from cotisations_commande where id = "4157" select * from cms_frontusers where identifiant = "j.gac05" 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 = "4157" select * from cotisations where identifiant = "j.gac05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124022 payment_means : MASTERCARD transmission_date : 20141211114022 payment_time : 124150 payment_date : 20141211 response_code : 00 payment_certificate : 89beb991844c authorisation_id : 535024 currency_code : 978 card_number : 5132.02 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.gac05 order_id : 4157 customer_email : j.gac05@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 = "4158" select * from cms_frontusers where identifiant = "a.canut19" 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 = "4158" select * from cotisations where identifiant = "a.canut19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124400 payment_means : VISA transmission_date : 20141211114400 payment_time : 124708 payment_date : 20141211 response_code : 00 payment_certificate : 51fc7773b53b authorisation_id : 384220 currency_code : 978 card_number : 4978.51 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.canut19 order_id : 4158 customer_email : a.canut19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4160" select * from cms_frontusers where identifiant = "a.morey28" 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 = "4160" select * from cotisations where identifiant = "a.morey28" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 151814 payment_means : VISA transmission_date : 20141211141814 payment_time : 151944 payment_date : 20141211 response_code : 00 payment_certificate : 7ea0aeb43202 authorisation_id : 216551 currency_code : 978 card_number : 4978.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.morey28 order_id : 4160 customer_email : a.morey28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4161" select * from cms_frontusers where identifiant = "d.jacob24" 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 = "4161" select * from cotisations where identifiant = "d.jacob24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154945 payment_means : VISA transmission_date : 20141211144945 payment_time : 155438 payment_date : 20141211 response_code : 00 payment_certificate : bbfc489e1f3d authorisation_id : 341005 currency_code : 978 card_number : 4972.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 : d.jacob24 order_id : 4161 customer_email : d.jacob24@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 = "4162" select * from cms_frontusers where identifiant = "e.francois01" 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 = "4162" select * from cotisations where identifiant = "j.olivier23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155047 payment_means : VISA transmission_date : 20141211145047 payment_time : 155511 payment_date : 20141211 response_code : 00 payment_certificate : 97a7816bd8cb authorisation_id : 526653 currency_code : 978 card_number : 4972.35 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.francois01 order_id : 4162 customer_email : e.francois01@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 = "4164" select * from cms_frontusers where identifiant = "s.amirault20" 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 = "4164" select * from cotisations where identifiant = "s.amirault20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175546 payment_means : VISA transmission_date : 20141211165546 payment_time : 180006 payment_date : 20141211 response_code : 00 payment_certificate : d3a9b3c960f4 authorisation_id : 491872 currency_code : 978 card_number : 4973.77 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.amirault20 order_id : 4164 customer_email : s.amirault20@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4165" select * from cms_frontusers where identifiant = "c.konecny07" 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 = "4165" select * from cotisations where identifiant = "a.koubbi21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182506 payment_means : VISA transmission_date : 20141211172506 payment_time : 182644 payment_date : 20141211 response_code : 00 payment_certificate : 78d635e4b356 authorisation_id : 143282 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 : c.konecny07 order_id : 4165 customer_email : c.konecny07@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 = "4166" select * from cms_frontusers where identifiant = "l.gric26" 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 = "4166" select * from cotisations where identifiant = "l.gric26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183027 payment_means : VISA transmission_date : 20141211173027 payment_time : 183134 payment_date : 20141211 response_code : 00 payment_certificate : 4550e34ea55c authorisation_id : 118622 currency_code : 978 card_number : 4978.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 : l.gric26 order_id : 4166 customer_email : l.gric26@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 = "4167" 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 = "4167" select * from cotisations where identifiant = "b.haerinck10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183640 payment_means : VISA transmission_date : 20141211173640 payment_time : 183937 payment_date : 20141211 response_code : 00 payment_certificate : f72705dbc61f authorisation_id : 363356 currency_code : 978 card_number : 4978.84 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 : 4167 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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4169" select * from cms_frontusers where identifiant = "b.cravallee01" 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 = "4169" select * from cotisations where identifiant = "j.montaret12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191416 payment_means : VISA transmission_date : 20141211181416 payment_time : 191615 payment_date : 20141211 response_code : 00 payment_certificate : b07fafd5f811 authorisation_id : 322431 currency_code : 978 card_number : 4533.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.cravallee01 order_id : 4169 customer_email : b.cravallee01@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 = "4170" select * from cms_frontusers where identifiant = "b.cravallee01" 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 = "4170" select * from cotisations where identifiant = "g.sabathe01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192030 payment_means : VISA transmission_date : 20141211182030 payment_time : 192151 payment_date : 20141211 response_code : 00 payment_certificate : 1cebff185d84 authorisation_id : 490320 currency_code : 978 card_number : 4533.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.cravallee01 order_id : 4170 customer_email : b.cravallee01@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 = "4168" select * from cms_frontusers where identifiant = "o.barreau10" 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 = "4168" select * from cotisations where identifiant = "d.bourget02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191210 payment_means : MASTERCARD transmission_date : 20141211181210 payment_time : 192202 payment_date : 20141211 response_code : 00 payment_certificate : 97904016f894 authorisation_id : 353574 currency_code : 978 card_number : 5138.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : o.barreau10 order_id : 4168 customer_email : o.barreau10@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 = "4171" select * from cms_frontusers where identifiant = "o.barreau10" 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 = "4171" select * from cotisations where identifiant = "f.guery10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193103 payment_means : VISA transmission_date : 20141211183103 payment_time : 193321 payment_date : 20141211 response_code : 00 payment_certificate : f0e8e0381f31 authorisation_id : 822623 currency_code : 978 card_number : 4970.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 : o.barreau10 order_id : 4171 customer_email : o.barreau10@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 = "4174" select * from cms_frontusers where identifiant = "a.riegel05" 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 = "4174" select * from cotisations where identifiant = "a.riegel05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200726 payment_means : MASTERCARD transmission_date : 20141211190726 payment_time : 200916 payment_date : 20141211 response_code : 00 payment_certificate : 30b38944c875 authorisation_id : 619642 currency_code : 978 card_number : 5132.75 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.riegel05 order_id : 4174 customer_email : a.riegel05@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 = "4173" select * from cms_frontusers where identifiant = "b.farcy07" 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 = "4173" select * from cotisations where identifiant = "p.cimper04" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200554 payment_means : VISA transmission_date : 20141211190554 payment_time : 201103 payment_date : 20141211 response_code : 00 payment_certificate : 489877b7f4ae authorisation_id : 131523 currency_code : 978 card_number : 4974.02 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.farcy07 order_id : 4173 customer_email : b.farcy07@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 = "4179" select * from cms_frontusers where identifiant = "a.buret15" 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 = "4179" select * from cotisations where identifiant = "a.buret15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202250 payment_means : MASTERCARD transmission_date : 20141211192250 payment_time : 202415 payment_date : 20141211 response_code : 00 payment_certificate : de20117524a1 authorisation_id : 568411 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 : a.buret15 order_id : 4179 customer_email : a.buret15@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 = "4177" select * from cms_frontusers where identifiant = "l.cordreaux30" 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 = "4177" select * from cotisations where identifiant = "l.cordreaux30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201912 payment_means : MASTERCARD transmission_date : 20141211191912 payment_time : 202610 payment_date : 20141211 response_code : 00 payment_certificate : 173b09defe24 authorisation_id : 838111 currency_code : 978 card_number : 5341.40 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.cordreaux30 order_id : 4177 customer_email : l.cordreaux30@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 : 202650 payment_means : VISA transmission_date : 20141211192650 payment_time : 192758 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.langlois09 order_id : 4182 customer_email : n.langlois09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : 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 : 202647 payment_means : MASTERCARD transmission_date : 20141211192647 payment_time : 202819 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.72 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 : f.scossabaggi30 order_id : 4181 customer_email : f.scossabaggi30@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4180" select * from cms_frontusers where identifiant = "v.guerin07" 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 = "4180" select * from cotisations where identifiant = "v.guerin07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202323 payment_means : VISA transmission_date : 20141211192323 payment_time : 202857 payment_date : 20141211 response_code : 00 payment_certificate : e004759f922b authorisation_id : 539331 currency_code : 978 card_number : 4974.06 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.guerin07 order_id : 4180 customer_email : v.guerin07@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201939 payment_means : VISA transmission_date : 20141211191939 payment_time : 202910 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.92 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 : j.renard11 order_id : 4178 customer_email : j.renard11@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 : 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 : 202826 payment_means : MASTERCARD transmission_date : 20141211192826 payment_time : 202916 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.72 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 : f.scossabaggi30 order_id : 4181 customer_email : f.scossabaggi30@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4183" select * from cms_frontusers where identifiant = "n.cure02" 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 = "4183" select * from cotisations where identifiant = "n.cure02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203206 payment_means : VISA transmission_date : 20141211193206 payment_time : 203338 payment_date : 20141211 response_code : 00 payment_certificate : dec397532e3f authorisation_id : 437562 currency_code : 978 card_number : 4978.99 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.cure02 order_id : 4183 customer_email : n.cure02@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203807 payment_means : MASTERCARD transmission_date : 20141211193807 payment_time : 203855 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.72 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 : f.scossabaggi30 order_id : 4181 customer_email : f.scossabaggi30@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4185" select * from cms_frontusers where identifiant = "g.junier01" 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 = "4185" select * from cotisations where identifiant = "g.junier01" and annee = "2015" and montant <> 0 select * from cotisations_commande where id = "4186" select * from cms_frontusers where identifiant = "u.picado20" 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 = "4186" select * from cotisations where identifiant = "u.picado20" and annee = "2014" and montant <> 0 code : 0 code : 0 error : error : merchant_id : 077566202600019 merchant_id : 077566202600019 merchant_country : fr merchant_country : fr amount : 4000 amount : 4000 transaction_id : 203852 transaction_id : 203831 payment_means : VISA payment_means : MASTERCARD transmission_date : 20141211193852 transmission_date : 20141211193831 payment_time : 204259 payment_time : 204024 payment_date : 20141211 payment_date : 20141211 response_code : 00 response_code : 00 payment_certificate : e91aebff48ee payment_certificate : 199a6255e901 authorisation_id : 431212 authorisation_id : 774471 currency_code : 978 currency_code : 978 card_number : 4978.17 card_number : 5131.97 cvv_flag : 1 cvv_flag : 1 cvv_response_code : ?? cvv_response_code : ?? bank_response_code : 00 bank_response_code : 00 complementary_code : 00 complementary_code : 00 complementary_info : complementary_info : return_context : return_context : caddie : caddie : receipt_complement : receipt_complement : merchant_language : fr merchant_language : fr language : fr language : fr customer_id : u.picado20 customer_id : g.junier01 order_id : 4186 order_id : 4185 customer_email : u.picado20@compagnons-du-devoir.fr customer_email : g.junier01@compagnons-du-devoir.fr customer_ip_address : customer_ip_address : capture_day : 0 capture_day : 0 capture_mode : AUTHOR_CAPTURE capture_mode : AUTHOR_CAPTURE data : data : order_validity : 02 order_validity : 02 transaction_condition : 3D_SUCCESS transaction_condition : 3D_SUCCESS statement_reference : statement_reference : card_validity : 201603 card_validity : 201501 score_value : score_value : score_color : score_color : score_info : score_info : score_threshold : score_threshold : score_profile : score_profile : ------------------------------------------- ------------------------------------------- select * from cotisations_commande where id = "4188" 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 = "4188" select * from cotisations where identifiant = "d.vincent28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205335 payment_means : VISA transmission_date : 20141211195335 payment_time : 205635 payment_date : 20141211 response_code : 00 payment_certificate : 1ed0a33ab0ff authorisation_id : 907863 currency_code : 978 card_number : 4150.35 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 : 4188 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 : 201503 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4193" select * from cms_frontusers where identifiant = "m.einrick21" 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 = "4193" select * from cotisations where identifiant = "m.einrick21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210637 payment_means : VISA transmission_date : 20141211200637 payment_time : 210813 payment_date : 20141211 response_code : 00 payment_certificate : d42fde8fc00b authorisation_id : 035673 currency_code : 978 card_number : 4970.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.einrick21 order_id : 4193 customer_email : m.einrick21@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 = "4195" select * from cms_frontusers where identifiant = "l.fave03" 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 = "4195" select * from cotisations where identifiant = "b.favier10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210721 payment_means : VISA transmission_date : 20141211200721 payment_time : 210836 payment_date : 20141211 response_code : 00 payment_certificate : 2451a66192c2 authorisation_id : 695641 currency_code : 978 card_number : 4973.27 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.fave03 order_id : 4195 customer_email : l.fave03@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 = "4198" select * from cms_frontusers where identifiant = "p.kitsos27" 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 = "4198" select * from cotisations where identifiant = "p.kitsos27" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210822 payment_means : MASTERCARD transmission_date : 20141211200822 payment_time : 211014 payment_date : 20141211 response_code : 00 payment_certificate : 40ec52163919 authorisation_id : 435843 currency_code : 978 card_number : 5131.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 : p.kitsos27 order_id : 4198 customer_email : p.kitsos27@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 = "4200" select * from cms_frontusers where identifiant = "l.cattaneo30" 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 = "4200" select * from cotisations where identifiant = "l.cattaneo30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210918 payment_means : MASTERCARD transmission_date : 20141211200918 payment_time : 211132 payment_date : 20141211 response_code : 00 payment_certificate : 1584bd1b7b58 authorisation_id : 826424 currency_code : 978 card_number : 5341.84 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.cattaneo30 order_id : 4200 customer_email : l.cattaneo30@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 = "4197" select * from cms_frontusers where identifiant = "j.moinard17" 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 = "4197" select * from cotisations where identifiant = "j.moinard17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210756 payment_means : VISA transmission_date : 20141211200756 payment_time : 211222 payment_date : 20141211 response_code : 00 payment_certificate : ab2c322c90ee authorisation_id : 146334 currency_code : 978 card_number : 4977.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 : j.moinard17 order_id : 4197 customer_email : j.moinard17@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 = "4190" select * from cms_frontusers where identifiant = "l.guenier30" 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 = "4190" select * from cotisations where identifiant = "l.guenier30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210609 payment_means : MASTERCARD transmission_date : 20141211200609 payment_time : 211240 payment_date : 20141211 response_code : 00 payment_certificate : 5280938788da authorisation_id : 566213 currency_code : 978 card_number : 5131.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 : l.guenier30 order_id : 4190 customer_email : l.guenier30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4201" select * from cms_frontusers where identifiant = "h.menard08" 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 = "4201" select * from cotisations where identifiant = "h.menard08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211308 payment_means : MASTERCARD transmission_date : 20141211201308 payment_time : 211514 payment_date : 20141211 response_code : 00 payment_certificate : f956cedd7fd3 authorisation_id : 541111 currency_code : 978 card_number : 5131.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 : h.menard08 order_id : 4201 customer_email : h.menard08@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 = "4204" select * from cms_frontusers where identifiant = "o.gueneu09" 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 = "4204" select * from cotisations where identifiant = "o.gueneu09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211407 payment_means : VISA transmission_date : 20141211201407 payment_time : 211534 payment_date : 20141211 response_code : 00 payment_certificate : 047de98cefd6 authorisation_id : 661212 currency_code : 978 card_number : 4978.28 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.gueneu09 order_id : 4204 customer_email : o.gueneu09@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4203" select * from cms_frontusers where identifiant = "b.nivoix23" 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 = "4203" select * from cotisations where identifiant = "b.nivoix23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211335 payment_means : VISA transmission_date : 20141211201335 payment_time : 211828 payment_date : 20141211 response_code : 00 payment_certificate : fb56e8087ff0 authorisation_id : 841954 currency_code : 978 card_number : 4970.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 : b.nivoix23 order_id : 4203 customer_email : b.nivoix23@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 = "4205" select * from cms_frontusers where identifiant = "y.provost07" 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 = "4205" select * from cotisations where identifiant = "y.provost07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211745 payment_means : MASTERCARD transmission_date : 20141211201745 payment_time : 211942 payment_date : 20141211 response_code : 00 payment_certificate : 3268ced11c4f authorisation_id : 431232 currency_code : 978 card_number : 5137.03 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.provost07 order_id : 4205 customer_email : y.provost07@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 = "4206" select * from cms_frontusers where identifiant = "y.picard26" 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 = "4206" select * from cotisations where identifiant = "y.picard26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211911 payment_means : VISA transmission_date : 20141211201911 payment_time : 212144 payment_date : 20141211 response_code : 00 payment_certificate : f8d4c806b0fe authorisation_id : 337439 currency_code : 978 card_number : 4973.72 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.picard26 order_id : 4206 customer_email : y.picard26@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 = "4207" select * from cms_frontusers where identifiant = "m.polomski15" 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 = "4207" select * from cotisations where identifiant = "m.polomski15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212159 payment_means : VISA transmission_date : 20141211202159 payment_time : 212327 payment_date : 20141211 response_code : 00 payment_certificate : 4d25cf193557 authorisation_id : 520411 currency_code : 978 card_number : 4562.35 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.polomski15 order_id : 4207 customer_email : m.polomski15@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 = "4208" select * from cms_frontusers where identifiant = "c.montagny21" 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 = "4208" select * from cotisations where identifiant = "c.montagny21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212202 payment_means : VISA transmission_date : 20141211202202 payment_time : 212400 payment_date : 20141211 response_code : 00 payment_certificate : cfacb308781f authorisation_id : 213714 currency_code : 978 card_number : 4970.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 : c.montagny21 order_id : 4208 customer_email : c.montagny21@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 = "4209" select * from cms_frontusers where identifiant = "mo.adam03" 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 = "4209" select * from cotisations where identifiant = "mo.adam03" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212334 payment_means : VISA transmission_date : 20141211202334 payment_time : 212526 payment_date : 20141211 response_code : 00 payment_certificate : 4a07336cb268 authorisation_id : 117947 currency_code : 978 card_number : 4562.47 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 : mo.adam03 order_id : 4209 customer_email : mo.adam03@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 = "4210" select * from cms_frontusers where identifiant = "r.lartillot11" 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 = "4210" select * from cotisations where identifiant = "r.lartillot11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212514 payment_means : MASTERCARD transmission_date : 20141211202514 payment_time : 212627 payment_date : 20141211 response_code : 00 payment_certificate : 6c635e369354 authorisation_id : 083395 currency_code : 978 card_number : 5136.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 : r.lartillot11 order_id : 4210 customer_email : r.lartillot11@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 = "4213" select * from cms_frontusers where identifiant = "mo.adam03" 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 = "4213" select * from cotisations where identifiant = "mo.adam03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212624 payment_means : VISA transmission_date : 20141211202624 payment_time : 212734 payment_date : 20141211 response_code : 00 payment_certificate : 2e37259c591b authorisation_id : 067350 currency_code : 978 card_number : 4562.47 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 : mo.adam03 order_id : 4213 customer_email : mo.adam03@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 = "4211" select * from cms_frontusers where identifiant = "v.marnay19" 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 = "4211" select * from cotisations where identifiant = "v.marnay19" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212607 payment_means : VISA transmission_date : 20141211202607 payment_time : 212812 payment_date : 20141211 response_code : 00 payment_certificate : d341a831c9e8 authorisation_id : 542719 currency_code : 978 card_number : 4978.22 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.marnay19 order_id : 4211 customer_email : v.marnay19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213113 payment_means : MASTERCARD transmission_date : 20141211203113 payment_time : 213248 payment_date : 20141211 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5136.90 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 : ph.dumontet17 order_id : 4217 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 : 201609 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 : 212610 payment_means : VISA transmission_date : 20141211202610 payment_time : 213435 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.schaefer19 order_id : 4212 customer_email : r.schaefer19@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 : 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 : 213448 payment_means : VISA transmission_date : 20141211203448 payment_time : 213804 payment_date : 20141211 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.schaefer19 order_id : 4212 customer_email : r.schaefer19@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4218" select * from cms_frontusers where identifiant = "l.muller19" 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 = "4218" select * from cotisations where identifiant = "l.muller19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213636 payment_means : VISA transmission_date : 20141211203636 payment_time : 213820 payment_date : 20141211 response_code : 00 payment_certificate : a5cac3147fb4 authorisation_id : 633142 currency_code : 978 card_number : 4975.28 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.muller19 order_id : 4218 customer_email : l.muller19@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 = "4220" select * from cms_frontusers where identifiant = "q.poreba01" 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 = "4220" select * from cotisations where identifiant = "q.poreba01" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "q.poreba01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213839 payment_means : VISA transmission_date : 20141211203839 payment_time : 213938 payment_date : 20141211 response_code : 00 payment_certificate : 039d19622f14 authorisation_id : 495845 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 : q.poreba01 order_id : 4220 customer_email : q.poreba01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4219" select * from cms_frontusers where identifiant = "f.talbot22" 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 = "4219" select * from cotisations where identifiant = "f.talbot22" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213708 payment_means : VISA transmission_date : 20141211203708 payment_time : 214041 payment_date : 20141211 response_code : 00 payment_certificate : 87ad7324dc34 authorisation_id : 929076 currency_code : 978 card_number : 4978.32 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.talbot22 order_id : 4219 customer_email : f.talbot22@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 = "4221" select * from cms_frontusers where identifiant = "ma.urena24" 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 = "4221" select * from cotisations where identifiant = "ma.urena24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214735 payment_means : VISA transmission_date : 20141211204735 payment_time : 214917 payment_date : 20141211 response_code : 00 payment_certificate : 53cec7631dcf authorisation_id : 421944 currency_code : 978 card_number : 4978.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : ma.urena24 order_id : 4221 customer_email : ma.urena24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4222" select * from cms_frontusers where identifiant = "l.geraud15" 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 = "4222" select * from cotisations where identifiant = "l.geraud15" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "l.geraud15" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214824 payment_means : MASTERCARD transmission_date : 20141211204824 payment_time : 215106 payment_date : 20141211 response_code : 00 payment_certificate : 4f8d37c6bc93 authorisation_id : 544456 currency_code : 978 card_number : 5131.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.geraud15 order_id : 4222 customer_email : l.geraud15@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 : ------------------------------------------- select * from cotisations_commande where id = "4223" select * from cms_frontusers where identifiant = "v.millasseau02" 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 = "4223" select * from cotisations where identifiant = "v.millasseau02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215502 payment_means : MASTERCARD transmission_date : 20141211205502 payment_time : 215756 payment_date : 20141211 response_code : 00 payment_certificate : 9e6609cf0696 authorisation_id : 926300 currency_code : 978 card_number : 5341.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 : v.millasseau02 order_id : 4223 customer_email : v.millasseau02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "4224" select * from cms_frontusers where identifiant = "i.dembele26" 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 = "4224" select * from cotisations where identifiant = "i.dembele26" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221339 payment_means : VISA transmission_date : 20141211211339 payment_time : 221504 payment_date : 20141211 response_code : 00 payment_certificate : 524f35797594 authorisation_id : 058597 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 : i.dembele26 order_id : 4224 customer_email : i.dembele26@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 = "4225" select * from cms_frontusers where identifiant = "c.lucier10" 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 = "4225" select * from cotisations where identifiant = "c.lucier10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222048 payment_means : MASTERCARD transmission_date : 20141211212048 payment_time : 222258 payment_date : 20141211 response_code : 00 payment_certificate : f3ca0a49a557 authorisation_id : 822461 currency_code : 978 card_number : 5341.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 : c.lucier10 order_id : 4225 customer_email : c.lucier10@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 = "4226" select * from cms_frontusers where identifiant = "y.soullard20" 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 = "4226" select * from cotisations where identifiant = "y.soullard20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222659 payment_means : MASTERCARD transmission_date : 20141211212659 payment_time : 222938 payment_date : 20141211 response_code : 00 payment_certificate : 2b40ed66ef53 authorisation_id : 363342 currency_code : 978 card_number : 5132.87 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.soullard20 order_id : 4226 customer_email : y.soullard20@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 : -------------------------------------------