Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 003505 payment_means : VISA transmission_date : 20151117233505 payment_time : 003716 payment_date : 20151118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.24 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.plessis31 order_id : 9047 customer_email : p.plessis31@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9048" select * from cms_frontusers where identifiant = "a.morgenstern10" 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 = "9048" select * from cotisations where identifiant = "a.morgenstern10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 014550 payment_means : VISA transmission_date : 20151118004550 payment_time : 014714 payment_date : 20151118 response_code : 00 payment_certificate : 813ea6e4dacb authorisation_id : 947447 currency_code : 978 card_number : 4970.25 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.morgenstern10 order_id : 9048 customer_email : a.morgenstern10@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 = "9049" select * from cms_frontusers where identifiant = "g.tillard06" 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 = "9049" select * from cotisations where identifiant = "g.tillard06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082520 payment_means : MASTERCARD transmission_date : 20151118072520 payment_time : 082610 payment_date : 20151118 response_code : 00 payment_certificate : 6261ff979dea authorisation_id : 469546 currency_code : 978 card_number : 5136.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 : g.tillard06 order_id : 9049 customer_email : g.tillard06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9050" select * from cms_frontusers where identifiant = "g.tillard06" 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 = "9050" select * from cotisations where identifiant = "j.hontaas02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082753 payment_means : MASTERCARD transmission_date : 20151118072753 payment_time : 082900 payment_date : 20151118 response_code : 00 payment_certificate : fd3ebb654b36 authorisation_id : 356613 currency_code : 978 card_number : 5136.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 : g.tillard06 order_id : 9050 customer_email : g.tillard06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9051" select * from cms_frontusers where identifiant = "c.mendez28" 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 = "9051" select * from cotisations where identifiant = "c.mendez28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 101504 payment_means : MASTERCARD transmission_date : 20151118091504 payment_time : 101611 payment_date : 20151118 response_code : 00 payment_certificate : 8e451bb5e93b authorisation_id : 445463 currency_code : 978 card_number : 5341.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 : c.mendez28 order_id : 9051 customer_email : c.mendez28@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 = "9052" select * from cms_frontusers where identifiant = "c.mendez28" 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 = "9052" select * from cotisations where identifiant = "c.mendez28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 101658 payment_means : MASTERCARD transmission_date : 20151118091658 payment_time : 101756 payment_date : 20151118 response_code : 00 payment_certificate : c244a3a9eba4 authorisation_id : 317200 currency_code : 978 card_number : 5341.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 : c.mendez28 order_id : 9052 customer_email : c.mendez28@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 = "9053" select * from cms_frontusers where identifiant = "b.juglas11" 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 = "9053" select * from cotisations where identifiant = "b.juglas11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103130 payment_means : VISA transmission_date : 20151118093130 payment_time : 103304 payment_date : 20151118 response_code : 00 payment_certificate : 564c62f45d40 authorisation_id : 302232 currency_code : 978 card_number : 4974.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 : b.juglas11 order_id : 9053 customer_email : b.juglas11@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 : 201808 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9054" select * from cms_frontusers where identifiant = "j.bontemps27" 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 = "9054" select * from cotisations where identifiant = "j.bontemps27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110218 payment_means : VISA transmission_date : 20151118100218 payment_time : 111017 payment_date : 20151118 response_code : 00 payment_certificate : 846cf72205f5 authorisation_id : 615122 currency_code : 978 card_number : 4970.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.bontemps27 order_id : 9054 customer_email : j.bontemps27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9055" select * from cms_frontusers where identifiant = "l.anglesio11" 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 = "9055" select * from cotisations where identifiant = "l.anglesio11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135051 payment_means : MASTERCARD transmission_date : 20151118125051 payment_time : 135223 payment_date : 20151118 response_code : 00 payment_certificate : 043fc59ca937 authorisation_id : 617338 currency_code : 978 card_number : 5137.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 : l.anglesio11 order_id : 9055 customer_email : l.anglesio11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9056" select * from cms_frontusers where identifiant = "jp.donati24" 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 = "9056" select * from cotisations where identifiant = "jp.donati24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152320 payment_means : VISA transmission_date : 20151118142320 payment_time : 152933 payment_date : 20151118 response_code : 00 payment_certificate : acc98ed08c1d authorisation_id : 346283 currency_code : 978 card_number : 4150.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 : jp.donati24 order_id : 9056 customer_email : jp.donati24@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 : 155926 payment_means : VISA transmission_date : 20151118145926 payment_time : 160458 payment_date : 20151118 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.85 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 : jp.brehier14 order_id : 9057 customer_email : jp.brehier14@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 : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9059" select * from cms_frontusers where identifiant = "g.marchetti12" 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 = "9059" select * from cotisations where identifiant = "g.marchetti12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 162605 payment_means : VISA transmission_date : 20151118152605 payment_time : 162715 payment_date : 20151118 response_code : 00 payment_certificate : afcc694cf165 authorisation_id : 642245 currency_code : 978 card_number : 4978.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 : g.marchetti12 order_id : 9059 customer_email : g.marchetti12@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9058" select * from cms_frontusers where identifiant = "a.lafonta10" 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 = "9058" select * from cotisations where identifiant = "a.lafonta10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 162552 payment_means : MASTERCARD transmission_date : 20151118152552 payment_time : 163202 payment_date : 20151118 response_code : 00 payment_certificate : f961b2be8f19 authorisation_id : 969736 currency_code : 978 card_number : 5133.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 : a.lafonta10 order_id : 9058 customer_email : a.lafonta10@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 = "9060" select * from cms_frontusers where identifiant = "jc.terrier30" 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 = "9060" select * from cotisations where identifiant = "jc.terrier30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171838 payment_means : VISA transmission_date : 20151118161838 payment_time : 173014 payment_date : 20151118 response_code : 00 payment_certificate : 004591dffed9 authorisation_id : 632994 currency_code : 978 card_number : 4975.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.terrier30 order_id : 9060 customer_email : jc.terrier30@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 = "9061" select * from cms_frontusers where identifiant = "p.rivault04" 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 = "9061" select * from cotisations where identifiant = "p.rivault04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174354 payment_means : VISA transmission_date : 20151118164354 payment_time : 174556 payment_date : 20151118 response_code : 00 payment_certificate : d22ac974463a authorisation_id : 391351 currency_code : 978 card_number : 4972.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 : p.rivault04 order_id : 9061 customer_email : p.rivault04@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 = "9062" select * from cms_frontusers where identifiant = "j.manceau17" 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 = "9062" select * from cotisations where identifiant = "j.manceau17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182251 payment_means : MASTERCARD transmission_date : 20151118172251 payment_time : 182514 payment_date : 20151118 response_code : 00 payment_certificate : 64fe406bc3e1 authorisation_id : 135379 currency_code : 978 card_number : 5132.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 : j.manceau17 order_id : 9062 customer_email : j.manceau17@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 = "9066" select * from cms_frontusers where identifiant = "n.brichet22" 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 = "9066" select * from cotisations where identifiant = "n.brichet22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184422 payment_means : MASTERCARD transmission_date : 20151118174422 payment_time : 184538 payment_date : 20151118 response_code : 00 payment_certificate : 7b7b10335335 authorisation_id : 145363 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 : n.brichet22 order_id : 9066 customer_email : n.brichet22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185345 payment_means : VISA transmission_date : 20151118175345 payment_time : 185517 payment_date : 20151118 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.37 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 : b.vuylsteke13 order_id : 9067 customer_email : b.vuylsteke13@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 : 185537 payment_means : VISA transmission_date : 20151118175537 payment_time : 185750 payment_date : 20151118 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.37 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 : b.vuylsteke13 order_id : 9067 customer_email : b.vuylsteke13@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 : 185850 payment_means : VISA transmission_date : 20151118175850 payment_time : 190016 payment_date : 20151118 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.37 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 : b.vuylsteke13 order_id : 9067 customer_email : b.vuylsteke13@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 = "9068" select * from cms_frontusers where identifiant = "g.legallo24" 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 = "9068" select * from cotisations where identifiant = "g.legallo24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191211 payment_means : MASTERCARD transmission_date : 20151118181211 payment_time : 191329 payment_date : 20151118 response_code : 00 payment_certificate : 6e1234a3ed5b authorisation_id : 477450 currency_code : 978 card_number : 5135.12 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.legallo24 order_id : 9068 customer_email : g.legallo24@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 = "9069" select * from cms_frontusers where identifiant = "a.roux03" 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 = "9069" select * from cotisations where identifiant = "a.roux03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192411 payment_means : VISA transmission_date : 20151118182411 payment_time : 192739 payment_date : 20151118 response_code : 00 payment_certificate : 4d763f31f3c3 authorisation_id : 212455 currency_code : 978 card_number : 4972.37 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.roux03 order_id : 9069 customer_email : a.roux03@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 = "9070" select * from cms_frontusers where identifiant = "r.colotte05" 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 = "9070" select * from cotisations where identifiant = "r.colotte05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194848 payment_means : MASTERCARD transmission_date : 20151118184848 payment_time : 195114 payment_date : 20151118 response_code : 00 payment_certificate : d3c17bc25889 authorisation_id : 534065 currency_code : 978 card_number : 5136.29 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.colotte05 order_id : 9070 customer_email : r.colotte05@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9071" select * from cms_frontusers where identifiant = "j.flamand28" 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 = "9071" select * from cotisations where identifiant = "j.flamand28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200937 payment_means : MASTERCARD transmission_date : 20151118190937 payment_time : 201354 payment_date : 20151118 response_code : 00 payment_certificate : 853f7f96f35d authorisation_id : 805341 currency_code : 978 card_number : 5132.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 : j.flamand28 order_id : 9071 customer_email : j.flamand28@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 = "9073" select * from cms_frontusers where identifiant = "n.marcilly10" 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 = "9073" select * from cotisations where identifiant = "n.marcilly10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201217 payment_means : MASTERCARD transmission_date : 20151118191217 payment_time : 201416 payment_date : 20151118 response_code : 00 payment_certificate : 81e58ad85920 authorisation_id : 186472 currency_code : 978 card_number : 5131.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.marcilly10 order_id : 9073 customer_email : n.marcilly10@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 = "9077" select * from cms_frontusers where identifiant = "p.bonnin24" 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 = "9077" select * from cotisations where identifiant = "p.bonnin24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204820 payment_means : MASTERCARD transmission_date : 20151118194820 payment_time : 205048 payment_date : 20151118 response_code : 00 payment_certificate : 3acf7ba6dd6f authorisation_id : 654135 currency_code : 978 card_number : 5137.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bonnin24 order_id : 9077 customer_email : p.bonnin24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9079" select * from cms_frontusers where identifiant = "a.valette18" 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 = "9079" select * from cotisations where identifiant = "a.valette18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205647 payment_means : VISA transmission_date : 20151118195647 payment_time : 205750 payment_date : 20151118 response_code : 00 payment_certificate : c62f632960a4 authorisation_id : 136616 currency_code : 978 card_number : 4978.12 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.valette18 order_id : 9079 customer_email : a.valette18@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 = "9080" select * from cms_frontusers where identifiant = "j.fonseca20" 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 = "9080" select * from cotisations where identifiant = "j.tillie14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205932 payment_means : VISA transmission_date : 20151118195932 payment_time : 210129 payment_date : 20151118 response_code : 00 payment_certificate : 08c1e1b2fe7f authorisation_id : 582418 currency_code : 978 card_number : 4975.53 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.fonseca20 order_id : 9080 customer_email : j.fonseca20@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 : ------------------------------------------- select * from cotisations_commande where id = "9082" select * from cms_frontusers where identifiant = "f.valet09" 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 = "9082" select * from cotisations where identifiant = "f.valet09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210927 payment_means : VISA transmission_date : 20151118200927 payment_time : 211038 payment_date : 20151118 response_code : 00 payment_certificate : 1f4d83e20b6a authorisation_id : 453741 currency_code : 978 card_number : 4970.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.valet09 order_id : 9082 customer_email : f.valet09@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9081" select * from cms_frontusers where identifiant = "e.dehlinger16" 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 = "9081" select * from cotisations where identifiant = "e.dehlinger16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210858 payment_means : VISA transmission_date : 20151118200858 payment_time : 211039 payment_date : 20151118 response_code : 00 payment_certificate : 728c6f72b772 authorisation_id : 210551 currency_code : 978 card_number : 4972.26 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.dehlinger16 order_id : 9081 customer_email : e.dehlinger16@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 = "9083" select * from cms_frontusers where identifiant = "f.demond22" 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 = "9083" select * from cotisations where identifiant = "f.demond22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211057 payment_means : VISA transmission_date : 20151118201057 payment_time : 211456 payment_date : 20151118 response_code : 00 payment_certificate : 257ee1cd2956 authorisation_id : 512761 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 : f.demond22 order_id : 9083 customer_email : f.demond22@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 = "9084" select * from cms_frontusers where identifiant = "s.klein17" 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 = "9084" select * from cotisations where identifiant = "s.klein17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212547 payment_means : VISA transmission_date : 20151118202547 payment_time : 212728 payment_date : 20151118 response_code : 00 payment_certificate : 0a057f8f72e8 authorisation_id : 045366 currency_code : 978 card_number : 4970.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 : s.klein17 order_id : 9084 customer_email : s.klein17@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 : 8000 transaction_id : 215913 payment_means : MASTERCARD transmission_date : 20151118205913 payment_time : 220050 payment_date : 20151118 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 61 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.savignac04 order_id : 9086 customer_email : p.savignac04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9087" select * from cms_frontusers where identifiant = "s.roussel01" 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 = "9087" select * from cotisations where identifiant = "t.dervin23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220006 payment_means : VISA transmission_date : 20151118210006 payment_time : 220143 payment_date : 20151118 response_code : 00 payment_certificate : 029a024ab482 authorisation_id : 454548 currency_code : 978 card_number : 4976.34 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.roussel01 order_id : 9087 customer_email : s.roussel01@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 = "9088" select * from cms_frontusers where identifiant = "t.bourgeois21" 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 = "9088" select * from cotisations where identifiant = "t.bourgeois21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221748 payment_means : MASTERCARD transmission_date : 20151118211748 payment_time : 222109 payment_date : 20151118 response_code : 00 payment_certificate : 95ae0ba31e72 authorisation_id : 534591 currency_code : 978 card_number : 5131.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 : t.bourgeois21 order_id : 9088 customer_email : t.bourgeois21@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------