select * from cotisations_commande where id = "2351" select * from cms_frontusers where identifiant = "p.lerouxel12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2351" select * from cotisations where identifiant = "p.lerouxel12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070527 payment_means : VISA transmission_date : 20141105060527 payment_time : 070646 payment_date : 20141105 response_code : 00 payment_certificate : d0bf19468b7d authorisation_id : 492322 currency_code : 978 card_number : 4973.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lerouxel12 order_id : 2351 customer_email : p.lerouxel12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201501 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 : 075613 payment_means : MASTERCARD transmission_date : 20141105065613 payment_time : 075755 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.87 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 : q.houot14 order_id : 2352 customer_email : q.houot14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2354" select * from cms_frontusers where identifiant = "e.chevance24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2354" select * from cotisations where identifiant = "e.chevance24" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084256 payment_means : MASTERCARD transmission_date : 20141105074256 payment_time : 084819 payment_date : 20141105 response_code : 00 payment_certificate : 146d3320ea21 authorisation_id : 243435 currency_code : 978 card_number : 5341.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 : e.chevance24 order_id : 2354 customer_email : e.chevance24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201505 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 : 084312 payment_means : VISA transmission_date : 20141105074312 payment_time : 084932 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.45 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.magne03 order_id : 2355 customer_email : f.magne03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2356" select * from cms_frontusers where identifiant = "e.chevance24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2356" select * from cotisations where identifiant = "e.chevance24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084940 payment_means : MASTERCARD transmission_date : 20141105074940 payment_time : 085103 payment_date : 20141105 response_code : 00 payment_certificate : 4ee8b65bb4b0 authorisation_id : 231035 currency_code : 978 card_number : 5341.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 : e.chevance24 order_id : 2356 customer_email : e.chevance24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201505 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 : 084955 payment_means : VISA transmission_date : 20141105074955 payment_time : 085332 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.45 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.magne03 order_id : 2355 customer_email : f.magne03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2357" select * from cms_frontusers where identifiant = "r.cabot03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2357" select * from cotisations where identifiant = "r.cabot03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102428 payment_means : MASTERCARD transmission_date : 20141105092428 payment_time : 102634 payment_date : 20141105 response_code : 00 payment_certificate : d5bb63d6021c authorisation_id : 112124 currency_code : 978 card_number : 5131.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.cabot03 order_id : 2357 customer_email : r.cabot03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201411 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2358" select * from cms_frontusers where identifiant = "r.camus15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2358" select * from cotisations where identifiant = "r.camus15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104133 payment_means : VISA transmission_date : 20141105094133 payment_time : 104405 payment_date : 20141105 response_code : 00 payment_certificate : 05a153078622 authorisation_id : 775463 currency_code : 978 card_number : 4970.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.camus15 order_id : 2358 customer_email : r.camus15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201412 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110519 payment_means : VISA transmission_date : 20141105100519 payment_time : 110705 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.44 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.venien26 order_id : 2359 customer_email : p.venien26@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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2360" select * from cms_frontusers where identifiant = "a.lovichi29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2360" select * from cotisations where identifiant = "a.lovichi29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122906 payment_means : VISA transmission_date : 20141105112906 payment_time : 123129 payment_date : 20141105 response_code : 00 payment_certificate : 07a75a957ebf authorisation_id : 153749 currency_code : 978 card_number : 4976.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 : a.lovichi29 order_id : 2360 customer_email : a.lovichi29@compagnons-du-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 = "2361" select * from cms_frontusers where identifiant = "x.rico10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2361" select * from cotisations where identifiant = "x.rico10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130017 payment_means : VISA transmission_date : 20141105120017 payment_time : 130138 payment_date : 20141105 response_code : 00 payment_certificate : 30dedb99be0f authorisation_id : 003643 currency_code : 978 card_number : 4974.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.rico10 order_id : 2361 customer_email : x.rico10@compagnons-du-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 = "2362" select * from cms_frontusers where identifiant = "p.venien26" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2362" select * from cotisations where identifiant = "p.venien26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131440 payment_means : VISA transmission_date : 20141105121440 payment_time : 131819 payment_date : 20141105 response_code : 00 payment_certificate : 73eda2ea0690 authorisation_id : 062459 currency_code : 978 card_number : 4970.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 : p.venien26 order_id : 2362 customer_email : p.venien26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2363" select * from cms_frontusers where identifiant = "g.hillion10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2363" select * from cotisations where identifiant = "g.hillion10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151056 payment_means : MASTERCARD transmission_date : 20141105141056 payment_time : 151423 payment_date : 20141105 response_code : 00 payment_certificate : 9688f0666166 authorisation_id : 596566 currency_code : 978 card_number : 5137.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 : g.hillion10 order_id : 2363 customer_email : g.hillion10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152604 payment_means : VISA transmission_date : 20141105142604 payment_time : 153158 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.lefort13 order_id : 2365 customer_email : l.lefort13@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 : 201506 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2366" select * from cms_frontusers where identifiant = "l.ogez09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2366" select * from cotisations where identifiant = "l.ogez09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181246 payment_means : VISA transmission_date : 20141105171246 payment_time : 181433 payment_date : 20141105 response_code : 00 payment_certificate : 20854ecb5763 authorisation_id : 163236 currency_code : 978 card_number : 4978.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.ogez09 order_id : 2366 customer_email : l.ogez09@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182139 payment_means : VISA transmission_date : 20141105172139 payment_time : 182722 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.99 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.vandenbroucke22 order_id : 2367 customer_email : p.vandenbroucke22@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2368" select * from cms_frontusers where identifiant = "m.fevrier15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2368" select * from cotisations where identifiant = "m.fevrier15" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183017 payment_means : MASTERCARD transmission_date : 20141105173017 payment_time : 183224 payment_date : 20141105 response_code : 00 payment_certificate : cca758ee2d8f authorisation_id : 538499 currency_code : 978 card_number : 5131.45 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.fevrier15 order_id : 2368 customer_email : m.fevrier15@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182731 payment_means : VISA transmission_date : 20141105172731 payment_time : 183257 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.99 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.vandenbroucke22 order_id : 2367 customer_email : p.vandenbroucke22@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2369" select * from cms_frontusers where identifiant = "v.janot10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2369" select * from cotisations where identifiant = "v.janot10" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184210 payment_means : MASTERCARD transmission_date : 20141105174210 payment_time : 184342 payment_date : 20141105 response_code : 00 payment_certificate : 2143be62a777 authorisation_id : 386490 currency_code : 978 card_number : 5131.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.janot10 order_id : 2369 customer_email : v.janot10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201608 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194319 payment_means : MASTERCARD transmission_date : 20141105184319 payment_time : 194417 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.58 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 : h.fritsch29 order_id : 2370 customer_email : h.fritsch29@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2372" select * from cms_frontusers where identifiant = "p.lemoing19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2372" select * from cotisations where identifiant = "p.lemoing19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200609 payment_means : VISA transmission_date : 20141105190609 payment_time : 200724 payment_date : 20141105 response_code : 00 payment_certificate : 9044235f3415 authorisation_id : 01777B currency_code : 978 card_number : 4625.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 : p.lemoing19 order_id : 2372 customer_email : p.lemoing19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201607 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2373" select * from cms_frontusers where identifiant = "p.cossard17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2373" select * from cotisations where identifiant = "a.pingault09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201728 payment_means : MASTERCARD transmission_date : 20141105191728 payment_time : 201903 payment_date : 20141105 response_code : 00 payment_certificate : 37f8a6ab1535 authorisation_id : 121350 currency_code : 978 card_number : 5131.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 : p.cossard17 order_id : 2373 customer_email : p.cossard17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2374" select * from cms_frontusers where identifiant = "q.lagarde11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2374" select * from cotisations where identifiant = "q.lagarde11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203121 payment_means : MASTERCARD transmission_date : 20141105193121 payment_time : 203432 payment_date : 20141105 response_code : 00 payment_certificate : c61896d6e17f authorisation_id : 108686 currency_code : 978 card_number : 5137.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 : q.lagarde11 order_id : 2374 customer_email : q.lagarde11@compagnons-du-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 = "2375" select * from cms_frontusers where identifiant = "jc.tisne05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2375" select * from cotisations where identifiant = "jc.tisne05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204900 payment_means : VISA transmission_date : 20141105194900 payment_time : 205025 payment_date : 20141105 response_code : 00 payment_certificate : d905694faa3e authorisation_id : 326235 currency_code : 978 card_number : 4201.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 : jc.tisne05 order_id : 2375 customer_email : jc.tisne05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2377" select * from cms_frontusers where identifiant = "s.noyer30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2377" select * from cotisations where identifiant = "s.noyer30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205638 payment_means : VISA transmission_date : 20141105195638 payment_time : 205823 payment_date : 20141105 response_code : 00 payment_certificate : b9521b976e73 authorisation_id : 315262 currency_code : 978 card_number : 4533.96 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.noyer30 order_id : 2377 customer_email : s.noyer30@compagnons-du-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 = "2378" select * from cms_frontusers where identifiant = "e.retif06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2378" select * from cotisations where identifiant = "e.retif06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210018 payment_means : VISA transmission_date : 20141105200018 payment_time : 210246 payment_date : 20141105 response_code : 00 payment_certificate : 37fa4a5b01db authorisation_id : 673840 currency_code : 978 card_number : 4978.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.retif06 order_id : 2378 customer_email : e.retif06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201503 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205404 payment_means : VISA transmission_date : 20141105195404 payment_time : 210333 payment_date : 20141105 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.vallar28 order_id : 2376 customer_email : d.vallar28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2381" select * from cms_frontusers where identifiant = "m.toupet08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2381" select * from cotisations where identifiant = "m.toupet08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213920 payment_means : VISA transmission_date : 20141105203920 payment_time : 214048 payment_date : 20141105 response_code : 00 payment_certificate : b154cb0f9448 authorisation_id : 986553 currency_code : 978 card_number : 4970.10 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.toupet08 order_id : 2381 customer_email : m.toupet08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2383" select * from cms_frontusers where identifiant = "j.baudoin07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2383" select * from cotisations where identifiant = "j.baudoin07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220406 payment_means : MASTERCARD transmission_date : 20141105210406 payment_time : 220823 payment_date : 20141105 response_code : 00 payment_certificate : 995bdb0eadb9 authorisation_id : 636222 currency_code : 978 card_number : 5136.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.baudoin07 order_id : 2383 customer_email : j.baudoin07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "2385" select * from cms_frontusers where identifiant = "p.jacob04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "2385" select * from cotisations where identifiant = "p.jacob04" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221715 payment_means : MASTERCARD transmission_date : 20141105211715 payment_time : 221920 payment_date : 20141105 response_code : 00 payment_certificate : e054e13d49eb authorisation_id : 227512 currency_code : 978 card_number : 5137.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 : p.jacob04 order_id : 2385 customer_email : p.jacob04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201509 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------