select * from cotisations_commande where id = "12534" select * from cms_frontusers where identifiant = "jl.gouel04" 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 = "12534" select * from cotisations where identifiant = "jl.gouel04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 051208 payment_means : MASTERCARD transmission_date : 20160111041208 payment_time : 051533 payment_date : 20160111 response_code : 00 payment_certificate : 497c91452581 authorisation_id : 421609 currency_code : 978 card_number : 5131.74 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.gouel04 order_id : 12534 customer_email : jl.gouel04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12535" select * from cms_frontusers where identifiant = "jl.gouel04" 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 = "12535" select * from cotisations where identifiant = "a.issertes14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 051903 payment_means : MASTERCARD transmission_date : 20160111041903 payment_time : 052031 payment_date : 20160111 response_code : 00 payment_certificate : b0c5fbc43b03 authorisation_id : 654188 currency_code : 978 card_number : 5131.74 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.gouel04 order_id : 12535 customer_email : jl.gouel04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 052839 payment_means : MASTERCARD transmission_date : 20160111042839 payment_time : 053035 payment_date : 20160111 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.74 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 : jl.gouel04 order_id : 12536 customer_email : jl.gouel04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12536" select * from cms_frontusers where identifiant = "jl.gouel04" 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 = "12536" select * from cotisations where identifiant = "e.rossignol20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 053227 payment_means : MASTERCARD transmission_date : 20160111043227 payment_time : 053408 payment_date : 20160111 response_code : 00 payment_certificate : f53e7c459e7b authorisation_id : 221513 currency_code : 978 card_number : 5131.74 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.gouel04 order_id : 12536 customer_email : jl.gouel04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12537" select * from cms_frontusers where identifiant = "jl.gouel04" 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 = "12537" select * from cotisations where identifiant = "c.ragot18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 053633 payment_means : MASTERCARD transmission_date : 20160111043633 payment_time : 053807 payment_date : 20160111 response_code : 00 payment_certificate : 38ce50096907 authorisation_id : 252145 currency_code : 978 card_number : 5131.74 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.gouel04 order_id : 12537 customer_email : jl.gouel04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12538" select * from cms_frontusers where identifiant = "s.jacquemot01" 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 = "12538" select * from cotisations where identifiant = "s.jacquemot01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 055112 payment_means : MASTERCARD transmission_date : 20160111045112 payment_time : 055333 payment_date : 20160111 response_code : 00 payment_certificate : 8e8022e06387 authorisation_id : 203504 currency_code : 978 card_number : 5136.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.jacquemot01 order_id : 12538 customer_email : s.jacquemot01@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 : 071709 payment_means : VISA transmission_date : 20160111061709 payment_time : 071827 payment_date : 20160111 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.18 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.brun21 order_id : 12539 customer_email : p.brun21@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 = "12539" select * from cms_frontusers where identifiant = "p.brun21" 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 = "12539" select * from cotisations where identifiant = "p.brun21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071835 payment_means : VISA transmission_date : 20160111061835 payment_time : 072415 payment_date : 20160111 response_code : 00 payment_certificate : 23171b069f6e authorisation_id : 454809 currency_code : 978 card_number : 4977.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 : p.brun21 order_id : 12539 customer_email : p.brun21@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 = "12540" select * from cms_frontusers where identifiant = "j.lecuyer28" 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 = "12540" select * from cotisations where identifiant = "j.lecuyer28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091538 payment_means : MASTERCARD transmission_date : 20160111081538 payment_time : 091913 payment_date : 20160111 response_code : 00 payment_certificate : f0e82ad19288 authorisation_id : 672584 currency_code : 978 card_number : 5137.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 : j.lecuyer28 order_id : 12540 customer_email : j.lecuyer28@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 = "12542" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "12542" select * from cotisations where identifiant = "a.coudurier27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112610 payment_means : VISA transmission_date : 20160111102610 payment_time : 112814 payment_date : 20160111 response_code : 00 payment_certificate : 668dfec8ff74 authorisation_id : 344821 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12542 customer_email : f.bureau27@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 = "12543" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "12543" select * from cotisations where identifiant = "e.bouclet29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113309 payment_means : VISA transmission_date : 20160111103309 payment_time : 113441 payment_date : 20160111 response_code : 00 payment_certificate : 98c31d214671 authorisation_id : 226765 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12543 customer_email : f.bureau27@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 = "12544" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "12544" select * from cotisations where identifiant = "j.bouclet24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113735 payment_means : VISA transmission_date : 20160111103735 payment_time : 113905 payment_date : 20160111 response_code : 00 payment_certificate : e4dd8168e79b authorisation_id : 563311 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12544 customer_email : f.bureau27@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 = "12545" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "12545" select * from cotisations where identifiant = "t.pujolas28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 114045 payment_means : VISA transmission_date : 20160111104045 payment_time : 114211 payment_date : 20160111 response_code : 00 payment_certificate : c7595f3debe4 authorisation_id : 267462 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12545 customer_email : f.bureau27@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 = "12546" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "12546" select * from cotisations where identifiant = "v.jolit19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114316 payment_means : VISA transmission_date : 20160111104316 payment_time : 114448 payment_date : 20160111 response_code : 00 payment_certificate : f95ce964dd8c authorisation_id : 152923 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12546 customer_email : f.bureau27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114553 payment_means : VISA transmission_date : 20160111104553 payment_time : 114727 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12547 customer_email : f.bureau27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114745 payment_means : VISA transmission_date : 20160111104745 payment_time : 114933 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12547 customer_email : f.bureau27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115149 payment_means : VISA transmission_date : 20160111105149 payment_time : 115318 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12548 customer_email : f.bureau27@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 = "12551" select * from cms_frontusers where identifiant = "j.sassu18" 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 = "12551" select * from cotisations where identifiant = "k.durand18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123052 payment_means : MASTERCARD transmission_date : 20160111113052 payment_time : 123215 payment_date : 20160111 response_code : 00 payment_certificate : 386f792749d9 authorisation_id : 844071 currency_code : 978 card_number : 5131.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 : j.sassu18 order_id : 12551 customer_email : j.sassu18@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123629 payment_means : VISA transmission_date : 20160111113629 payment_time : 123814 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.bureau27 order_id : 12552 customer_email : f.bureau27@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 = "12554" select * from cms_frontusers where identifiant = "g.heilles22" 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 = "12554" select * from cotisations where identifiant = "g.heilles22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132412 payment_means : VISA transmission_date : 20160111122412 payment_time : 132735 payment_date : 20160111 response_code : 00 payment_certificate : 1d9728038e1f authorisation_id : 315022 currency_code : 978 card_number : 4972.57 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.heilles22 order_id : 12554 customer_email : g.heilles22@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 = "12555" select * from cms_frontusers where identifiant = "jm.brosset06" 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 = "12555" select * from cotisations where identifiant = "jm.brosset06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142351 payment_means : VISA transmission_date : 20160111132351 payment_time : 143155 payment_date : 20160111 response_code : 00 payment_certificate : 1a8542698dc1 authorisation_id : 619623 currency_code : 978 card_number : 4977.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.brosset06 order_id : 12555 customer_email : jm.brosset06@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 = "12556" select * from cms_frontusers where identifiant = "j.lemartinel15" 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 = "12556" select * from cotisations where identifiant = "k.philippe27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150026 payment_means : VISA transmission_date : 20160111140026 payment_time : 150416 payment_date : 20160111 response_code : 00 payment_certificate : c2f685e3466c authorisation_id : 938420 currency_code : 978 card_number : 4976.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 : j.lemartinel15 order_id : 12556 customer_email : j.lemartinel15@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 = "12557" select * from cms_frontusers where identifiant = "j.lemartinel15" 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 = "12557" select * from cotisations where identifiant = "k.philippe27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150646 payment_means : VISA transmission_date : 20160111140646 payment_time : 150845 payment_date : 20160111 response_code : 00 payment_certificate : 90ef95652f5b authorisation_id : 622882 currency_code : 978 card_number : 4976.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 : j.lemartinel15 order_id : 12557 customer_email : j.lemartinel15@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 = "12559" select * from cms_frontusers where identifiant = "p.ferreira28" 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 = "12559" select * from cotisations where identifiant = "p.ferreira28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170939 payment_means : VISA transmission_date : 20160111160939 payment_time : 171144 payment_date : 20160111 response_code : 00 payment_certificate : c9f0e1ef3ee3 authorisation_id : 796244 currency_code : 978 card_number : 4977.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 : p.ferreira28 order_id : 12559 customer_email : p.ferreira28@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 = "12561" select * from cms_frontusers where identifiant = "e.simplot10" 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 = "12561" select * from cotisations where identifiant = "e.simplot10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174552 payment_means : VISA transmission_date : 20160111164552 payment_time : 174818 payment_date : 20160111 response_code : 00 payment_certificate : 28c153e807bb authorisation_id : 188211 currency_code : 978 card_number : 4562.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 : e.simplot10 order_id : 12561 customer_email : e.simplot10@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 = "12562" select * from cms_frontusers where identifiant = "r.chabeaudie26" 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 = "12562" select * from cotisations where identifiant = "r.chabeaudie26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185913 payment_means : VISA transmission_date : 20160111175913 payment_time : 190111 payment_date : 20160111 response_code : 00 payment_certificate : 2ec5373b35fc authorisation_id : 742788 currency_code : 978 card_number : 4978.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.chabeaudie26 order_id : 12562 customer_email : r.chabeaudie26@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 = "12563" select * from cms_frontusers where identifiant = "j.tanchoux03" 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 = "12563" select * from cotisations where identifiant = "n.hillion05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193120 payment_means : MASTERCARD transmission_date : 20160111183120 payment_time : 193317 payment_date : 20160111 response_code : 00 payment_certificate : 17bebf525137 authorisation_id : 627413 currency_code : 978 card_number : 5137.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 : j.tanchoux03 order_id : 12563 customer_email : j.tanchoux03@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 = "12564" select * from cms_frontusers where identifiant = "c.cosnier13" 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 = "12564" select * from cotisations where identifiant = "c.cosnier13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193253 payment_means : VISA transmission_date : 20160111183253 payment_time : 193632 payment_date : 20160111 response_code : 00 payment_certificate : f48d2e93836c authorisation_id : 554181 currency_code : 978 card_number : 4976.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 : c.cosnier13 order_id : 12564 customer_email : c.cosnier13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12565" select * from cms_frontusers where identifiant = "jl.hybois23" 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 = "12565" select * from cotisations where identifiant = "hl.david30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193707 payment_means : VISA transmission_date : 20160111183707 payment_time : 194134 payment_date : 20160111 response_code : 00 payment_certificate : 7a7ea0d7cc3f authorisation_id : 221462 currency_code : 978 card_number : 4972.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 : jl.hybois23 order_id : 12565 customer_email : jl.hybois23@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194532 payment_means : VISA transmission_date : 20160111184532 payment_time : 194852 payment_date : 20160111 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.68 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 : k.vergez20 order_id : 12568 customer_email : k.vergez20@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12567" select * from cms_frontusers where identifiant = "j.tanchoux03" 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 = "12567" select * from cotisations where identifiant = "y.schlawick26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194931 payment_means : VISA transmission_date : 20160111184931 payment_time : 195128 payment_date : 20160111 response_code : 00 payment_certificate : 0dcb5c23a802 authorisation_id : 698452 currency_code : 978 card_number : 4533.61 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.tanchoux03 order_id : 12567 customer_email : j.tanchoux03@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 = "12568" select * from cms_frontusers where identifiant = "k.vergez20" 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 = "12568" select * from cotisations where identifiant = "k.vergez20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194904 payment_means : MASTERCARD transmission_date : 20160111184904 payment_time : 195139 payment_date : 20160111 response_code : 00 payment_certificate : ea0ef97cbd0d authorisation_id : 814526 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 : k.vergez20 order_id : 12568 customer_email : k.vergez20@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 = "12571" select * from cms_frontusers where identifiant = "jb.noe28" 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 = "12571" select * from cotisations where identifiant = "jb.noe28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200803 payment_means : MASTERCARD transmission_date : 20160111190803 payment_time : 200913 payment_date : 20160111 response_code : 00 payment_certificate : 60298b615aa5 authorisation_id : 164943 currency_code : 978 card_number : 5131.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 : jb.noe28 order_id : 12571 customer_email : jb.noe28@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 = "12572" select * from cms_frontusers where identifiant = "e.bidino09" 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 = "12572" select * from cotisations where identifiant = "e.bidino09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200851 payment_means : MASTERCARD transmission_date : 20160111190851 payment_time : 201059 payment_date : 20160111 response_code : 00 payment_certificate : e2551bedcfa5 authorisation_id : 023798 currency_code : 978 card_number : 5132.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 : e.bidino09 order_id : 12572 customer_email : e.bidino09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12573" select * from cms_frontusers where identifiant = "y.guerif02" 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 = "12573" select * from cotisations where identifiant = "y.guerif02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201115 payment_means : MASTERCARD transmission_date : 20160111191115 payment_time : 201251 payment_date : 20160111 response_code : 00 payment_certificate : f5135f6b89bc authorisation_id : 958373 currency_code : 978 card_number : 5131.99 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.guerif02 order_id : 12573 customer_email : y.guerif02@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 = "12574" select * from cms_frontusers where identifiant = "r.libon21" 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 = "12574" select * from cotisations where identifiant = "r.libon21" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201413 payment_means : MASTERCARD transmission_date : 20160111191413 payment_time : 201631 payment_date : 20160111 response_code : 00 payment_certificate : 5600f01cc20a authorisation_id : 495168 currency_code : 978 card_number : 5133.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 : r.libon21 order_id : 12574 customer_email : r.libon21@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 = "12575" select * from cms_frontusers where identifiant = "d.rivalan24" 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 = "12575" select * from cotisations where identifiant = "d.rivalan24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202559 payment_means : VISA transmission_date : 20160111192559 payment_time : 202718 payment_date : 20160111 response_code : 00 payment_certificate : d0538be18c80 authorisation_id : 063960 currency_code : 978 card_number : 4970.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 : d.rivalan24 order_id : 12575 customer_email : d.rivalan24@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 = "12576" select * from cms_frontusers where identifiant = "a.dupin20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "12576" select * from cotisations where identifiant = "a.dupin20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203801 payment_means : MASTERCARD transmission_date : 20160111193801 payment_time : 203923 payment_date : 20160111 response_code : 00 payment_certificate : a6a8ccd036d0 authorisation_id : 307631 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 : a.dupin20 order_id : 12576 customer_email : a.dupin20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 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 : 4000 transaction_id : 210358 payment_means : MASTERCARD transmission_date : 20160111200358 payment_time : 210838 payment_date : 20160111 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.denis13 order_id : 12581 customer_email : j.denis13@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 : 201610 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 : 211203 payment_means : MASTERCARD transmission_date : 20160111201203 payment_time : 211423 payment_date : 20160111 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.denis13 order_id : 12582 customer_email : j.denis13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212534 payment_means : VISA transmission_date : 20160111202534 payment_time : 212825 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.delia08 order_id : 12584 customer_email : s.delia08@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 : 4000 transaction_id : 212845 payment_means : VISA transmission_date : 20160111202845 payment_time : 213000 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.delia08 order_id : 12584 customer_email : s.delia08@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 : 4000 transaction_id : 213135 payment_means : VISA transmission_date : 20160111203135 payment_time : 213257 payment_date : 20160111 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.delia08 order_id : 12584 customer_email : s.delia08@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 = "12585" select * from cms_frontusers where identifiant = "p1.lacroix17" 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 = "12585" select * from cotisations where identifiant = "p.verquere03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213001 payment_means : VISA transmission_date : 20160111203001 payment_time : 213734 payment_date : 20160111 response_code : 00 payment_certificate : 253056e3eb6e authorisation_id : 830411 currency_code : 978 card_number : 4973.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 : p1.lacroix17 order_id : 12585 customer_email : p1.lacroix17@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 = "12586" select * from cms_frontusers where identifiant = "l.colin15" 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 = "12586" select * from cotisations where identifiant = "l.colin15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213625 payment_means : MASTERCARD transmission_date : 20160111203625 payment_time : 213807 payment_date : 20160111 response_code : 00 payment_certificate : 4d77eaeddf02 authorisation_id : 040646 currency_code : 978 card_number : 5136.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.colin15 order_id : 12586 customer_email : l.colin15@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 = "12587" select * from cms_frontusers where identifiant = "s.jacquillet14" 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 = "12587" select * from cotisations where identifiant = "s.jacquillet14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214107 payment_means : VISA transmission_date : 20160111204107 payment_time : 214555 payment_date : 20160111 response_code : 00 payment_certificate : 3accd57a1b2b authorisation_id : 501309 currency_code : 978 card_number : 4979.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.jacquillet14 order_id : 12587 customer_email : s.jacquillet14@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 = "12588" select * from cms_frontusers where identifiant = "c.ferrier08" 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 = "12588" select * from cotisations where identifiant = "c.ferrier08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215134 payment_means : MASTERCARD transmission_date : 20160111205134 payment_time : 215339 payment_date : 20160111 response_code : 00 payment_certificate : 0975c517e315 authorisation_id : 161222 currency_code : 978 card_number : 5131.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.ferrier08 order_id : 12588 customer_email : c.ferrier08@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 = "12589" select * from cms_frontusers where identifiant = "p.kitsos27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "12589" select * from cotisations where identifiant = "p.kitsos27" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "p.kitsos27" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "v.bretaudeau09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 215823 payment_means : MASTERCARD transmission_date : 20160111205823 payment_time : 215943 payment_date : 20160111 response_code : 00 payment_certificate : d45aff2c4ab7 authorisation_id : 423624 currency_code : 978 card_number : 5131.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.kitsos27 order_id : 12589 customer_email : p.kitsos27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "12591" select * from cms_frontusers where identifiant = "je.leguyader30" 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 = "12591" select * from cotisations where identifiant = "je.leguyader30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220339 payment_means : MASTERCARD transmission_date : 20160111210339 payment_time : 220522 payment_date : 20160111 response_code : 00 payment_certificate : 525ccc6f402f authorisation_id : 639593 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 : je.leguyader30 order_id : 12591 customer_email : je.leguyader30@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 = "12590" select * from cms_frontusers where identifiant = "t.colon19" 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 = "12590" select * from cotisations where identifiant = "t.colon19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220022 payment_means : VISA transmission_date : 20160111210022 payment_time : 220557 payment_date : 20160111 response_code : 00 payment_certificate : 11624f87fd89 authorisation_id : 136152 currency_code : 978 card_number : 4561.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 : t.colon19 order_id : 12590 customer_email : t.colon19@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 : -------------------------------------------