select * from cotisations_commande where id = "18838" select * from cms_frontusers where identifiant = "e.schach22" 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 = "18838" select * from cotisations where identifiant = "e.schach22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070205 payment_means : VISA transmission_date : 20161221060205 payment_time : 070342 payment_date : 20161221 response_code : 00 payment_certificate : 82765f9a83d0 authorisation_id : 952194 currency_code : 978 card_number : 4977.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.schach22 order_id : 18838 customer_email : e.schach22@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18839" select * from cms_frontusers where identifiant = "jp.hardouin04" 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 = "18839" select * from cotisations where identifiant = "jp.hardouin04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080904 payment_means : VISA transmission_date : 20161221070904 payment_time : 081148 payment_date : 20161221 response_code : 00 payment_certificate : d58bea3bd911 authorisation_id : 780371 currency_code : 978 card_number : 4970.79 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.hardouin04 order_id : 18839 customer_email : jp.hardouin04@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081244 payment_means : VISA transmission_date : 20161221071244 payment_time : 081411 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.dangelo20 order_id : 18840 customer_email : b.dangelo20@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 : 081414 payment_means : VISA transmission_date : 20161221071414 payment_time : 081643 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.dangelo20 order_id : 18840 customer_email : b.dangelo20@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 = "18840" select * from cms_frontusers where identifiant = "b.dangelo20" 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 = "18840" select * from cotisations where identifiant = "b.dangelo20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081646 payment_means : VISA transmission_date : 20161221071646 payment_time : 081824 payment_date : 20161221 response_code : 00 payment_certificate : f4c986ccfaa6 authorisation_id : 441735 currency_code : 978 card_number : 4977.71 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.dangelo20 order_id : 18840 customer_email : b.dangelo20@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084906 payment_means : VISA transmission_date : 20161221074906 payment_time : 090141 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.barbot08 order_id : 18841 customer_email : jc.barbot08@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18842" select * from cms_frontusers where identifiant = "r.louvet14" 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 = "18842" select * from cotisations where identifiant = "r.louvet14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090318 payment_means : MASTERCARD transmission_date : 20161221080318 payment_time : 090439 payment_date : 20161221 response_code : 00 payment_certificate : 694ebdcfac1b authorisation_id : 414005 currency_code : 978 card_number : 5137.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 : r.louvet14 order_id : 18842 customer_email : r.louvet14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092422 payment_means : VISA transmission_date : 20161221082422 payment_time : 092836 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.barbot08 order_id : 18843 customer_email : jc.barbot08@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18844" select * from cms_frontusers where identifiant = "l.terrien14" 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 = "18844" select * from cotisations where identifiant = "l.terrien14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093326 payment_means : MASTERCARD transmission_date : 20161221083326 payment_time : 093505 payment_date : 20161221 response_code : 00 payment_certificate : c94803379455 authorisation_id : 464684 currency_code : 978 card_number : 5131.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.terrien14 order_id : 18844 customer_email : l.terrien14@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 = "18845" select * from cms_frontusers where identifiant = "l.verron26" 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 = "18845" select * from cotisations where identifiant = "l.verron26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093636 payment_means : VISA transmission_date : 20161221083636 payment_time : 093856 payment_date : 20161221 response_code : 00 payment_certificate : e0c94cfd5e6b authorisation_id : 354111 currency_code : 978 card_number : 4977.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.verron26 order_id : 18845 customer_email : l.verron26@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 = "18846" select * from cms_frontusers where identifiant = "c.roth31" 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 = "18846" select * from cotisations where identifiant = "c.roth31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101843 payment_means : MASTERCARD transmission_date : 20161221091843 payment_time : 101954 payment_date : 20161221 response_code : 00 payment_certificate : 1f20455a0f78 authorisation_id : 422485 currency_code : 978 card_number : 5132.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 : c.roth31 order_id : 18846 customer_email : c.roth31@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 = "18847" select * from cms_frontusers where identifiant = "c.fernandes30" 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 = "18847" select * from cotisations where identifiant = "c.fernandes30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102401 payment_means : MASTERCARD transmission_date : 20161221092401 payment_time : 103551 payment_date : 20161221 response_code : 00 payment_certificate : 5146191afcb6 authorisation_id : 630853 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 : c.fernandes30 order_id : 18847 customer_email : c.fernandes30@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 = "18849" select * from cms_frontusers where identifiant = "jc.pennequin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18849" select * from cotisations where identifiant = "jc.pennequin03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104846 payment_means : MASTERCARD transmission_date : 20161221094846 payment_time : 105019 payment_date : 20161221 response_code : 00 payment_certificate : 9cfe8854d52d authorisation_id : 889831 currency_code : 978 card_number : 5612.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.pennequin03 order_id : 18849 customer_email : jc.pennequin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18850" select * from cms_frontusers where identifiant = "j.vian10" 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 = "18850" select * from cotisations where identifiant = "j.vian10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105132 payment_means : VISA transmission_date : 20161221095132 payment_time : 105308 payment_date : 20161221 response_code : 00 payment_certificate : 07457291e550 authorisation_id : 269275 currency_code : 978 card_number : 4970.81 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.vian10 order_id : 18850 customer_email : j.vian10@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110029 payment_means : VISA transmission_date : 20161221100029 payment_time : 110553 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.barbot08 order_id : 18851 customer_email : jc.barbot08@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18852" select * from cms_frontusers where identifiant = "j.foure29" 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 = "18852" select * from cotisations where identifiant = "j.foure29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110205 payment_means : MASTERCARD transmission_date : 20161221100205 payment_time : 110725 payment_date : 20161221 response_code : 00 payment_certificate : f491c1dbfad8 authorisation_id : 572352 currency_code : 978 card_number : 5137.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 : j.foure29 order_id : 18852 customer_email : j.foure29@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 110524 payment_means : VISA transmission_date : 20161221100524 payment_time : 111056 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.wojtczak15 order_id : 18854 customer_email : n.wojtczak15@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 : 201812 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 : 110635 payment_means : VISA transmission_date : 20161221100635 payment_time : 111338 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.barbot08 order_id : 18851 customer_email : jc.barbot08@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18851" select * from cms_frontusers where identifiant = "jc.barbot08" 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 = "18851" select * from cotisations where identifiant = "jc.barbot08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111355 payment_means : VISA transmission_date : 20161221101355 payment_time : 111733 payment_date : 20161221 response_code : 00 payment_certificate : 68a27163b9b2 authorisation_id : 376642 currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.barbot08 order_id : 18851 customer_email : jc.barbot08@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 : 201812 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 : 16000 transaction_id : 111959 payment_means : VISA transmission_date : 20161221101959 payment_time : 112629 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.wojtczak15 order_id : 18854 customer_email : n.wojtczak15@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18856" select * from cms_frontusers where identifiant = "gh.riviere22" 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 = "18856" select * from cotisations where identifiant = "jm.jarousseau23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114310 payment_means : MASTERCARD transmission_date : 20161221104310 payment_time : 114455 payment_date : 20161221 response_code : 00 payment_certificate : 3dab338a4ecd authorisation_id : 432037 currency_code : 978 card_number : 5132.48 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 : gh.riviere22 order_id : 18856 customer_email : gh.riviere22@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 = "18857" select * from cms_frontusers where identifiant = "gh.riviere22" 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 = "18857" select * from cotisations where identifiant = "r.courbet22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114537 payment_means : MASTERCARD transmission_date : 20161221104537 payment_time : 114641 payment_date : 20161221 response_code : 00 payment_certificate : 5e5aa253c259 authorisation_id : 196543 currency_code : 978 card_number : 5132.48 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 : gh.riviere22 order_id : 18857 customer_email : gh.riviere22@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 = "18855" select * from cms_frontusers where identifiant = "t.coffe26" 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 = "18855" select * from cotisations where identifiant = "t.coffe26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113930 payment_means : MASTERCARD transmission_date : 20161221103930 payment_time : 114724 payment_date : 20161221 response_code : 00 payment_certificate : 67a6492b4772 authorisation_id : 415350 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 : t.coffe26 order_id : 18855 customer_email : t.coffe26@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18858" select * from cms_frontusers where identifiant = "m.hugon10" 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 = "18858" select * from cotisations where identifiant = "m.hugon10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122035 payment_means : VISA transmission_date : 20161221112035 payment_time : 122140 payment_date : 20161221 response_code : 00 payment_certificate : a52cac4759ad authorisation_id : 106622 currency_code : 978 card_number : 4976.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 : m.hugon10 order_id : 18858 customer_email : m.hugon10@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 = "18859" select * from cms_frontusers where identifiant = "a.pierresnard19" 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 = "18859" select * from cotisations where identifiant = "a.pierresnard19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130903 payment_means : VISA transmission_date : 20161221120903 payment_time : 131049 payment_date : 20161221 response_code : 00 payment_certificate : d3ea9102dc5d authorisation_id : 386566 currency_code : 978 card_number : 4978.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.pierresnard19 order_id : 18859 customer_email : a.pierresnard19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 131146 payment_means : MASTERCARD transmission_date : 20161221121146 payment_time : 131318 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.nicodeme10 order_id : 18860 customer_email : f.nicodeme10@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 : 201702 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 : 131333 payment_means : MASTERCARD transmission_date : 20161221121333 payment_time : 131452 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.nicodeme10 order_id : 18860 customer_email : f.nicodeme10@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18861" select * from cms_frontusers where identifiant = "jl.charrier06" 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 = "18861" select * from cotisations where identifiant = "jl.charrier06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134558 payment_means : MASTERCARD transmission_date : 20161221124558 payment_time : 134709 payment_date : 20161221 response_code : 00 payment_certificate : cd8dcc8f1430 authorisation_id : 744239 currency_code : 978 card_number : 5131.11 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.charrier06 order_id : 18861 customer_email : jl.charrier06@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 : 153805 payment_means : VISA transmission_date : 20161221143805 payment_time : 154247 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.deslandes20 order_id : 18863 customer_email : f.deslandes20@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 = "18863" select * from cms_frontusers where identifiant = "f.deslandes20" 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 = "18863" select * from cotisations where identifiant = "p.todeschi04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154301 payment_means : VISA transmission_date : 20161221144301 payment_time : 154359 payment_date : 20161221 response_code : 00 payment_certificate : ac4292abe97f authorisation_id : 030475 currency_code : 978 card_number : 4970.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 : f.deslandes20 order_id : 18863 customer_email : f.deslandes20@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 = "18864" select * from cms_frontusers where identifiant = "jb.fior12" 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 = "18864" select * from cotisations where identifiant = "l.yann09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160343 payment_means : MASTERCARD transmission_date : 20161221150343 payment_time : 160520 payment_date : 20161221 response_code : 00 payment_certificate : 98aad24ea9b5 authorisation_id : 221333 currency_code : 978 card_number : 5131.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 : jb.fior12 order_id : 18864 customer_email : jb.fior12@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 = "18865" select * from cms_frontusers where identifiant = "j.dellapatrona12" 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 = "18865" select * from cotisations where identifiant = "j.dellapatrona12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160610 payment_means : VISA transmission_date : 20161221150610 payment_time : 160853 payment_date : 20161221 response_code : 00 payment_certificate : eb9d4ce989ac authorisation_id : 311435 currency_code : 978 card_number : 4975.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 : j.dellapatrona12 order_id : 18865 customer_email : j.dellapatrona12@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18866" select * from cms_frontusers where identifiant = "jb.fior12" 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 = "18866" select * from cotisations where identifiant = "h.fossat18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161145 payment_means : MASTERCARD transmission_date : 20161221151145 payment_time : 161357 payment_date : 20161221 response_code : 00 payment_certificate : 3bb79f717fe7 authorisation_id : 213177 currency_code : 978 card_number : 5131.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 : jb.fior12 order_id : 18866 customer_email : jb.fior12@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 = "18867" select * from cms_frontusers where identifiant = "jb.fior12" 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 = "18867" select * from cotisations where identifiant = "jm.camps12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161651 payment_means : MASTERCARD transmission_date : 20161221151651 payment_time : 161841 payment_date : 20161221 response_code : 00 payment_certificate : 0c61e5445c3e authorisation_id : 431644 currency_code : 978 card_number : 5131.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 : jb.fior12 order_id : 18867 customer_email : jb.fior12@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 = "18868" select * from cms_frontusers where identifiant = "a.haro16" 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 = "18868" select * from cotisations where identifiant = "a.haro16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 161737 payment_means : MASTERCARD transmission_date : 20161221151737 payment_time : 161941 payment_date : 20161221 response_code : 00 payment_certificate : 688e2540eb2f authorisation_id : 053952 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 : a.haro16 order_id : 18868 customer_email : a.haro16@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 = "18869" select * from cms_frontusers where identifiant = "jb.fior12" 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 = "18869" select * from cotisations where identifiant = "j.brunet29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162111 payment_means : MASTERCARD transmission_date : 20161221152111 payment_time : 162303 payment_date : 20161221 response_code : 00 payment_certificate : 7fe64aa17318 authorisation_id : 412963 currency_code : 978 card_number : 5131.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 : jb.fior12 order_id : 18869 customer_email : jb.fior12@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 = "18870" select * from cms_frontusers where identifiant = "b.dieffenthaler16" 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 = "18870" select * from cotisations where identifiant = "b.dieffenthaler16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163458 payment_means : MASTERCARD transmission_date : 20161221153458 payment_time : 163603 payment_date : 20161221 response_code : 00 payment_certificate : 0b33099e8c78 authorisation_id : 334442 currency_code : 978 card_number : 5132.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 : b.dieffenthaler16 order_id : 18870 customer_email : b.dieffenthaler16@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 = "18871" select * from cms_frontusers where identifiant = "s.vallet18" 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 = "18871" select * from cotisations where identifiant = "s.vallet18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165227 payment_means : VISA transmission_date : 20161221155227 payment_time : 165407 payment_date : 20161221 response_code : 00 payment_certificate : 0ce6e3ec9159 authorisation_id : 559343 currency_code : 978 card_number : 4150.58 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.vallet18 order_id : 18871 customer_email : s.vallet18@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 = "18872" select * from cms_frontusers where identifiant = "b.jannin15" 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 = "18872" select * from cotisations where identifiant = "b.jannin15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181658 payment_means : VISA transmission_date : 20161221171658 payment_time : 181837 payment_date : 20161221 response_code : 00 payment_certificate : ede9532d9cd3 authorisation_id : 283428 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 : b.jannin15 order_id : 18872 customer_email : b.jannin15@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18873" select * from cms_frontusers where identifiant = "e.valable18" 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 = "18873" select * from cotisations where identifiant = "e.valable18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183356 payment_means : VISA transmission_date : 20161221173356 payment_time : 183506 payment_date : 20161221 response_code : 00 payment_certificate : dd4b11da0dd0 authorisation_id : 251616 currency_code : 978 card_number : 4976.44 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.valable18 order_id : 18873 customer_email : e.valable18@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 = "18874" select * from cms_frontusers where identifiant = "g.andrey29" 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 = "18874" select * from cotisations where identifiant = "g.andrey29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183718 payment_means : VISA transmission_date : 20161221173718 payment_time : 184051 payment_date : 20161221 response_code : 00 payment_certificate : 960657865739 authorisation_id : 128931 currency_code : 978 card_number : 4975.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 : g.andrey29 order_id : 18874 customer_email : g.andrey29@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 = "18876" select * from cms_frontusers where identifiant = "m.bracquemont02" 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 = "18876" select * from cotisations where identifiant = "m.bracquemont02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185329 payment_means : MASTERCARD transmission_date : 20161221175329 payment_time : 185502 payment_date : 20161221 response_code : 00 payment_certificate : 05c9f43f5dac authorisation_id : 443497 currency_code : 978 card_number : 5135.63 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.bracquemont02 order_id : 18876 customer_email : m.bracquemont02@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 : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18875" select * from cms_frontusers where identifiant = "jr.boiselet12" 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 = "18875" select * from cotisations where identifiant = "jr.boiselet12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185253 payment_means : VISA transmission_date : 20161221175253 payment_time : 185515 payment_date : 20161221 response_code : 00 payment_certificate : 49659c584920 authorisation_id : 136324 currency_code : 978 card_number : 4970.16 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 : jr.boiselet12 order_id : 18875 customer_email : jr.boiselet12@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 = "18877" select * from cms_frontusers where identifiant = "l.talon07" 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 = "18877" select * from cotisations where identifiant = "l.talon07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185803 payment_means : MASTERCARD transmission_date : 20161221175803 payment_time : 185949 payment_date : 20161221 response_code : 00 payment_certificate : 5fc9c3c573e8 authorisation_id : 253150 currency_code : 978 card_number : 5131.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 : l.talon07 order_id : 18877 customer_email : l.talon07@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 = "18878" select * from cms_frontusers where identifiant = "f.madelenat10" 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 = "18878" select * from cotisations where identifiant = "f.madelenat10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192944 payment_means : VISA transmission_date : 20161221182944 payment_time : 193121 payment_date : 20161221 response_code : 00 payment_certificate : 857be4606c0e authorisation_id : 265832 currency_code : 978 card_number : 4974.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 : f.madelenat10 order_id : 18878 customer_email : f.madelenat10@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18879" select * from cms_frontusers where identifiant = "e.hours31" 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 = "18879" select * from cotisations where identifiant = "e.hours31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194341 payment_means : VISA transmission_date : 20161221184341 payment_time : 194726 payment_date : 20161221 response_code : 00 payment_certificate : 907fc3218ea7 authorisation_id : 116593 currency_code : 978 card_number : 4978.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 : e.hours31 order_id : 18879 customer_email : e.hours31@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 : 201909 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 : 200150 payment_means : VISA transmission_date : 20161221190150 payment_time : 200346 payment_date : 20161221 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 56 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bodin11 order_id : 18880 customer_email : p.bodin11@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 = "18880" select * from cms_frontusers where identifiant = "p.bodin11" 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 = "18880" select * from cotisations where identifiant = "p.bodin11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200407 payment_means : VISA transmission_date : 20161221190407 payment_time : 200530 payment_date : 20161221 response_code : 00 payment_certificate : ece26ed7969b authorisation_id : 121144 currency_code : 978 card_number : 4973.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bodin11 order_id : 18880 customer_email : p.bodin11@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 = "18881" select * from cms_frontusers where identifiant = "n.rolet25" 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 = "18881" select * from cotisations where identifiant = "n.rolet25" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "18882" select * from cms_frontusers where identifiant = "h.caron03" 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 = "18882" select * from cotisations where identifiant = "h.caron03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201035 payment_means : VISA transmission_date : 20161221191035 payment_time : 201212 payment_date : 20161221 response_code : 00 payment_certificate : 572a442ab88e authorisation_id : 952327 currency_code : 978 card_number : 4978.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.rolet25 order_id : 18881 customer_email : n.rolet25@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 : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201040 payment_means : VISA transmission_date : 20161221191040 payment_time : 201256 payment_date : 20161221 response_code : 00 payment_certificate : e250cced5b76 authorisation_id : 518102 currency_code : 978 card_number : 4974.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 : h.caron03 order_id : 18882 customer_email : h.caron03@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18883" select * from cms_frontusers where identifiant = "m.bouvet27" 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 = "18883" select * from cotisations where identifiant = "m.bouvet27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201636 payment_means : VISA transmission_date : 20161221191636 payment_time : 201835 payment_date : 20161221 response_code : 00 payment_certificate : 8121ec3b2b94 authorisation_id : 234048 currency_code : 978 card_number : 4978.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.bouvet27 order_id : 18883 customer_email : m.bouvet27@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 = "18886" select * from cms_frontusers where identifiant = "m.claparede08" 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 = "18886" select * from cotisations where identifiant = "m.claparede08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201912 payment_means : MASTERCARD transmission_date : 20161221191912 payment_time : 202234 payment_date : 20161221 response_code : 00 payment_certificate : a89a2256ae1f authorisation_id : 634338 currency_code : 978 card_number : 5132.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 : m.claparede08 order_id : 18886 customer_email : m.claparede08@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 = "18885" select * from cms_frontusers where identifiant = "t.batiot12" 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 = "18885" select * from cotisations where identifiant = "t.batiot12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201906 payment_means : MASTERCARD transmission_date : 20161221191906 payment_time : 202328 payment_date : 20161221 response_code : 00 payment_certificate : 052e513dbe5b authorisation_id : 502936 currency_code : 978 card_number : 5131.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.batiot12 order_id : 18885 customer_email : t.batiot12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18887" select * from cms_frontusers where identifiant = "h.caron03" 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 = "18887" select * from cotisations where identifiant = "t.hirigoyenmontreu13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202244 payment_means : VISA transmission_date : 20161221192244 payment_time : 202419 payment_date : 20161221 response_code : 00 payment_certificate : dbbd0f829803 authorisation_id : 252558 currency_code : 978 card_number : 4974.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 : h.caron03 order_id : 18887 customer_email : h.caron03@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18888" select * from cms_frontusers where identifiant = "jf.delahamayde25" 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 = "18888" select * from cotisations where identifiant = "jf.delahamayde25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202700 payment_means : VISA transmission_date : 20161221192700 payment_time : 203123 payment_date : 20161221 response_code : 00 payment_certificate : 510ba4e37494 authorisation_id : 502623 currency_code : 978 card_number : 4974.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jf.delahamayde25 order_id : 18888 customer_email : jf.delahamayde25@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 = "18890" select * from cms_frontusers where identifiant = "c.avril17" 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 = "18890" select * from cotisations where identifiant = "c.avril17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203455 payment_means : MASTERCARD transmission_date : 20161221193455 payment_time : 203704 payment_date : 20161221 response_code : 00 payment_certificate : cab5fe7846a6 authorisation_id : 011959 currency_code : 978 card_number : 5131.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 : c.avril17 order_id : 18890 customer_email : c.avril17@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 = "18892" select * from cms_frontusers where identifiant = "g.bourcier05" 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 = "18892" select * from cotisations where identifiant = "g.bourcier05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203601 payment_means : VISA transmission_date : 20161221193601 payment_time : 203838 payment_date : 20161221 response_code : 00 payment_certificate : 7b4d1b60c7ad authorisation_id : 202536 currency_code : 978 card_number : 4975.35 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.bourcier05 order_id : 18892 customer_email : g.bourcier05@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 = "18893" select * from cms_frontusers where identifiant = "i.escolivet04" 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 = "18893" select * from cotisations where identifiant = "i.escolivet04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203809 payment_means : MASTERCARD transmission_date : 20161221193809 payment_time : 204133 payment_date : 20161221 response_code : 00 payment_certificate : 52b40b9b57f3 authorisation_id : 706501 currency_code : 978 card_number : 5132.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 : i.escolivet04 order_id : 18893 customer_email : i.escolivet04@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 = "18895" select * from cms_frontusers where identifiant = "p.bielin19" 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 = "18895" select * from cotisations where identifiant = "p.bielin19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204838 payment_means : VISA transmission_date : 20161221194838 payment_time : 205021 payment_date : 20161221 response_code : 00 payment_certificate : 46f81aa847c3 authorisation_id : 334287 currency_code : 978 card_number : 4970.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bielin19 order_id : 18895 customer_email : p.bielin19@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 = "18896" select * from cms_frontusers where identifiant = "c.hercelemore19" 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 = "18896" select * from cotisations where identifiant = "c.hercelemore19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204946 payment_means : VISA transmission_date : 20161221194946 payment_time : 205116 payment_date : 20161221 response_code : 00 payment_certificate : 89b0b0226075 authorisation_id : 643884 currency_code : 978 card_number : 4975.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 : c.hercelemore19 order_id : 18896 customer_email : c.hercelemore19@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 = "18897" select * from cms_frontusers where identifiant = "m.buffard09" 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 = "18897" select * from cotisations where identifiant = "m.buffard09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205453 payment_means : MASTERCARD transmission_date : 20161221195453 payment_time : 205641 payment_date : 20161221 response_code : 00 payment_certificate : 86974f6dab1a authorisation_id : 640698 currency_code : 978 card_number : 5132.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 : m.buffard09 order_id : 18897 customer_email : m.buffard09@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 = "18898" select * from cms_frontusers where identifiant = "jb.pintiaux13" 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 = "18898" select * from cotisations where identifiant = "jb.pintiaux13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210517 payment_means : VISA transmission_date : 20161221200517 payment_time : 210959 payment_date : 20161221 response_code : 00 payment_certificate : caa82d14b26e authorisation_id : 564433 currency_code : 978 card_number : 4973.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 : jb.pintiaux13 order_id : 18898 customer_email : jb.pintiaux13@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 : 201903 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 : 211002 payment_means : MASTERCARD transmission_date : 20161221201002 payment_time : 211034 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.ligeois09 order_id : 18899 customer_email : d.ligeois09@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 = "18900" select * from cms_frontusers where identifiant = "y.guillochou15" 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 = "18900" select * from cotisations where identifiant = "y.guillochou15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211026 payment_means : VISA transmission_date : 20161221201026 payment_time : 211126 payment_date : 20161221 response_code : 00 payment_certificate : 6ce35ea09910 authorisation_id : 622324 currency_code : 978 card_number : 4150.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.guillochou15 order_id : 18900 customer_email : y.guillochou15@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 = "18901" select * from cms_frontusers where identifiant = "l.leonetti19" 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 = "18901" select * from cotisations where identifiant = "l.leonetti19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211322 payment_means : VISA transmission_date : 20161221201322 payment_time : 211555 payment_date : 20161221 response_code : 00 payment_certificate : 58a944a4a365 authorisation_id : 925021 currency_code : 978 card_number : 4978.14 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.leonetti19 order_id : 18901 customer_email : l.leonetti19@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 = "18903" select * from cms_frontusers where identifiant = "m.bonnici16" 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 = "18903" select * from cotisations where identifiant = "m.bonnici16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212722 payment_means : MASTERCARD transmission_date : 20161221202722 payment_time : 212840 payment_date : 20161221 response_code : 00 payment_certificate : 87e5b2e86719 authorisation_id : 237145 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 : m.bonnici16 order_id : 18903 customer_email : m.bonnici16@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 = "18905" select * from cms_frontusers where identifiant = "f.bianchi03" 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 = "18905" select * from cotisations where identifiant = "f.bianchi03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214420 payment_means : VISA transmission_date : 20161221204420 payment_time : 214532 payment_date : 20161221 response_code : 00 payment_certificate : 45aa3034af95 authorisation_id : 945493 currency_code : 978 card_number : 4562.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bianchi03 order_id : 18905 customer_email : f.bianchi03@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18906" select * from cms_frontusers where identifiant = "n.vieux18" 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 = "18906" select * from cotisations where identifiant = "n.vieux18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215816 payment_means : MASTERCARD transmission_date : 20161221205816 payment_time : 220033 payment_date : 20161221 response_code : 00 payment_certificate : 22b61c8331a9 authorisation_id : 028454 currency_code : 978 card_number : 5131.77 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.vieux18 order_id : 18906 customer_email : n.vieux18@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18907" select * from cms_frontusers where identifiant = "n.vieux18" 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 = "18907" select * from cotisations where identifiant = "b.brognara07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220158 payment_means : MASTERCARD transmission_date : 20161221210158 payment_time : 220325 payment_date : 20161221 response_code : 00 payment_certificate : 4b518ca25564 authorisation_id : 574521 currency_code : 978 card_number : 5131.77 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.vieux18 order_id : 18907 customer_email : n.vieux18@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18908" select * from cms_frontusers where identifiant = "f.gervais13" 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 = "18908" select * from cotisations where identifiant = "f.gervais13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222024 payment_means : VISA transmission_date : 20161221212024 payment_time : 222220 payment_date : 20161221 response_code : 00 payment_certificate : afc4239a30b4 authorisation_id : 153622 currency_code : 978 card_number : 4978.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 : f.gervais13 order_id : 18908 customer_email : f.gervais13@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 : 4000 transaction_id : 222517 payment_means : MASTERCARD transmission_date : 20161221212517 payment_time : 222658 payment_date : 20161221 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5539.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.martigne02 order_id : 18909 customer_email : a.martigne02@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 : 201905 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 : 234925 payment_means : MASTERCARD transmission_date : 20161221224925 payment_time : 235358 payment_date : 20161221 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 61 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.delabare19 order_id : 18910 customer_email : g.delabare19@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------