select * from cotisations_commande where id = "10433" select * from cms_frontusers where identifiant = "a.duchene09" 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 = "10433" select * from cotisations where identifiant = "a.duchene09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 064822 payment_means : MASTERCARD transmission_date : 20151210054822 payment_time : 065057 payment_date : 20151210 response_code : 00 payment_certificate : 68b7524faed5 authorisation_id : 240434 currency_code : 978 card_number : 5341.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 : a.duchene09 order_id : 10433 customer_email : a.duchene09@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 = "10434" select * from cms_frontusers where identifiant = "t.bellest21" 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 = "10434" select * from cotisations where identifiant = "t.bellest21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 071101 payment_means : VISA transmission_date : 20151210061101 payment_time : 071239 payment_date : 20151210 response_code : 00 payment_certificate : 390381a7e04f authorisation_id : 981555 currency_code : 978 card_number : 4971.45 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.bellest21 order_id : 10434 customer_email : t.bellest21@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 = "10435" select * from cms_frontusers where identifiant = "a.granon01" 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 = "10435" select * from cotisations where identifiant = "a.granon01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073530 payment_means : VISA transmission_date : 20151210063530 payment_time : 073655 payment_date : 20151210 response_code : 00 payment_certificate : 53330db28b10 authorisation_id : 586164 currency_code : 978 card_number : 4239.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 : a.granon01 order_id : 10435 customer_email : a.granon01@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080015 payment_means : VISA transmission_date : 20151210070015 payment_time : 080159 payment_date : 20151210 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.27 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 : a.jung14 order_id : 10436 customer_email : a.jung14@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 = "10437" select * from cms_frontusers where identifiant = "v.besnier01" 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 = "10437" select * from cotisations where identifiant = "v.besnier01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081427 payment_means : MASTERCARD transmission_date : 20151210071427 payment_time : 081618 payment_date : 20151210 response_code : 00 payment_certificate : 941e9e9de649 authorisation_id : 667119 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 : v.besnier01 order_id : 10437 customer_email : v.besnier01@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 = "10441" select * from cms_frontusers where identifiant = "a.charbonnier14" 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 = "10441" select * from cotisations where identifiant = "a.charbonnier14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091218 payment_means : MASTERCARD transmission_date : 20151210081218 payment_time : 091715 payment_date : 20151210 response_code : 00 payment_certificate : a863746b83a9 authorisation_id : 039111 currency_code : 978 card_number : 5131.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 : a.charbonnier14 order_id : 10441 customer_email : a.charbonnier14@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 = "10442" select * from cms_frontusers where identifiant = "l.goetschy18" 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 = "10442" select * from cotisations where identifiant = "l.goetschy18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095619 payment_means : MASTERCARD transmission_date : 20151210085619 payment_time : 095913 payment_date : 20151210 response_code : 00 payment_certificate : 4ed24df2e73f authorisation_id : 639464 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 : l.goetschy18 order_id : 10442 customer_email : l.goetschy18@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 : 095752 payment_means : VISA transmission_date : 20151210085752 payment_time : 100311 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.95 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 : p.neuillygaye21 order_id : 10443 customer_email : p.neuillygaye21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10443" select * from cms_frontusers where identifiant = "p.neuillygaye21" 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 = "10443" select * from cotisations where identifiant = "p.neuillygaye21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100349 payment_means : VISA transmission_date : 20151210090349 payment_time : 100615 payment_date : 20151210 response_code : 00 payment_certificate : 391b8ddb2c2d authorisation_id : 595548 currency_code : 978 card_number : 4978.95 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.neuillygaye21 order_id : 10443 customer_email : p.neuillygaye21@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 = "10444" select * from cms_frontusers where identifiant = "c.abrial25" 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 = "10444" select * from cotisations where identifiant = "c.abrial25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100927 payment_means : MASTERCARD transmission_date : 20151210090927 payment_time : 101142 payment_date : 20151210 response_code : 00 payment_certificate : 9a933763b475 authorisation_id : 994361 currency_code : 978 card_number : 5137.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 : c.abrial25 order_id : 10444 customer_email : c.abrial25@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 = "10445" select * from cms_frontusers where identifiant = "f.argente15" 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 = "10445" select * from cotisations where identifiant = "f.argente15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 123657 payment_means : VISA transmission_date : 20151210113657 payment_time : 123804 payment_date : 20151210 response_code : 00 payment_certificate : 6d3d0cbbb232 authorisation_id : 589167 currency_code : 978 card_number : 4971.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 : f.argente15 order_id : 10445 customer_email : f.argente15@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 = "10446" select * from cms_frontusers where identifiant = "n.vicat10" 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 = "10446" select * from cotisations where identifiant = "n.vicat10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130957 payment_means : MASTERCARD transmission_date : 20151210120957 payment_time : 131201 payment_date : 20151210 response_code : 00 payment_certificate : 8fa6cb8cff01 authorisation_id : 266288 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 : n.vicat10 order_id : 10446 customer_email : n.vicat10@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 : 131654 payment_means : MASTERCARD transmission_date : 20151210121654 payment_time : 132144 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.31 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 : m.douat20 order_id : 10447 customer_email : m.douat20@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10448" select * from cms_frontusers where identifiant = "c.leclerc04" 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 = "10448" select * from cotisations where identifiant = "c.leclerc04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145917 payment_means : VISA transmission_date : 20151210135917 payment_time : 150430 payment_date : 20151210 response_code : 00 payment_certificate : bae18891fff5 authorisation_id : 660654 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 : c.leclerc04 order_id : 10448 customer_email : c.leclerc04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10449" select * from cms_frontusers where identifiant = "n.naudin02" 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 = "10449" select * from cotisations where identifiant = "n.naudin02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151552 payment_means : MASTERCARD transmission_date : 20151210141552 payment_time : 151954 payment_date : 20151210 response_code : 00 payment_certificate : 81f525121b1e authorisation_id : 831313 currency_code : 978 card_number : 5136.93 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.naudin02 order_id : 10449 customer_email : n.naudin02@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10450" select * from cms_frontusers where identifiant = "m.pulicani20" 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 = "10450" select * from cotisations where identifiant = "m.pulicani20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151809 payment_means : VISA transmission_date : 20151210141809 payment_time : 152026 payment_date : 20151210 response_code : 00 payment_certificate : f925b2cdf6b8 authorisation_id : 157567 currency_code : 978 card_number : 4975.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 : m.pulicani20 order_id : 10450 customer_email : m.pulicani20@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 : 160002 payment_means : VISA transmission_date : 20151210150002 payment_time : 160230 payment_date : 20151210 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.02 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 : j.clin10 order_id : 10451 customer_email : j.clin10@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 = "10452" select * from cms_frontusers where identifiant = "r.veyret21" 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 = "10452" select * from cotisations where identifiant = "r.veyret21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165001 payment_means : MASTERCARD transmission_date : 20151210155001 payment_time : 165107 payment_date : 20151210 response_code : 00 payment_certificate : 3b79f41ad1bd authorisation_id : 370795 currency_code : 978 card_number : 5134.54 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.veyret21 order_id : 10452 customer_email : r.veyret21@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 : 8000 transaction_id : 165123 payment_means : VISA transmission_date : 20151210155123 payment_time : 165343 payment_date : 20151210 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.28 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 : a.bonnaterre07 order_id : 10453 customer_email : a.bonnaterre07@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 = "10454" select * from cms_frontusers where identifiant = "jp.detrait16" 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 = "10454" select * from cotisations where identifiant = "jp.detrait16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173840 payment_means : VISA transmission_date : 20151210163840 payment_time : 174031 payment_date : 20151210 response_code : 00 payment_certificate : 07b753787ee7 authorisation_id : 542564 currency_code : 978 card_number : 4977.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.detrait16 order_id : 10454 customer_email : jp.detrait16@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 = "10455" select * from cms_frontusers where identifiant = "a.moal18" 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 = "10455" select * from cotisations where identifiant = "a.moal18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175315 payment_means : MASTERCARD transmission_date : 20151210165315 payment_time : 175435 payment_date : 20151210 response_code : 00 payment_certificate : 289d503f1d17 authorisation_id : 331597 currency_code : 978 card_number : 5132.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 : a.moal18 order_id : 10455 customer_email : a.moal18@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 = "10456" select * from cms_frontusers where identifiant = "b.tige09" 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 = "10456" select * from cotisations where identifiant = "b.tige09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180152 payment_means : VISA transmission_date : 20151210170152 payment_time : 180434 payment_date : 20151210 response_code : 00 payment_certificate : c5375d83eb6a authorisation_id : 279338 currency_code : 978 card_number : 4973.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 : b.tige09 order_id : 10456 customer_email : b.tige09@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 = "10457" select * from cms_frontusers where identifiant = "j.angot08" 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 = "10457" select * from cotisations where identifiant = "r.bellet16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181602 payment_means : VISA transmission_date : 20151210171602 payment_time : 181755 payment_date : 20151210 response_code : 00 payment_certificate : b69affd44aff authorisation_id : 519541 currency_code : 978 card_number : 4977.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 : j.angot08 order_id : 10457 customer_email : j.angot08@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184124 payment_means : MASTERCARD transmission_date : 20151210174124 payment_time : 184309 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.billard29 order_id : 10458 customer_email : e.billard29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10459" select * from cms_frontusers where identifiant = "l.nowecki15" 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 = "10459" select * from cotisations where identifiant = "l.nowecki15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185720 payment_means : VISA transmission_date : 20151210175720 payment_time : 185841 payment_date : 20151210 response_code : 00 payment_certificate : 620d3672b02a authorisation_id : 262125 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 : l.nowecki15 order_id : 10459 customer_email : l.nowecki15@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 = "10460" select * from cms_frontusers where identifiant = "r.parisot25" 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 = "10460" select * from cotisations where identifiant = "r.parisot25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190523 payment_means : VISA transmission_date : 20151210180523 payment_time : 191023 payment_date : 20151210 response_code : 00 payment_certificate : b22122cbf03b authorisation_id : 563345 currency_code : 978 card_number : 4970.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 : r.parisot25 order_id : 10460 customer_email : r.parisot25@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 = "10461" select * from cms_frontusers where identifiant = "c.pons03" 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 = "10461" select * from cotisations where identifiant = "c.pons03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191605 payment_means : MASTERCARD transmission_date : 20151210181605 payment_time : 191732 payment_date : 20151210 response_code : 00 payment_certificate : 438ffbd72c10 authorisation_id : 965386 currency_code : 978 card_number : 5131.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 : c.pons03 order_id : 10461 customer_email : c.pons03@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 = "10462" select * from cms_frontusers where identifiant = "t.delangle02" 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 = "10462" select * from cotisations where identifiant = "t.delangle02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192339 payment_means : VISA transmission_date : 20151210182339 payment_time : 192612 payment_date : 20151210 response_code : 00 payment_certificate : 94bd94440ad6 authorisation_id : 310850 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 : t.delangle02 order_id : 10462 customer_email : t.delangle02@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10464" select * from cms_frontusers where identifiant = "jp.zot07" 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 = "10464" select * from cotisations where identifiant = "jp.zot07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194416 payment_means : VISA transmission_date : 20151210184416 payment_time : 194519 payment_date : 20151210 response_code : 00 payment_certificate : 76ff7fd87c21 authorisation_id : 434979 currency_code : 978 card_number : 4150.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 : jp.zot07 order_id : 10464 customer_email : jp.zot07@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 = "10463" select * from cms_frontusers where identifiant = "f.petiteau20" 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 = "10463" select * from cotisations where identifiant = "f.petiteau20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193731 payment_means : VISA transmission_date : 20151210183731 payment_time : 194623 payment_date : 20151210 response_code : 00 payment_certificate : 28418c9f0fbf authorisation_id : 267009 currency_code : 978 card_number : 4975.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 : f.petiteau20 order_id : 10463 customer_email : f.petiteau20@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 = "10465" select * from cms_frontusers where identifiant = "pa.raveleau22" 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 = "10465" select * from cotisations where identifiant = "pa.raveleau22" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "pa.raveleau22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195915 payment_means : MASTERCARD transmission_date : 20151210185915 payment_time : 200058 payment_date : 20151210 response_code : 00 payment_certificate : 49150efdf6bf authorisation_id : 817327 currency_code : 978 card_number : 5133.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : pa.raveleau22 order_id : 10465 customer_email : pa.raveleau22@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 = "10466" select * from cms_frontusers where identifiant = "a.moriceau10" 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 = "10466" select * from cotisations where identifiant = "a.moriceau10" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "a.moriceau10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195957 payment_means : MASTERCARD transmission_date : 20151210185957 payment_time : 200133 payment_date : 20151210 response_code : 00 payment_certificate : c49d0111255b authorisation_id : 533424 currency_code : 978 card_number : 5131.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 : a.moriceau10 order_id : 10466 customer_email : a.moriceau10@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 = "10468" select * from cms_frontusers where identifiant = "m.bellanger13" 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 = "10468" select * from cotisations where identifiant = "m.bellanger13" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.bellanger13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201236 payment_means : VISA transmission_date : 20151210191236 payment_time : 202352 payment_date : 20151210 response_code : 00 payment_certificate : c0fb475543dd authorisation_id : 274647 currency_code : 978 card_number : 4970.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.bellanger13 order_id : 10468 customer_email : m.bellanger13@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10471" select * from cms_frontusers where identifiant = "s.charpentier15" 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 = "10471" select * from cotisations where identifiant = "s.charpentier15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204015 payment_means : VISA transmission_date : 20151210194015 payment_time : 204259 payment_date : 20151210 response_code : 00 payment_certificate : fafd912f6d75 authorisation_id : 511202 currency_code : 978 card_number : 4974.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 : s.charpentier15 order_id : 10471 customer_email : s.charpentier15@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 = "10470" select * from cms_frontusers where identifiant = "s.baumgratz19" 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 = "10470" select * from cotisations where identifiant = "s.baumgratz19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203925 payment_means : MASTERCARD transmission_date : 20151210193925 payment_time : 204943 payment_date : 20151210 response_code : 00 payment_certificate : 8e1b947b2db1 authorisation_id : 185399 currency_code : 978 card_number : 5133.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 : s.baumgratz19 order_id : 10470 customer_email : s.baumgratz19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10473" select * from cms_frontusers where identifiant = "j.coq22" 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 = "10473" select * from cotisations where identifiant = "j.coq22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204809 payment_means : VISA transmission_date : 20151210194809 payment_time : 204954 payment_date : 20151210 response_code : 00 payment_certificate : c2bd739273e8 authorisation_id : 642646 currency_code : 978 card_number : 4970.97 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.coq22 order_id : 10473 customer_email : j.coq22@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10472" select * from cms_frontusers where identifiant = "k.kembellec13" 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 = "10472" select * from cotisations where identifiant = "w.batista14" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "w.batista14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204546 payment_means : MASTERCARD transmission_date : 20151210194546 payment_time : 205036 payment_date : 20151210 response_code : 00 payment_certificate : 5f3d3c4f5a19 authorisation_id : 053264 currency_code : 978 card_number : 5132.93 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.kembellec13 order_id : 10472 customer_email : k.kembellec13@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 = "10474" select * from cms_frontusers where identifiant = "s.charpentier15" 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 = "10474" select * from cotisations where identifiant = "s.charpentier15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205004 payment_means : VISA transmission_date : 20151210195004 payment_time : 205134 payment_date : 20151210 response_code : 00 payment_certificate : c768a7d06ff3 authorisation_id : 443332 currency_code : 978 card_number : 4974.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 : s.charpentier15 order_id : 10474 customer_email : s.charpentier15@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 = "10475" select * from cms_frontusers where identifiant = "o.debuisne26" 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 = "10475" select * from cotisations where identifiant = "o.debuisne26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205138 payment_means : MASTERCARD transmission_date : 20151210195138 payment_time : 205617 payment_date : 20151210 response_code : 00 payment_certificate : 52cd3ea8913d authorisation_id : 555458 currency_code : 978 card_number : 5131.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : o.debuisne26 order_id : 10475 customer_email : o.debuisne26@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 = "10476" select * from cms_frontusers where identifiant = "y.pantaleon13" 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 = "10476" select * from cotisations where identifiant = "y.pantaleon13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205245 payment_means : MASTERCARD transmission_date : 20151210195245 payment_time : 205714 payment_date : 20151210 response_code : 00 payment_certificate : ac7a61d68e39 authorisation_id : 232412 currency_code : 978 card_number : 5137.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 : y.pantaleon13 order_id : 10476 customer_email : y.pantaleon13@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 = "10477" select * from cms_frontusers where identifiant = "k.kembellec13" 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 = "10477" select * from cotisations where identifiant = "v.juillerat03" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "v.juillerat03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205801 payment_means : VISA transmission_date : 20151210195801 payment_time : 210142 payment_date : 20151210 response_code : 00 payment_certificate : d97f350952fa authorisation_id : 117645 currency_code : 978 card_number : 4974.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.kembellec13 order_id : 10477 customer_email : k.kembellec13@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210204 payment_means : MASTERCARD transmission_date : 20151210200204 payment_time : 210357 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.69 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 : y.pantaleon13 order_id : 10478 customer_email : y.pantaleon13@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10478" select * from cms_frontusers where identifiant = "y.pantaleon13" 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 = "10478" select * from cotisations where identifiant = "h.pantaleon13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210412 payment_means : MASTERCARD transmission_date : 20151210200412 payment_time : 210713 payment_date : 20151210 response_code : 00 payment_certificate : b9120719c247 authorisation_id : 311069 currency_code : 978 card_number : 5137.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 : y.pantaleon13 order_id : 10478 customer_email : y.pantaleon13@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 = "10481" select * from cms_frontusers where identifiant = "a.chollet09" 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 = "10481" select * from cotisations where identifiant = "z.szekeres05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211526 payment_means : VISA transmission_date : 20151210201526 payment_time : 211718 payment_date : 20151210 response_code : 00 payment_certificate : 59bcd616775f authorisation_id : 007491 currency_code : 978 card_number : 4659.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 : a.chollet09 order_id : 10481 customer_email : a.chollet09@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 = "10483" select * from cms_frontusers where identifiant = "c.baudoin09" 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 = "10483" select * from cotisations where identifiant = "c.baudoin09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213021 payment_means : MASTERCARD transmission_date : 20151210203021 payment_time : 213448 payment_date : 20151210 response_code : 00 payment_certificate : 51be4a2ac45f authorisation_id : 254034 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 : c.baudoin09 order_id : 10483 customer_email : c.baudoin09@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 : 8000 transaction_id : 213018 payment_means : VISA transmission_date : 20151210203018 payment_time : 213727 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.11 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 : t.drouet30 order_id : 10482 customer_email : t.drouet30@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10484" select * from cms_frontusers where identifiant = "t.schneider29" 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 = "10484" select * from cotisations where identifiant = "t.schneider29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214746 payment_means : MASTERCARD transmission_date : 20151210204746 payment_time : 214947 payment_date : 20151210 response_code : 00 payment_certificate : 01a5b62b8397 authorisation_id : T06390 currency_code : 978 card_number : 5193.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 : t.schneider29 order_id : 10484 customer_email : t.schneider29@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 = "10485" select * from cms_frontusers where identifiant = "d.vallar28" 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 = "10485" select * from cotisations where identifiant = "d.vallar28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214921 payment_means : VISA transmission_date : 20151210204921 payment_time : 215131 payment_date : 20151210 response_code : 00 payment_certificate : e1e415707fe8 authorisation_id : 325546 currency_code : 978 card_number : 4978.37 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.vallar28 order_id : 10485 customer_email : d.vallar28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10487" select * from cms_frontusers where identifiant = "v.mille22" 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 = "10487" select * from cotisations where identifiant = "v.mille22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220337 payment_means : VISA transmission_date : 20151210210337 payment_time : 220601 payment_date : 20151210 response_code : 00 payment_certificate : 4bde65491083 authorisation_id : 824413 currency_code : 978 card_number : 4533.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 : v.mille22 order_id : 10487 customer_email : v.mille22@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221132 payment_means : MASTERCARD transmission_date : 20151210211132 payment_time : 221233 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.55 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 : n.mendonca06 order_id : 10489 customer_email : n.mendonca06@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10488" select * from cms_frontusers where identifiant = "r.dagois22" 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 = "10488" select * from cotisations where identifiant = "c.guigon24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221057 payment_means : VISA transmission_date : 20151210211057 payment_time : 221250 payment_date : 20151210 response_code : 00 payment_certificate : 54d2174e90aa authorisation_id : 350063 currency_code : 978 card_number : 4973.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 : r.dagois22 order_id : 10488 customer_email : r.dagois22@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 : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10490" select * from cms_frontusers where identifiant = "m.seyfried26" 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 = "10490" select * from cotisations where identifiant = "m.seyfried26" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.seyfried26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222215 payment_means : MASTERCARD transmission_date : 20151210212215 payment_time : 222342 payment_date : 20151210 response_code : 00 payment_certificate : 466f42a9e0c2 authorisation_id : 367972 currency_code : 978 card_number : 5341.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 : m.seyfried26 order_id : 10490 customer_email : m.seyfried26@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 = "10491" select * from cms_frontusers where identifiant = "m.baron30" 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 = "10491" select * from cotisations where identifiant = "m.baron30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222530 payment_means : VISA transmission_date : 20151210212530 payment_time : 222658 payment_date : 20151210 response_code : 00 payment_certificate : 7374b3081a0d authorisation_id : 228735 currency_code : 978 card_number : 4978.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 : m.baron30 order_id : 10491 customer_email : m.baron30@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 = "10493" select * from cms_frontusers where identifiant = "c.behra30" 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 = "10493" select * from cotisations where identifiant = "c.behra30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223618 payment_means : MASTERCARD transmission_date : 20151210213618 payment_time : 223906 payment_date : 20151210 response_code : 00 payment_certificate : 169445bb59bb authorisation_id : 748126 currency_code : 978 card_number : 5131.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 : c.behra30 order_id : 10493 customer_email : c.behra30@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 : 224227 payment_means : MASTERCARD transmission_date : 20151210214227 payment_time : 224722 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.54 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 : m.bidegorry01 order_id : 10494 customer_email : m.bidegorry01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224738 payment_means : MASTERCARD transmission_date : 20151210214738 payment_time : 224959 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.54 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 : m.bidegorry01 order_id : 10494 customer_email : m.bidegorry01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225015 payment_means : MASTERCARD transmission_date : 20151210215015 payment_time : 225449 payment_date : 20151210 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.54 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 : m.bidegorry01 order_id : 10494 customer_email : m.bidegorry01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10495" select * from cms_frontusers where identifiant = "h.gougeon24" 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 = "10495" select * from cotisations where identifiant = "h.gougeon24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225429 payment_means : MASTERCARD transmission_date : 20151210215429 payment_time : 225721 payment_date : 20151210 response_code : 00 payment_certificate : d3d7787cafe0 authorisation_id : 623298 currency_code : 978 card_number : 5294.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 : h.gougeon24 order_id : 10495 customer_email : h.gougeon24@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 = "10494" select * from cms_frontusers where identifiant = "m.bidegorry01" 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 = "10494" select * from cotisations where identifiant = "m.bidegorry01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225530 payment_means : MASTERCARD transmission_date : 20151210215530 payment_time : 230057 payment_date : 20151210 response_code : 00 payment_certificate : 2e6b3c78b189 authorisation_id : 371450 currency_code : 978 card_number : 5137.78 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.bidegorry01 order_id : 10494 customer_email : m.bidegorry01@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 = "10496" select * from cms_frontusers where identifiant = "q.royet13" 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 = "10496" select * from cotisations where identifiant = "q.royet13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 231519 payment_means : VISA transmission_date : 20151210221519 payment_time : 231842 payment_date : 20151210 response_code : 00 payment_certificate : 16da27f3ebb4 authorisation_id : 432742 currency_code : 978 card_number : 4970.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 : q.royet13 order_id : 10496 customer_email : q.royet13@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 = "10497" select * from cms_frontusers where identifiant = "s.gaborit01" 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 = "10497" select * from cotisations where identifiant = "s.gaborit01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 231603 payment_means : VISA transmission_date : 20151210221603 payment_time : 231851 payment_date : 20151210 response_code : 00 payment_certificate : fe47000250d8 authorisation_id : 319360 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 : s.gaborit01 order_id : 10497 customer_email : s.gaborit01@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 = "10498" 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 = "10498" select * from cotisations where identifiant = "q.hasiuk05" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "q.hasiuk05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 234218 payment_means : VISA transmission_date : 20151210224218 payment_time : 234443 payment_date : 20151210 response_code : 00 payment_certificate : 35cf10aff72e authorisation_id : 274290 currency_code : 978 card_number : 4978.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.canut19 order_id : 10498 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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------