select * from cotisations_commande where id = "6010" select * from cms_frontusers where identifiant = "a.borrel23" 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 = "6010" select * from cotisations where identifiant = "a.borrel23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084333 payment_means : MASTERCARD transmission_date : 20150201074333 payment_time : 084611 payment_date : 20150201 response_code : 00 payment_certificate : 483f0c0a51b6 authorisation_id : 774544 currency_code : 978 card_number : 5137.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.borrel23 order_id : 6010 customer_email : a.borrel23@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 = "6011" select * from cms_frontusers where identifiant = "r.grazia05" 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 = "6011" select * from cotisations where identifiant = "r.grazia05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094131 payment_means : MASTERCARD transmission_date : 20150201084131 payment_time : 094357 payment_date : 20150201 response_code : 00 payment_certificate : 1e20d19e5d30 authorisation_id : 729161 currency_code : 978 card_number : 5132.54 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.grazia05 order_id : 6011 customer_email : r.grazia05@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 : ------------------------------------------- select * from cotisations_commande where id = "6012" select * from cms_frontusers where identifiant = "l.beyries16" 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 = "6012" select * from cotisations where identifiant = "l.beyries16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113322 payment_means : MASTERCARD transmission_date : 20150201103322 payment_time : 113446 payment_date : 20150201 response_code : 00 payment_certificate : eaf5094f9abe authorisation_id : 114931 currency_code : 978 card_number : 5137.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 : l.beyries16 order_id : 6012 customer_email : l.beyries16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114543 payment_means : MASTERCARD transmission_date : 20150201104543 payment_time : 114746 payment_date : 20150201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.91 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.roirand30 order_id : 6013 customer_email : c.roirand30@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114757 payment_means : MASTERCARD transmission_date : 20150201104757 payment_time : 115003 payment_date : 20150201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.91 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.roirand30 order_id : 6013 customer_email : c.roirand30@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 = "6014" select * from cms_frontusers where identifiant = "c.nowecki02" 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 = "6014" select * from cotisations where identifiant = "c.nowecki02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120444 payment_means : VISA transmission_date : 20150201110444 payment_time : 121117 payment_date : 20150201 response_code : 00 payment_certificate : fc85942508e8 authorisation_id : 165024 currency_code : 978 card_number : 4150.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.nowecki02 order_id : 6014 customer_email : c.nowecki02@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 : 135346 payment_means : VISA transmission_date : 20150201125346 payment_time : 135500 payment_date : 20150201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4430.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.jacob06 order_id : 6016 customer_email : e.jacob06@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 : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6016" select * from cms_frontusers where identifiant = "e.jacob06" 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 = "6016" select * from cotisations where identifiant = "e.jacob06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135511 payment_means : VISA transmission_date : 20150201125511 payment_time : 140029 payment_date : 20150201 response_code : 00 payment_certificate : 49fe5fb0713e authorisation_id : 154225 currency_code : 978 card_number : 4978.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.jacob06 order_id : 6016 customer_email : e.jacob06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6017" select * from cms_frontusers where identifiant = "j.berthod14" 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 = "6017" select * from cotisations where identifiant = "a.marulier26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183726 payment_means : VISA transmission_date : 20150201173726 payment_time : 183907 payment_date : 20150201 response_code : 00 payment_certificate : b41cebc1fbbb authorisation_id : 963374 currency_code : 978 card_number : 4970.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.berthod14 order_id : 6017 customer_email : j.berthod14@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 : ------------------------------------------- select * from cotisations_commande where id = "6021" select * from cms_frontusers where identifiant = "p.gouaze28" 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 = "6021" select * from cotisations where identifiant = "p.gouaze28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191802 payment_means : VISA transmission_date : 20150201181802 payment_time : 192312 payment_date : 20150201 response_code : 00 payment_certificate : f98c74a21d7e authorisation_id : 438147 currency_code : 978 card_number : 4978.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.gouaze28 order_id : 6021 customer_email : p.gouaze28@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 = "6022" select * from cms_frontusers where identifiant = "t.musset14" 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 = "6022" select * from cotisations where identifiant = "p.valentin31" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194829 payment_means : VISA transmission_date : 20150201184829 payment_time : 195100 payment_date : 20150201 response_code : 00 payment_certificate : d91f7029ff2a authorisation_id : 773047 currency_code : 978 card_number : 4970.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 : t.musset14 order_id : 6022 customer_email : t.musset14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195416 payment_means : VISA transmission_date : 20150201185416 payment_time : 195602 payment_date : 20150201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 56 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.musset14 order_id : 6023 customer_email : t.musset14@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 = "6023" select * from cms_frontusers where identifiant = "t.musset14" 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 = "6023" select * from cotisations where identifiant = "f.valentin27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195620 payment_means : VISA transmission_date : 20150201185620 payment_time : 195738 payment_date : 20150201 response_code : 00 payment_certificate : fc3b4438d6bc authorisation_id : 371743 currency_code : 978 card_number : 4970.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 : t.musset14 order_id : 6023 customer_email : t.musset14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6024" select * from cms_frontusers where identifiant = "c.roirand30" 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 = "6024" select * from cotisations where identifiant = "l.raguy08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205707 payment_means : MASTERCARD transmission_date : 20150201195707 payment_time : 210420 payment_date : 20150201 response_code : 00 payment_certificate : 70d223d312ad authorisation_id : 558769 currency_code : 978 card_number : 5131.81 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.roirand30 order_id : 6024 customer_email : c.roirand30@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 = "6025" select * from cms_frontusers where identifiant = "m.bigourd02" 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 = "6025" select * from cotisations where identifiant = "m.bigourd02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210933 payment_means : MASTERCARD transmission_date : 20150201200933 payment_time : 211205 payment_date : 20150201 response_code : 00 payment_certificate : 323f2519ff95 authorisation_id : 238551 currency_code : 978 card_number : 5132.90 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.bigourd02 order_id : 6025 customer_email : m.bigourd02@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 = "6026" select * from cms_frontusers where identifiant = "x.rocher23" 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 = "6026" select * from cotisations where identifiant = "x.rocher23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212139 payment_means : VISA transmission_date : 20150201202139 payment_time : 212836 payment_date : 20150201 response_code : 00 payment_certificate : bf6a200a86b1 authorisation_id : 643579 currency_code : 978 card_number : 4976.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 : x.rocher23 order_id : 6026 customer_email : x.rocher23@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 : ------------------------------------------- select * from cotisations_commande where id = "6028" select * from cms_frontusers where identifiant = "j.berthod14" 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 = "6028" select * from cotisations where identifiant = "n.delhomme04" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214443 payment_means : VISA transmission_date : 20150201204443 payment_time : 214623 payment_date : 20150201 response_code : 00 payment_certificate : 57442da0cce5 authorisation_id : 735521 currency_code : 978 card_number : 4970.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.berthod14 order_id : 6028 customer_email : j.berthod14@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 : ------------------------------------------- select * from cotisations_commande where id = "6030" select * from cms_frontusers where identifiant = "j.berthod14" 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 = "6030" select * from cotisations where identifiant = "t.chenaud22" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215523 payment_means : VISA transmission_date : 20150201205523 payment_time : 215802 payment_date : 20150201 response_code : 00 payment_certificate : 26fcfefdb10c authorisation_id : 631175 currency_code : 978 card_number : 4970.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.berthod14 order_id : 6030 customer_email : j.berthod14@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 : ------------------------------------------- select * from cotisations_commande where id = "6031" select * from cms_frontusers where identifiant = "j.berthod14" 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 = "6031" select * from cotisations where identifiant = "c.verdier28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221431 payment_means : VISA transmission_date : 20150201211431 payment_time : 221648 payment_date : 20150201 response_code : 00 payment_certificate : ce03a219ec58 authorisation_id : 131832 currency_code : 978 card_number : 4970.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.berthod14 order_id : 6031 customer_email : j.berthod14@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 : -------------------------------------------