select * from cotisations_commande where id = "1682" select * from cms_frontusers where identifiant = "g.hlyn02" 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 = "1682" select * from cotisations where identifiant = "g.hlyn02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085024 payment_means : VISA transmission_date : 20141012065024 payment_time : 085230 payment_date : 20141012 response_code : 00 payment_certificate : 10eefe1df819 authorisation_id : 351235 currency_code : 978 card_number : 4979.89 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.hlyn02 order_id : 1682 customer_email : g.hlyn02@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 : 094939 payment_means : MASTERCARD transmission_date : 20141012074939 payment_time : 095649 payment_date : 20141012 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.86 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.claviere22 order_id : 1683 customer_email : p.claviere22@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 : ------------------------------------------- select * from cotisations_commande where id = "1684" select * from cms_frontusers where identifiant = "jm.marrie18" 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 = "1684" select * from cotisations where identifiant = "jm.marrie18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104347 payment_means : VISA transmission_date : 20141012084347 payment_time : 104732 payment_date : 20141012 response_code : 00 payment_certificate : c38146b299e4 authorisation_id : 206638 currency_code : 978 card_number : 4201.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 : jm.marrie18 order_id : 1684 customer_email : jm.marrie18@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 : ------------------------------------------- select * from cotisations_commande where id = "1685" select * from cms_frontusers where identifiant = "y.bouges05" 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 = "1685" select * from cotisations where identifiant = "y.bouges05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104735 payment_means : MASTERCARD transmission_date : 20141012084735 payment_time : 104920 payment_date : 20141012 response_code : 00 payment_certificate : 2523335e2e63 authorisation_id : 268684 currency_code : 978 card_number : 5132.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 : y.bouges05 order_id : 1685 customer_email : y.bouges05@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 : 122442 payment_means : MASTERCARD transmission_date : 20141012102442 payment_time : 123030 payment_date : 20141012 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.23 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.felgines20 order_id : 1686 customer_email : f.felgines20@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 = "1687" select * from cms_frontusers where identifiant = "m.bourgeois08" 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 = "1687" select * from cotisations where identifiant = "m.bourgeois08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 145139 payment_means : VISA transmission_date : 20141012125139 payment_time : 145405 payment_date : 20141012 response_code : 00 payment_certificate : cf4ed7506f37 authorisation_id : 361418 currency_code : 978 card_number : 4978.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 : m.bourgeois08 order_id : 1687 customer_email : m.bourgeois08@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 = "1690" select * from cms_frontusers where identifiant = "p.cottet15" 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 = "1690" select * from cotisations where identifiant = "p.cottet15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 160021 payment_means : VISA transmission_date : 20141012140021 payment_time : 162300 payment_date : 20141012 response_code : 00 payment_certificate : e75b0a1d8b2f authorisation_id : 003361 currency_code : 978 card_number : 4970.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.cottet15 order_id : 1690 customer_email : p.cottet15@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 = "1691" select * from cms_frontusers where identifiant = "a.beaulande18" 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 = "1691" select * from cotisations where identifiant = "a.beaulande18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172444 payment_means : VISA transmission_date : 20141012152444 payment_time : 172639 payment_date : 20141012 response_code : 00 payment_certificate : 2aa97494cf73 authorisation_id : 915215 currency_code : 978 card_number : 4978.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.beaulande18 order_id : 1691 customer_email : a.beaulande18@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 : 201410 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1694" select * from cms_frontusers where identifiant = "m.guenantin29" 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 = "1694" select * from cotisations where identifiant = "m.guenantin29" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "m.guenantin29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175001 payment_means : MASTERCARD transmission_date : 20141012155001 payment_time : 175515 payment_date : 20141012 response_code : 00 payment_certificate : a6c0e16be0bf authorisation_id : 048662 currency_code : 978 card_number : 5138.39 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.guenantin29 order_id : 1694 customer_email : m.guenantin29@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 174848 payment_means : MASTERCARD transmission_date : 20141012154848 payment_time : 175548 payment_date : 20141012 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.meunier11 order_id : 1693 customer_email : m.meunier11@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1696" select * from cms_frontusers where identifiant = "k.rodrigues01" 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 = "1696" select * from cotisations where identifiant = "k.rodrigues01" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182448 payment_means : VISA transmission_date : 20141012162448 payment_time : 182734 payment_date : 20141012 response_code : 00 payment_certificate : 3254a2045117 authorisation_id : 131494 currency_code : 978 card_number : 4973.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.rodrigues01 order_id : 1696 customer_email : k.rodrigues01@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 = "1697" select * from cms_frontusers where identifiant = "g.pocquat10" 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 = "1697" select * from cotisations where identifiant = "g.pocquat10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182507 payment_means : MASTERCARD transmission_date : 20141012162507 payment_time : 182739 payment_date : 20141012 response_code : 00 payment_certificate : 3142ba9b7bdb authorisation_id : 112353 currency_code : 978 card_number : 5131.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 : g.pocquat10 order_id : 1697 customer_email : g.pocquat10@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 : 201506 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1698" select * from cms_frontusers where identifiant = "j.droucheau09" 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 = "1698" select * from cotisations where identifiant = "j.droucheau09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193253 payment_means : MASTERCARD transmission_date : 20141012173253 payment_time : 193500 payment_date : 20141012 response_code : 00 payment_certificate : 6fc194b9af44 authorisation_id : 335813 currency_code : 978 card_number : 5137.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.droucheau09 order_id : 1698 customer_email : j.droucheau09@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 : -------------------------------------------