Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075707 payment_means : VISA transmission_date : 20151229065707 payment_time : 080339 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.50 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 : j.arnaud05 order_id : 11648 customer_email : j.arnaud05@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 = "11648" select * from cms_frontusers where identifiant = "j.arnaud05" 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 = "11648" select * from cotisations where identifiant = "j.arnaud05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080443 payment_means : VISA transmission_date : 20151229070443 payment_time : 080711 payment_date : 20151229 response_code : 00 payment_certificate : b92ca0edf4cd authorisation_id : 551615 currency_code : 978 card_number : 4976.50 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.arnaud05 order_id : 11648 customer_email : j.arnaud05@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 = "11649" select * from cms_frontusers where identifiant = "b.rouillon03" 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 = "11649" select * from cotisations where identifiant = "b.rouillon03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083510 payment_means : MASTERCARD transmission_date : 20151229073510 payment_time : 084003 payment_date : 20151229 response_code : 00 payment_certificate : 7d45e62a6ba2 authorisation_id : 403794 currency_code : 978 card_number : 5131.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 : b.rouillon03 order_id : 11649 customer_email : b.rouillon03@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 : 085505 payment_means : MASTERCARD transmission_date : 20151229075505 payment_time : 075751 payment_date : 20151229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.bellanca13 order_id : 11650 customer_email : l.bellanca13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11652" select * from cms_frontusers where identifiant = "l.bellanca13" 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 = "11652" select * from cotisations where identifiant = "p.tailler18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090003 payment_means : MASTERCARD transmission_date : 20151229080003 payment_time : 090506 payment_date : 20151229 response_code : 00 payment_certificate : 0ca4c520b987 authorisation_id : 339645 currency_code : 978 card_number : 5137.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 : l.bellanca13 order_id : 11652 customer_email : l.bellanca13@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 = "11653" select * from cms_frontusers where identifiant = "g.thibaudgendron11" 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 = "11653" select * from cotisations where identifiant = "g.thibaudgendron11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093102 payment_means : MASTERCARD transmission_date : 20151229083102 payment_time : 093517 payment_date : 20151229 response_code : 00 payment_certificate : 199b8c55b2ea authorisation_id : 715159 currency_code : 978 card_number : 5136.86 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.thibaudgendron11 order_id : 11653 customer_email : g.thibaudgendron11@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 = "11654" select * from cms_frontusers where identifiant = "g.thibaudgendron11" 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 = "11654" select * from cotisations where identifiant = "s.honore21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093957 payment_means : MASTERCARD transmission_date : 20151229083957 payment_time : 094252 payment_date : 20151229 response_code : 00 payment_certificate : 8a5b18941e23 authorisation_id : 360548 currency_code : 978 card_number : 5136.86 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.thibaudgendron11 order_id : 11654 customer_email : g.thibaudgendron11@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 = "11656" select * from cms_frontusers where identifiant = "g.thibaudgendron11" 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 = "11656" select * from cotisations where identifiant = "n.dauria09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094503 payment_means : MASTERCARD transmission_date : 20151229084503 payment_time : 094704 payment_date : 20151229 response_code : 00 payment_certificate : 10b1b5dc43af authorisation_id : 469682 currency_code : 978 card_number : 5136.86 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.thibaudgendron11 order_id : 11656 customer_email : g.thibaudgendron11@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 = "11655" select * from cms_frontusers where identifiant = "j.jusselme23" 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 = "11655" select * from cotisations where identifiant = "j.jusselme23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094140 payment_means : VISA transmission_date : 20151229084140 payment_time : 094827 payment_date : 20151229 response_code : 00 payment_certificate : 0cee46febe9c authorisation_id : 656212 currency_code : 978 card_number : 4970.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 : j.jusselme23 order_id : 11655 customer_email : j.jusselme23@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 = "11658" select * from cms_frontusers where identifiant = "t.foucher15" 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 = "11658" select * from cotisations where identifiant = "g.halary02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095244 payment_means : VISA transmission_date : 20151229085244 payment_time : 095421 payment_date : 20151229 response_code : 00 payment_certificate : beb62995a75e authorisation_id : 255606 currency_code : 978 card_number : 4977.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 : t.foucher15 order_id : 11658 customer_email : t.foucher15@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 = "11659" select * from cms_frontusers where identifiant = "t.foucher15" 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 = "11659" select * from cotisations where identifiant = "a.jimenez29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095508 payment_means : VISA transmission_date : 20151229085508 payment_time : 095626 payment_date : 20151229 response_code : 00 payment_certificate : 14ac10c1e862 authorisation_id : 343454 currency_code : 978 card_number : 4977.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 : t.foucher15 order_id : 11659 customer_email : t.foucher15@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 = "11657" select * from cms_frontusers where identifiant = "g.jacob22" 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 = "11657" select * from cotisations where identifiant = "g.jacob22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094752 payment_means : MASTERCARD transmission_date : 20151229084752 payment_time : 100046 payment_date : 20151229 response_code : 00 payment_certificate : 9ff9925043e9 authorisation_id : 465496 currency_code : 978 card_number : 5132.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.jacob22 order_id : 11657 customer_email : g.jacob22@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 = "11660" select * from cms_frontusers where identifiant = "s.laurent28" 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 = "11660" select * from cotisations where identifiant = "s.laurent28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100611 payment_means : VISA transmission_date : 20151229090611 payment_time : 100900 payment_date : 20151229 response_code : 00 payment_certificate : 058087475b6d authorisation_id : 620624 currency_code : 978 card_number : 4970.58 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.laurent28 order_id : 11660 customer_email : s.laurent28@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 = "11661" select * from cms_frontusers where identifiant = "a.roskam24" 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 = "11661" select * from cotisations where identifiant = "a.roskam24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 103748 payment_means : MASTERCARD transmission_date : 20151229093748 payment_time : 104457 payment_date : 20151229 response_code : 00 payment_certificate : b919236d9e51 authorisation_id : 142891 currency_code : 978 card_number : 6703.50 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.roskam24 order_id : 11661 customer_email : a.roskam24@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11662" select * from cms_frontusers where identifiant = "l.grollier22" 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 = "11662" select * from cotisations where identifiant = "l.grollier22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113040 payment_means : MASTERCARD transmission_date : 20151229103040 payment_time : 113231 payment_date : 20151229 response_code : 00 payment_certificate : cdb37cd2a137 authorisation_id : 633462 currency_code : 978 card_number : 5137.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 : l.grollier22 order_id : 11662 customer_email : l.grollier22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11663" select * from cms_frontusers where identifiant = "n.mauries27" 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 = "11663" select * from cotisations where identifiant = "n.mauries27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114601 payment_means : VISA transmission_date : 20151229104601 payment_time : 114926 payment_date : 20151229 response_code : 00 payment_certificate : c6e5f7823b6b authorisation_id : 094131 currency_code : 978 card_number : 4978.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.mauries27 order_id : 11663 customer_email : n.mauries27@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 : 114831 payment_means : VISA transmission_date : 20151229104831 payment_time : 115038 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.89 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 : d.reljac19 order_id : 11664 customer_email : d.reljac19@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 : 115053 payment_means : VISA transmission_date : 20151229105053 payment_time : 115204 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.89 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 : d.reljac19 order_id : 11664 customer_email : d.reljac19@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 : 115342 payment_means : VISA transmission_date : 20151229105342 payment_time : 115500 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.89 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 : d.reljac19 order_id : 11664 customer_email : d.reljac19@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 = "11664" select * from cms_frontusers where identifiant = "d.reljac19" 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 = "11664" select * from cotisations where identifiant = "d.reljac19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115518 payment_means : VISA transmission_date : 20151229105518 payment_time : 115718 payment_date : 20151229 response_code : 00 payment_certificate : 740dab0c80c7 authorisation_id : 195121 currency_code : 978 card_number : 4975.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 : d.reljac19 order_id : 11664 customer_email : d.reljac19@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 = "11665" select * from cms_frontusers where identifiant = "p.lefebvre06" 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 = "11665" select * from cotisations where identifiant = "p.guilhou01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121702 payment_means : VISA transmission_date : 20151229111702 payment_time : 121822 payment_date : 20151229 response_code : 00 payment_certificate : f26567f2e90b authorisation_id : 652928 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lefebvre06 order_id : 11665 customer_email : p.lefebvre06@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 = "11666" select * from cms_frontusers where identifiant = "p.lefebvre06" 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 = "11666" select * from cotisations where identifiant = "e.krieger17" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "e.krieger17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 121915 payment_means : VISA transmission_date : 20151229111915 payment_time : 122022 payment_date : 20151229 response_code : 00 payment_certificate : 358ae9f9e524 authorisation_id : 485206 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lefebvre06 order_id : 11666 customer_email : p.lefebvre06@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123009 payment_means : VISA transmission_date : 20151229113009 payment_time : 113629 payment_date : 20151229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.roy10 order_id : 11667 customer_email : jm.roy10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11668" select * from cms_frontusers where identifiant = "o.sieber13" 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 = "11668" select * from cotisations where identifiant = "o.sieber13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 125512 payment_means : MASTERCARD transmission_date : 20151229115512 payment_time : 125906 payment_date : 20151229 response_code : 00 payment_certificate : cb7583a12b85 authorisation_id : 501258 currency_code : 978 card_number : 5132.87 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : o.sieber13 order_id : 11668 customer_email : o.sieber13@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 = "11669" select * from cms_frontusers where identifiant = "a.roblin04" 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 = "11669" select * from cotisations where identifiant = "a.roblin04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132421 payment_means : MASTERCARD transmission_date : 20151229122421 payment_time : 132744 payment_date : 20151229 response_code : 00 payment_certificate : 85ada08fc351 authorisation_id : 523115 currency_code : 978 card_number : 5131.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 : a.roblin04 order_id : 11669 customer_email : a.roblin04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11671" select * from cms_frontusers where identifiant = "a.roblin04" 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 = "11671" select * from cotisations where identifiant = "g.pointard11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133014 payment_means : MASTERCARD transmission_date : 20151229123014 payment_time : 133130 payment_date : 20151229 response_code : 00 payment_certificate : 5aeed5fb4465 authorisation_id : 154620 currency_code : 978 card_number : 5131.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 : a.roblin04 order_id : 11671 customer_email : a.roblin04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11673" select * from cms_frontusers where identifiant = "g.sourisseau26" 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 = "11673" select * from cotisations where identifiant = "a.dasilvacarvalho22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134040 payment_means : MASTERCARD transmission_date : 20151229124040 payment_time : 134332 payment_date : 20151229 response_code : 00 payment_certificate : 8db04e5aad94 authorisation_id : 963154 currency_code : 978 card_number : 5131.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 : g.sourisseau26 order_id : 11673 customer_email : g.sourisseau26@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 = "11674" select * from cms_frontusers where identifiant = "b.garcialucas26" 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 = "11674" select * from cotisations where identifiant = "b.garcialucas26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135048 payment_means : MASTERCARD transmission_date : 20151229125048 payment_time : 135446 payment_date : 20151229 response_code : 00 payment_certificate : 6742b2092bc8 authorisation_id : 276112 currency_code : 978 card_number : 5132.32 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.garcialucas26 order_id : 11674 customer_email : b.garcialucas26@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 = "11676" select * from cms_frontusers where identifiant = "g.bordet16" 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 = "11676" select * from cotisations where identifiant = "g.bordet16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135355 payment_means : MASTERCARD transmission_date : 20151229125355 payment_time : 135521 payment_date : 20151229 response_code : 00 payment_certificate : f7759ec0fee5 authorisation_id : 664896 currency_code : 978 card_number : 5341.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 : g.bordet16 order_id : 11676 customer_email : g.bordet16@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 = "11677" select * from cms_frontusers where identifiant = "c.poble14" 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 = "11677" select * from cotisations where identifiant = "c.poble14" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "c.poble14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 142635 payment_means : VISA transmission_date : 20151229132635 payment_time : 142804 payment_date : 20151229 response_code : 00 payment_certificate : 91d549de2aad authorisation_id : 945703 currency_code : 978 card_number : 4972.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 : c.poble14 order_id : 11677 customer_email : c.poble14@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 = "11678" select * from cms_frontusers where identifiant = "o.murzeau16" 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 = "11678" select * from cotisations where identifiant = "o.murzeau16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143429 payment_means : MASTERCARD transmission_date : 20151229133429 payment_time : 143649 payment_date : 20151229 response_code : 00 payment_certificate : d723d782222d authorisation_id : 663552 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 : o.murzeau16 order_id : 11678 customer_email : o.murzeau16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150052 payment_means : VISA transmission_date : 20151229140052 payment_time : 150240 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.baro21 order_id : 11680 customer_email : m.baro21@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 = "11681" select * from cms_frontusers where identifiant = "p.prompt28" 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 = "11681" select * from cotisations where identifiant = "p.prompt28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150820 payment_means : VISA transmission_date : 20151229140820 payment_time : 151042 payment_date : 20151229 response_code : 00 payment_certificate : f2d8ebdfe74c authorisation_id : 193517 currency_code : 978 card_number : 4970.76 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.prompt28 order_id : 11681 customer_email : p.prompt28@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 = "11682" select * from cms_frontusers where identifiant = "g.cochon10" 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 = "11682" select * from cotisations where identifiant = "g.cochon10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162441 payment_means : MASTERCARD transmission_date : 20151229152441 payment_time : 162643 payment_date : 20151229 response_code : 00 payment_certificate : 397ba96e8500 authorisation_id : 856567 currency_code : 978 card_number : 5131.94 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.cochon10 order_id : 11682 customer_email : g.cochon10@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 : ------------------------------------------- select * from cotisations_commande where id = "11683" select * from cms_frontusers where identifiant = "r.perrin06" 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 = "11683" select * from cotisations where identifiant = "r.perrin06" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 164558 payment_means : VISA transmission_date : 20151229154558 payment_time : 164930 payment_date : 20151229 response_code : 00 payment_certificate : 7515f173b574 authorisation_id : 251217 currency_code : 978 card_number : 4970.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.perrin06 order_id : 11683 customer_email : r.perrin06@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165633 payment_means : VISA transmission_date : 20151229155633 payment_time : 170209 payment_date : 20151229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.67 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.issenhuth21 order_id : 11685 customer_email : f.issenhuth21@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11684" select * from cms_frontusers where identifiant = "f.desmedt06" 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 = "11684" select * from cotisations where identifiant = "f.desmedt06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165455 payment_means : MASTERCARD transmission_date : 20151229155455 payment_time : 170442 payment_date : 20151229 response_code : 00 payment_certificate : 8150b085237a authorisation_id : 517460 currency_code : 978 card_number : 5137.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.desmedt06 order_id : 11684 customer_email : f.desmedt06@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170222 payment_means : VISA transmission_date : 20151229160222 payment_time : 170651 payment_date : 20151229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.67 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.issenhuth21 order_id : 11685 customer_email : f.issenhuth21@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11685" select * from cms_frontusers where identifiant = "f.issenhuth21" 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 = "11685" select * from cotisations where identifiant = "f.issenhuth21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170659 payment_means : VISA transmission_date : 20151229160659 payment_time : 171030 payment_date : 20151229 response_code : 00 payment_certificate : 0b06da6677d3 authorisation_id : 562412 currency_code : 978 card_number : 4972.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 : f.issenhuth21 order_id : 11685 customer_email : f.issenhuth21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173143 payment_means : VISA transmission_date : 20151229163143 payment_time : 173622 payment_date : 20151229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.55 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.aulino15 order_id : 11686 customer_email : f.aulino15@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 : 201809 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 : 173630 payment_means : VISA transmission_date : 20151229163630 payment_time : 173750 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.aulino15 order_id : 11686 customer_email : f.aulino15@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173810 payment_means : VISA transmission_date : 20151229163810 payment_time : 173936 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.aulino15 order_id : 11686 customer_email : f.aulino15@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 = "11687" select * from cms_frontusers where identifiant = "s1.robert17" 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 = "11687" select * from cotisations where identifiant = "s1.robert17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175701 payment_means : MASTERCARD transmission_date : 20151229165701 payment_time : 175842 payment_date : 20151229 response_code : 00 payment_certificate : 36a46b64d2b9 authorisation_id : 453180 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 : s1.robert17 order_id : 11687 customer_email : s1.robert17@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 : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11690" select * from cms_frontusers where identifiant = "r.flachard15" 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 = "11690" select * from cotisations where identifiant = "m.pellissier17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183049 payment_means : MASTERCARD transmission_date : 20151229173049 payment_time : 183232 payment_date : 20151229 response_code : 00 payment_certificate : 37b77a3e4792 authorisation_id : 447914 currency_code : 978 card_number : 5131.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 : r.flachard15 order_id : 11690 customer_email : r.flachard15@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 = "11691" select * from cms_frontusers where identifiant = "f.choletais05" 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 = "11691" select * from cotisations where identifiant = "jl.aurand25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183211 payment_means : VISA transmission_date : 20151229173211 payment_time : 183355 payment_date : 20151229 response_code : 00 payment_certificate : cb761d12e16f authorisation_id : 613262 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 : f.choletais05 order_id : 11691 customer_email : f.choletais05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11692" select * from cms_frontusers where identifiant = "jj.debortoli31" 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 = "11692" select * from cotisations where identifiant = "jj.debortoli31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185715 payment_means : VISA transmission_date : 20151229175715 payment_time : 185859 payment_date : 20151229 response_code : 00 payment_certificate : 2c87a5c1ed74 authorisation_id : 916536 currency_code : 978 card_number : 4561.71 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 : jj.debortoli31 order_id : 11692 customer_email : jj.debortoli31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 191637 payment_means : MASTERCARD transmission_date : 20151229181637 payment_time : 191811 payment_date : 20151229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.paumier05 order_id : 11693 customer_email : a.paumier05@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 : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11694" select * from cms_frontusers where identifiant = "m.delvy10" 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 = "11694" select * from cotisations where identifiant = "m.delvy10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191750 payment_means : VISA transmission_date : 20151229181750 payment_time : 192150 payment_date : 20151229 response_code : 00 payment_certificate : 2a8652ce4971 authorisation_id : 552189 currency_code : 978 card_number : 4974.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 : m.delvy10 order_id : 11694 customer_email : m.delvy10@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 : 201807 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11695" select * from cms_frontusers where identifiant = "a.luthers07" 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 = "11695" select * from cotisations where identifiant = "a.luthers07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193643 payment_means : VISA transmission_date : 20151229183643 payment_time : 193906 payment_date : 20151229 response_code : 00 payment_certificate : b14362659613 authorisation_id : 356077 currency_code : 978 card_number : 4976.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 : a.luthers07 order_id : 11695 customer_email : a.luthers07@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 = "11697" select * from cms_frontusers where identifiant = "d1.maurin12" 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 = "11697" select * from cotisations where identifiant = "d1.maurin12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193836 payment_means : MASTERCARD transmission_date : 20151229183836 payment_time : 194323 payment_date : 20151229 response_code : 00 payment_certificate : eb9bfa3a9fa3 authorisation_id : 351441 currency_code : 978 card_number : 5131.64 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 : d1.maurin12 order_id : 11697 customer_email : d1.maurin12@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 = "11700" select * from cms_frontusers where identifiant = "p.brisset01" 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 = "11700" select * from cotisations where identifiant = "p.brisset01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195946 payment_means : VISA transmission_date : 20151229185946 payment_time : 200449 payment_date : 20151229 response_code : 00 payment_certificate : d5000f295b0e authorisation_id : 633921 currency_code : 978 card_number : 4970.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 : p.brisset01 order_id : 11700 customer_email : p.brisset01@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 = "11696" select * from cms_frontusers where identifiant = "l1.martin06" 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 = "11696" select * from cotisations where identifiant = "l1.martin06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193826 payment_means : MASTERCARD transmission_date : 20151229183826 payment_time : 201022 payment_date : 20151229 response_code : 00 payment_certificate : bc8b971ea03d authorisation_id : 216756 currency_code : 978 card_number : 5135.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l1.martin06 order_id : 11696 customer_email : l1.martin06@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 = "11701" select * from cms_frontusers where identifiant = "c.rodriguez18" 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 = "11701" select * from cotisations where identifiant = "c.rodriguez18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202527 payment_means : VISA transmission_date : 20151229192527 payment_time : 202817 payment_date : 20151229 response_code : 00 payment_certificate : 124e17f90a3e authorisation_id : 459534 currency_code : 978 card_number : 4975.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.rodriguez18 order_id : 11701 customer_email : c.rodriguez18@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 = "11703" select * from cms_frontusers where identifiant = "p.marty12" 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 = "11703" select * from cotisations where identifiant = "p.marty12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203617 payment_means : VISA transmission_date : 20151229193617 payment_time : 203807 payment_date : 20151229 response_code : 00 payment_certificate : f40b08bf3dd5 authorisation_id : 150516 currency_code : 978 card_number : 4974.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 : p.marty12 order_id : 11703 customer_email : p.marty12@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 : 201607 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11704" select * from cms_frontusers where identifiant = "jp.dupont28" 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 = "11704" select * from cotisations where identifiant = "l.colas05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205219 payment_means : VISA transmission_date : 20151229195219 payment_time : 205438 payment_date : 20151229 response_code : 00 payment_certificate : 807c96530427 authorisation_id : 345663 currency_code : 978 card_number : 4973.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 : jp.dupont28 order_id : 11704 customer_email : jp.dupont28@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 = "11707" select * from cms_frontusers where identifiant = "f.lacheret26" 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 = "11707" select * from cotisations where identifiant = "f.lacheret26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213343 payment_means : MASTERCARD transmission_date : 20151229203343 payment_time : 213617 payment_date : 20151229 response_code : 00 payment_certificate : 2f15281c7bb6 authorisation_id : 064666 currency_code : 978 card_number : 5131.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.lacheret26 order_id : 11707 customer_email : f.lacheret26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11708" select * from cms_frontusers where identifiant = "a.delaruelle06" 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 = "11708" select * from cotisations where identifiant = "a.delaruelle06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214150 payment_means : VISA transmission_date : 20151229204150 payment_time : 214326 payment_date : 20151229 response_code : 00 payment_certificate : 26291014b471 authorisation_id : 126034 currency_code : 978 card_number : 4973.52 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.delaruelle06 order_id : 11708 customer_email : a.delaruelle06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11709" select * from cms_frontusers where identifiant = "jf.dossmann31" 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 = "11709" select * from cotisations where identifiant = "jf.dossmann31" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "jl.testevuide10" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "j.dossmann21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 24000 transaction_id : 214747 payment_means : MASTERCARD transmission_date : 20151229204747 payment_time : 215036 payment_date : 20151229 response_code : 00 payment_certificate : 89141d4e2caf authorisation_id : 113157 currency_code : 978 card_number : 5132.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 : jf.dossmann31 order_id : 11709 customer_email : jf.dossmann31@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 = "11710" select * from cms_frontusers where identifiant = "jj.lemaitre28" 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 = "11710" select * from cotisations where identifiant = "jj.lemaitre28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214956 payment_means : VISA transmission_date : 20151229204956 payment_time : 215207 payment_date : 20151229 response_code : 00 payment_certificate : 1b786372f232 authorisation_id : 255111 currency_code : 978 card_number : 4979.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jj.lemaitre28 order_id : 11710 customer_email : jj.lemaitre28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11712" select * from cms_frontusers where identifiant = "f.jourdan16" 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 = "11712" select * from cotisations where identifiant = "f.jourdan16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220741 payment_means : MASTERCARD transmission_date : 20151229210741 payment_time : 220932 payment_date : 20151229 response_code : 00 payment_certificate : 10ec8ea586ea authorisation_id : 441901 currency_code : 978 card_number : 5137.30 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.jourdan16 order_id : 11712 customer_email : f.jourdan16@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 = "11713" select * from cms_frontusers where identifiant = "p.issenhuth18" 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 = "11713" select * from cotisations where identifiant = "p.issenhuth18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221857 payment_means : VISA transmission_date : 20151229211857 payment_time : 222245 payment_date : 20151229 response_code : 00 payment_certificate : 4b0a3b6da05d authorisation_id : 212023 currency_code : 978 card_number : 4972.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 : p.issenhuth18 order_id : 11713 customer_email : p.issenhuth18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11714" select * from cms_frontusers where identifiant = "e.plain16" 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 = "11714" select * from cotisations where identifiant = "e.plain16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225833 payment_means : MASTERCARD transmission_date : 20151229215833 payment_time : 230124 payment_date : 20151229 response_code : 00 payment_certificate : c3b81aae41ec authorisation_id : 208823 currency_code : 978 card_number : 5132.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 : e.plain16 order_id : 11714 customer_email : e.plain16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------