select * from cotisations_commande where id = "12387" select * from cms_frontusers where identifiant = "a.baguet12" 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 = "12387" select * from cotisations where identifiant = "p.bagouin24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 080720 payment_means : MASTERCARD transmission_date : 20160109070720 payment_time : 080928 payment_date : 20160109 response_code : 00 payment_certificate : 2f85c8b234b5 authorisation_id : 371136 currency_code : 978 card_number : 5131.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 : a.baguet12 order_id : 12387 customer_email : a.baguet12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12388" select * from cms_frontusers where identifiant = "t.millon05" 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 = "12388" select * from cotisations where identifiant = "t.millon05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081119 payment_means : MASTERCARD transmission_date : 20160109071119 payment_time : 081424 payment_date : 20160109 response_code : 00 payment_certificate : 3d0163ec65bf authorisation_id : 854593 currency_code : 978 card_number : 5136.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 : t.millon05 order_id : 12388 customer_email : t.millon05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12389" select * from cms_frontusers where identifiant = "q.heitz20" 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 = "12389" select * from cotisations where identifiant = "q.heitz20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 081338 payment_means : VISA transmission_date : 20160109071338 payment_time : 081559 payment_date : 20160109 response_code : 00 payment_certificate : 272ce4e5df96 authorisation_id : 280054 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 : q.heitz20 order_id : 12389 customer_email : q.heitz20@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 = "12390" select * from cms_frontusers where identifiant = "a1.clement20" 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 = "12390" select * from cotisations where identifiant = "a1.clement20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 081604 payment_means : MASTERCARD transmission_date : 20160109071604 payment_time : 081723 payment_date : 20160109 response_code : 00 payment_certificate : b2cf1659f1ca authorisation_id : 637636 currency_code : 978 card_number : 5136.66 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 : a1.clement20 order_id : 12390 customer_email : a1.clement20@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 = "12391" select * from cms_frontusers where identifiant = "k.molinatti31" 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 = "12391" select * from cotisations where identifiant = "k.molinatti31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 082445 payment_means : MASTERCARD transmission_date : 20160109072445 payment_time : 082616 payment_date : 20160109 response_code : 00 payment_certificate : fdeb7b313a01 authorisation_id : 632603 currency_code : 978 card_number : 5131.60 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 : k.molinatti31 order_id : 12391 customer_email : k.molinatti31@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 = "12392" select * from cms_frontusers where identifiant = "m.solylo11" 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 = "12392" select * from cotisations where identifiant = "m.solylo11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083101 payment_means : VISA transmission_date : 20160109073101 payment_time : 083242 payment_date : 20160109 response_code : 00 payment_certificate : 827f1b4be034 authorisation_id : 326792 currency_code : 978 card_number : 4974.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 : m.solylo11 order_id : 12392 customer_email : m.solylo11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12393" select * from cms_frontusers where identifiant = "m.solylo11" select * from cotisations_commande where id = "12395" select * from cms_frontusers where identifiant = "m.napieracz26" 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 = "12393" 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 = "12395" select * from cotisations where identifiant = "m.solylo11" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.napieracz26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083558 payment_means : VISA transmission_date : 20160109073558 payment_time : 083735 payment_date : 20160109 response_code : 00 payment_certificate : d3792dbdfce8 authorisation_id : 945385 currency_code : 978 card_number : 4974.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 : m.solylo11 order_id : 12393 customer_email : m.solylo11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083649 payment_means : MASTERCARD transmission_date : 20160109073649 payment_time : 083905 payment_date : 20160109 response_code : 00 payment_certificate : cb55add5794d authorisation_id : 523213 currency_code : 978 card_number : 5131.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.napieracz26 order_id : 12395 customer_email : m.napieracz26@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 = "12396" select * from cms_frontusers where identifiant = "g.bertrand02" 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 = "12396" select * from cotisations where identifiant = "g.bertrand02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 084044 payment_means : VISA transmission_date : 20160109074044 payment_time : 084316 payment_date : 20160109 response_code : 00 payment_certificate : efdbfcd18d3e authorisation_id : 221844 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 : g.bertrand02 order_id : 12396 customer_email : g.bertrand02@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 : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12397" select * from cms_frontusers where identifiant = "c.gachon19" 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 = "12397" select * from cotisations where identifiant = "c.gachon19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 084143 payment_means : VISA transmission_date : 20160109074143 payment_time : 084539 payment_date : 20160109 response_code : 00 payment_certificate : b3547b3d3901 authorisation_id : 247418 currency_code : 978 card_number : 4975.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.gachon19 order_id : 12397 customer_email : c.gachon19@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 = "12399" select * from cms_frontusers where identifiant = "p.warot25" 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 = "12399" select * from cotisations where identifiant = "p.warot25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084751 payment_means : VISA transmission_date : 20160109074751 payment_time : 085102 payment_date : 20160109 response_code : 00 payment_certificate : eaab37320a46 authorisation_id : 772561 currency_code : 978 card_number : 4970.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.warot25 order_id : 12399 customer_email : p.warot25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12400" select * from cms_frontusers where identifiant = "j.daems04" 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 = "12400" select * from cotisations where identifiant = "j.daems04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 084925 payment_means : VISA transmission_date : 20160109074925 payment_time : 085117 payment_date : 20160109 response_code : 00 payment_certificate : af4e4b0bb65c authorisation_id : 058374 currency_code : 978 card_number : 4978.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 : j.daems04 order_id : 12400 customer_email : j.daems04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12402" select * from cms_frontusers where identifiant = "c.dufour01" 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 = "12402" select * from cotisations where identifiant = "c.dufour01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085420 payment_means : VISA transmission_date : 20160109075420 payment_time : 085541 payment_date : 20160109 response_code : 00 payment_certificate : 0aebffa6ae92 authorisation_id : 399447 currency_code : 978 card_number : 4975.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 : c.dufour01 order_id : 12402 customer_email : c.dufour01@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 = "12401" select * from cms_frontusers where identifiant = "y.bordaries11" 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 = "12401" select * from cotisations where identifiant = "y.bordaries11" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "jy.piton23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 085351 payment_means : MASTERCARD transmission_date : 20160109075351 payment_time : 085605 payment_date : 20160109 response_code : 00 payment_certificate : f103c1e553d8 authorisation_id : 814326 currency_code : 978 card_number : 5131.04 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.bordaries11 order_id : 12401 customer_email : y.bordaries11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12403" select * from cms_frontusers where identifiant = "d.bourgoin25" 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 = "12403" select * from cotisations where identifiant = "d.bourgoin25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085724 payment_means : MASTERCARD transmission_date : 20160109075724 payment_time : 090017 payment_date : 20160109 response_code : 00 payment_certificate : abe7e384e13f authorisation_id : 653316 currency_code : 978 card_number : 5135.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 : d.bourgoin25 order_id : 12403 customer_email : d.bourgoin25@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 = "12404" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "12404" select * from cotisations where identifiant = "p.barege27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090608 payment_means : VISA transmission_date : 20160109080608 payment_time : 090729 payment_date : 20160109 response_code : 00 payment_certificate : 02bfb4080cfc authorisation_id : 113219 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 : d.cordier16 order_id : 12404 customer_email : d.cordier16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12406" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "12406" select * from cotisations where identifiant = "n.aigouy24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090825 payment_means : VISA transmission_date : 20160109080825 payment_time : 090943 payment_date : 20160109 response_code : 00 payment_certificate : d7deb2f69bd0 authorisation_id : 761192 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 : d.cordier16 order_id : 12406 customer_email : d.cordier16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090609 payment_means : MASTERCARD transmission_date : 20160109080609 payment_time : 091211 payment_date : 20160109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.15 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.linot29 order_id : 12405 customer_email : j.linot29@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12408" select * from cms_frontusers where identifiant = "e.brondel05" 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 = "12408" select * from cotisations where identifiant = "e.brondel05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095327 payment_means : VISA transmission_date : 20160109085327 payment_time : 095533 payment_date : 20160109 response_code : 00 payment_certificate : 3b1e602af6a2 authorisation_id : 445332 currency_code : 978 card_number : 4970.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.brondel05 order_id : 12408 customer_email : e.brondel05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12410" select * from cms_frontusers where identifiant = "q.scherer01" 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 = "12410" select * from cotisations where identifiant = "q.scherer01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 100609 payment_means : MASTERCARD transmission_date : 20160109090609 payment_time : 100742 payment_date : 20160109 response_code : 00 payment_certificate : f8698fe84d38 authorisation_id : 528208 currency_code : 978 card_number : 5131.24 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.scherer01 order_id : 12410 customer_email : q.scherer01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12411" select * from cms_frontusers where identifiant = "e.brondel05" 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 = "12411" select * from cotisations where identifiant = "e.soilly15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100745 payment_means : VISA transmission_date : 20160109090745 payment_time : 100925 payment_date : 20160109 response_code : 00 payment_certificate : 14d8f37f0d41 authorisation_id : 296131 currency_code : 978 card_number : 4970.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.brondel05 order_id : 12411 customer_email : e.brondel05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12413" select * from cms_frontusers where identifiant = "jh.couvreur05" 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 = "12413" select * from cotisations where identifiant = "jh.couvreur05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 101208 payment_means : MASTERCARD transmission_date : 20160109091208 payment_time : 101402 payment_date : 20160109 response_code : 00 payment_certificate : aaa08e84b102 authorisation_id : 536356 currency_code : 978 card_number : 5136.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jh.couvreur05 order_id : 12413 customer_email : jh.couvreur05@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 = "12417" select * from cms_frontusers where identifiant = "a.dupire27" 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 = "12417" select * from cotisations where identifiant = "a.dupire27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 103054 payment_means : MASTERCARD transmission_date : 20160109093054 payment_time : 103231 payment_date : 20160109 response_code : 00 payment_certificate : a7b79db05b64 authorisation_id : 645461 currency_code : 978 card_number : 5131.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 : a.dupire27 order_id : 12417 customer_email : a.dupire27@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 = "12419" select * from cms_frontusers where identifiant = "g.bailly05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "12419" select * from cotisations where identifiant = "r.nicole29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103249 payment_means : VISA transmission_date : 20160109093249 payment_time : 103430 payment_date : 20160109 response_code : 00 payment_certificate : 1222aee295f6 authorisation_id : 175064 currency_code : 978 card_number : 4978.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.bailly05 order_id : 12419 customer_email : g.bailly05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12420" select * from cms_frontusers where identifiant = "v.elleouet12" 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 = "12420" select * from cotisations where identifiant = "v.elleouet12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104137 payment_means : VISA transmission_date : 20160109094137 payment_time : 104324 payment_date : 20160109 response_code : 00 payment_certificate : 2cdd54b8b50d authorisation_id : 963711 currency_code : 978 card_number : 4976.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 : v.elleouet12 order_id : 12420 customer_email : v.elleouet12@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 = "12421" select * from cms_frontusers where identifiant = "c.moreau19" 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 = "12421" select * from cotisations where identifiant = "b.rossetto07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104512 payment_means : MASTERCARD transmission_date : 20160109094512 payment_time : 104729 payment_date : 20160109 response_code : 00 payment_certificate : 93c544530f79 authorisation_id : 667202 currency_code : 978 card_number : 5135.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 : c.moreau19 order_id : 12421 customer_email : c.moreau19@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12423" select * from cms_frontusers where identifiant = "s.bayol12" 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 = "12423" select * from cotisations where identifiant = "s.bayol12" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "s.bayol12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105629 payment_means : VISA transmission_date : 20160109095629 payment_time : 105841 payment_date : 20160109 response_code : 00 payment_certificate : 4a7c27d0c502 authorisation_id : 141780 currency_code : 978 card_number : 4978.76 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.bayol12 order_id : 12423 customer_email : s.bayol12@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 = "12422" select * from cms_frontusers where identifiant = "j.wilson01" 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 = "12422" select * from cotisations where identifiant = "j.wilson01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104806 payment_means : MASTERCARD transmission_date : 20160109094806 payment_time : 115555 payment_date : 20160109 response_code : 00 payment_certificate : ffa4ca67d46c authorisation_id : 210572 currency_code : 978 card_number : 5132.24 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.wilson01 order_id : 12422 customer_email : j.wilson01@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 = "12426" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12426" select * from cotisations where identifiant = "f.pasquier19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125544 payment_means : MASTERCARD transmission_date : 20160109115544 payment_time : 125726 payment_date : 20160109 response_code : 00 payment_certificate : 7a3c160d1a5b authorisation_id : 521438 currency_code : 978 card_number : 5138.70 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.laroche03 order_id : 12426 customer_email : c.laroche03@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 = "12427" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12427" select * from cotisations where identifiant = "f.pasquier19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125810 payment_means : MASTERCARD transmission_date : 20160109115810 payment_time : 125922 payment_date : 20160109 response_code : 00 payment_certificate : b00bbbda0577 authorisation_id : 911576 currency_code : 978 card_number : 5138.70 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.laroche03 order_id : 12427 customer_email : c.laroche03@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 = "12428" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12428" select * from cotisations where identifiant = "d.rochereau30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130008 payment_means : CB transmission_date : 20160109120008 payment_time : 130055 payment_date : 20160109 response_code : 00 payment_certificate : 3128fdc86aa6 authorisation_id : 966233 currency_code : 978 card_number : 4977.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.laroche03 order_id : 12428 customer_email : c.laroche03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR 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 : 130148 payment_means : VISA transmission_date : 20160109120148 payment_time : 130249 payment_date : 20160109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.24 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 : c.laroche03 order_id : 12429 customer_email : c.laroche03@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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12429" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12429" select * from cotisations where identifiant = "m.gutierrez30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130259 payment_means : VISA transmission_date : 20160109120259 payment_time : 130407 payment_date : 20160109 response_code : 00 payment_certificate : 5702ec80b47a authorisation_id : 695637 currency_code : 978 card_number : 4533.24 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.laroche03 order_id : 12429 customer_email : c.laroche03@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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12430" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12430" select * from cotisations where identifiant = "s.thiery26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130435 payment_means : VISA transmission_date : 20160109120435 payment_time : 130608 payment_date : 20160109 response_code : 00 payment_certificate : 0cf42817bfb6 authorisation_id : 466347 currency_code : 978 card_number : 4973.90 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.laroche03 order_id : 12430 customer_email : c.laroche03@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 = "12431" select * from cms_frontusers where identifiant = "j.knopf29" 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 = "12431" select * from cotisations where identifiant = "j.knopf29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130617 payment_means : MASTERCARD transmission_date : 20160109120617 payment_time : 130738 payment_date : 20160109 response_code : 00 payment_certificate : 9247108f1e70 authorisation_id : 145141 currency_code : 978 card_number : 5132.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.knopf29 order_id : 12431 customer_email : j.knopf29@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 = "12432" select * from cms_frontusers where identifiant = "c.laroche03" 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 = "12432" select * from cotisations where identifiant = "jm.avezard21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130807 payment_means : VISA transmission_date : 20160109120807 payment_time : 130938 payment_date : 20160109 response_code : 00 payment_certificate : b4c317f7c04a authorisation_id : 426767 currency_code : 978 card_number : 4976.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.laroche03 order_id : 12432 customer_email : c.laroche03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12433" select * from cms_frontusers where identifiant = "g.kupas08" 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 = "12433" select * from cotisations where identifiant = "g.kupas08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 132450 payment_means : MASTERCARD transmission_date : 20160109122450 payment_time : 132630 payment_date : 20160109 response_code : 00 payment_certificate : 55ac913bfce5 authorisation_id : 095690 currency_code : 978 card_number : 5341.00 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.kupas08 order_id : 12433 customer_email : g.kupas08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12434" select * from cms_frontusers where identifiant = "b.boulet10" 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 = "12434" select * from cotisations where identifiant = "b.boulet10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132911 payment_means : MASTERCARD transmission_date : 20160109122911 payment_time : 133246 payment_date : 20160109 response_code : 00 payment_certificate : ca4b777eada1 authorisation_id : 163823 currency_code : 978 card_number : 5132.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.boulet10 order_id : 12434 customer_email : b.boulet10@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 = "12436" select * from cms_frontusers where identifiant = "p.pommereau19" 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 = "12436" select * from cotisations where identifiant = "p.pommereau19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 134418 payment_means : VISA transmission_date : 20160109124418 payment_time : 134703 payment_date : 20160109 response_code : 00 payment_certificate : 57e533c91e02 authorisation_id : 960252 currency_code : 978 card_number : 4978.04 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.pommereau19 order_id : 12436 customer_email : p.pommereau19@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 = "12437" select * from cms_frontusers where identifiant = "p.pommereau25" 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 = "12437" select * from cotisations where identifiant = "p.pommereau25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135124 payment_means : VISA transmission_date : 20160109125124 payment_time : 135320 payment_date : 20160109 response_code : 00 payment_certificate : e6c74922a0db authorisation_id : 516013 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 : p.pommereau25 order_id : 12437 customer_email : p.pommereau25@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 = "12438" select * from cms_frontusers where identifiant = "fx.prin17" 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 = "12438" select * from cotisations where identifiant = "fx.prin17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140754 payment_means : MASTERCARD transmission_date : 20160109130754 payment_time : 141042 payment_date : 20160109 response_code : 00 payment_certificate : 5553cbcc3760 authorisation_id : 413431 currency_code : 978 card_number : 5132.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : fx.prin17 order_id : 12438 customer_email : fx.prin17@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 = "12440" select * from cms_frontusers where identifiant = "s.chauvet26" 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 = "12440" select * from cotisations where identifiant = "o.baillat10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154615 payment_means : MASTERCARD transmission_date : 20160109144615 payment_time : 155203 payment_date : 20160109 response_code : 00 payment_certificate : dce32344906d authorisation_id : 162591 currency_code : 978 card_number : 5131.62 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.chauvet26 order_id : 12440 customer_email : s.chauvet26@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 = "12441" select * from cms_frontusers where identifiant = "i.berland18" 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 = "12441" select * from cotisations where identifiant = "i.berland18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163511 payment_means : VISA transmission_date : 20160109153511 payment_time : 163811 payment_date : 20160109 response_code : 00 payment_certificate : 1f8d96974dda authorisation_id : 562453 currency_code : 978 card_number : 4978.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : i.berland18 order_id : 12441 customer_email : i.berland18@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 = "12443" select * from cms_frontusers where identifiant = "n.lebec10" 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 = "12443" select * from cotisations where identifiant = "n.lebec10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165011 payment_means : MASTERCARD transmission_date : 20160109155011 payment_time : 165303 payment_date : 20160109 response_code : 00 payment_certificate : ff8bab89f63a authorisation_id : 499517 currency_code : 978 card_number : 5136.04 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.lebec10 order_id : 12443 customer_email : n.lebec10@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12442" select * from cms_frontusers where identifiant = "s.pichot01" 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 = "12442" select * from cotisations where identifiant = "s.pichot01" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "s.pichot01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165021 payment_means : VISA transmission_date : 20160109155021 payment_time : 165601 payment_date : 20160109 response_code : 00 payment_certificate : 0bc3212bd50e authorisation_id : 161383 currency_code : 978 card_number : 4974.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 : s.pichot01 order_id : 12442 customer_email : s.pichot01@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 : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12445" select * from cms_frontusers where identifiant = "s.chauvet26" 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 = "12445" select * from cotisations where identifiant = "p.moreno12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170300 payment_means : VISA transmission_date : 20160109160300 payment_time : 170638 payment_date : 20160109 response_code : 00 payment_certificate : b321a3c1b44e authorisation_id : 106469 currency_code : 978 card_number : 4974.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 : s.chauvet26 order_id : 12445 customer_email : s.chauvet26@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 = "12447" select * from cms_frontusers where identifiant = "c.veille17" 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 = "12447" select * from cotisations where identifiant = "c.veille17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 174636 payment_means : VISA transmission_date : 20160109164636 payment_time : 174811 payment_date : 20160109 response_code : 00 payment_certificate : f4315fa444e7 authorisation_id : 244135 currency_code : 978 card_number : 4970.24 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.veille17 order_id : 12447 customer_email : c.veille17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12448" select * from cms_frontusers where identifiant = "b.vidal21" 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 = "12448" select * from cotisations where identifiant = "b.vidal21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175032 payment_means : MASTERCARD transmission_date : 20160109165032 payment_time : 175157 payment_date : 20160109 response_code : 00 payment_certificate : 3925f36bd349 authorisation_id : 377270 currency_code : 978 card_number : 5137.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.vidal21 order_id : 12448 customer_email : b.vidal21@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12449" select * from cms_frontusers where identifiant = "e.leblanc03" 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 = "12449" select * from cotisations where identifiant = "e.leblanc03" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "e.leblanc03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 175452 payment_means : MASTERCARD transmission_date : 20160109165452 payment_time : 180003 payment_date : 20160109 response_code : 00 payment_certificate : 307560cebf55 authorisation_id : 333814 currency_code : 978 card_number : 5132.68 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.leblanc03 order_id : 12449 customer_email : e.leblanc03@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 = "12450" select * from cms_frontusers where identifiant = "r.barbedette08" 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 = "12450" select * from cotisations where identifiant = "t.bouteloup06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180245 payment_means : VISA transmission_date : 20160109170245 payment_time : 180402 payment_date : 20160109 response_code : 00 payment_certificate : abefdb79d1d5 authorisation_id : 132681 currency_code : 978 card_number : 4970.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 : r.barbedette08 order_id : 12450 customer_email : r.barbedette08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12451" select * from cms_frontusers where identifiant = "r.barbedette08" 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 = "12451" select * from cotisations where identifiant = "a.bieber06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180441 payment_means : VISA transmission_date : 20160109170441 payment_time : 180609 payment_date : 20160109 response_code : 00 payment_certificate : 234f5d31b932 authorisation_id : 563158 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 : r.barbedette08 order_id : 12451 customer_email : r.barbedette08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12452" select * from cms_frontusers where identifiant = "a.ballarini11" 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 = "12452" select * from cotisations where identifiant = "a.ballarini11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181609 payment_means : VISA transmission_date : 20160109171609 payment_time : 181724 payment_date : 20160109 response_code : 00 payment_certificate : 89da927c576a authorisation_id : 008344 currency_code : 978 card_number : 4659.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.ballarini11 order_id : 12452 customer_email : a.ballarini11@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 : 201808 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12453" select * from cms_frontusers where identifiant = "c.bocle01" 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 = "12453" select * from cotisations where identifiant = "g.popek23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181507 payment_means : VISA transmission_date : 20160109171507 payment_time : 181826 payment_date : 20160109 response_code : 00 payment_certificate : 96b208b45272 authorisation_id : 016354 currency_code : 978 card_number : 4978.68 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.bocle01 order_id : 12453 customer_email : c.bocle01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181539 payment_means : VISA transmission_date : 20160109171539 payment_time : 182114 payment_date : 20160109 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.baty15 order_id : 12454 customer_email : d.baty15@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12454" select * from cms_frontusers where identifiant = "d.baty15" 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 = "12454" select * from cotisations where identifiant = "d.baty15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182127 payment_means : VISA transmission_date : 20160109172127 payment_time : 182831 payment_date : 20160109 response_code : 00 payment_certificate : a8228c006aa5 authorisation_id : 260653 currency_code : 978 card_number : 4974.19 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.baty15 order_id : 12454 customer_email : d.baty15@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 : 201810 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 : 193924 payment_means : CB transmission_date : 20160109183924 payment_time : 194358 payment_date : 20160109 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : ym.lebalch27 order_id : 12457 customer_email : ym.lebalch27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12457" select * from cms_frontusers where identifiant = "ym.lebalch27" 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 = "12457" select * from cotisations where identifiant = "ym.lebalch27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194415 payment_means : MASTERCARD transmission_date : 20160109184415 payment_time : 194537 payment_date : 20160109 response_code : 00 payment_certificate : 894671438b67 authorisation_id : 853115 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 : ym.lebalch27 order_id : 12457 customer_email : ym.lebalch27@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 = "12458" select * from cms_frontusers where identifiant = "t.bellanger23" 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 = "12458" select * from cotisations where identifiant = "t.bellanger23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201713 payment_means : MASTERCARD transmission_date : 20160109191713 payment_time : 201951 payment_date : 20160109 response_code : 00 payment_certificate : 82b006faca1d authorisation_id : 699542 currency_code : 978 card_number : 5137.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 : t.bellanger23 order_id : 12458 customer_email : t.bellanger23@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 = "12459" select * from cms_frontusers where identifiant = "jp.devrainne30" 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 = "12459" select * from cotisations where identifiant = "jp.devrainne30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202136 payment_means : MASTERCARD transmission_date : 20160109192136 payment_time : 202358 payment_date : 20160109 response_code : 00 payment_certificate : a7f23e0baedc authorisation_id : 215126 currency_code : 978 card_number : 5132.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 : jp.devrainne30 order_id : 12459 customer_email : jp.devrainne30@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 = "12460" select * from cms_frontusers where identifiant = "jp.contin28" 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 = "12460" select * from cotisations where identifiant = "jp.contin28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203021 payment_means : MASTERCARD transmission_date : 20160109193021 payment_time : 203204 payment_date : 20160109 response_code : 00 payment_certificate : a0cb2d19d005 authorisation_id : 726424 currency_code : 978 card_number : 5137.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 : jp.contin28 order_id : 12460 customer_email : jp.contin28@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12462" select * from cms_frontusers where identifiant = "jl.soubeiran11" 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 = "12462" select * from cotisations where identifiant = "jl.soubeiran11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211542 payment_means : MASTERCARD transmission_date : 20160109201542 payment_time : 211842 payment_date : 20160109 response_code : 00 payment_certificate : 3ad106b89264 authorisation_id : 535433 currency_code : 978 card_number : 5137.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 : jl.soubeiran11 order_id : 12462 customer_email : jl.soubeiran11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12463" select * from cms_frontusers where identifiant = "o.lavigne22" 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 = "12463" select * from cotisations where identifiant = "o.lavigne22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212659 payment_means : VISA transmission_date : 20160109202659 payment_time : 212915 payment_date : 20160109 response_code : 00 payment_certificate : f63e8ff62cb0 authorisation_id : 182201 currency_code : 978 card_number : 4976.56 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.lavigne22 order_id : 12463 customer_email : o.lavigne22@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 : -------------------------------------------