select * from cotisations_commande where id = "19036" select * from cms_frontusers where identifiant = "f.dubuisson18" 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 = "19036" select * from cotisations where identifiant = "f.dubuisson18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080500 payment_means : VISA transmission_date : 20161225070500 payment_time : 080751 payment_date : 20161225 response_code : 00 payment_certificate : d53417a4c3c9 authorisation_id : 643161 currency_code : 978 card_number : 4971.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.dubuisson18 order_id : 19036 customer_email : f.dubuisson18@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 = "19037" select * from cms_frontusers where identifiant = "p.gallet11" 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 = "19037" select * from cotisations where identifiant = "p.gallet11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 094051 payment_means : VISA transmission_date : 20161225084051 payment_time : 094418 payment_date : 20161225 response_code : 00 payment_certificate : 65a15e7613d8 authorisation_id : 853147 currency_code : 978 card_number : 4973.78 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.gallet11 order_id : 19037 customer_email : p.gallet11@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 : 201802 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 : 122252 payment_means : MASTERCARD transmission_date : 20161225112252 payment_time : 122441 payment_date : 20161225 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.speich25 order_id : 19039 customer_email : jm.speich25@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19040" select * from cms_frontusers where identifiant = "m.borde23" 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 = "19040" select * from cotisations where identifiant = "m.borde23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 123313 payment_means : VISA transmission_date : 20161225113313 payment_time : 123830 payment_date : 20161225 response_code : 00 payment_certificate : be9b0e42fba6 authorisation_id : 967023 currency_code : 978 card_number : 4973.51 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.borde23 order_id : 19040 customer_email : m.borde23@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 = "19041" select * from cms_frontusers where identifiant = "jg.laventie15" 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 = "19041" select * from cotisations where identifiant = "jg.laventie15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130050 payment_means : VISA transmission_date : 20161225120050 payment_time : 130407 payment_date : 20161225 response_code : 00 payment_certificate : f5403c475ec6 authorisation_id : 313665 currency_code : 978 card_number : 4977.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 : jg.laventie15 order_id : 19041 customer_email : jg.laventie15@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 = "19042" select * from cms_frontusers where identifiant = "m.dimundu17" 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 = "19042" select * from cotisations where identifiant = "m.dimundu17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 155853 payment_means : VISA transmission_date : 20161225145853 payment_time : 160055 payment_date : 20161225 response_code : 00 payment_certificate : 27f12b526330 authorisation_id : 124114 currency_code : 978 card_number : 4978.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.dimundu17 order_id : 19042 customer_email : m.dimundu17@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 = "19043" select * from cms_frontusers where identifiant = "p.brugiere23" 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 = "19043" select * from cotisations where identifiant = "p.brugiere23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165007 payment_means : VISA transmission_date : 20161225155007 payment_time : 165240 payment_date : 20161225 response_code : 00 payment_certificate : ea273176b525 authorisation_id : 332505 currency_code : 978 card_number : 4533.75 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.brugiere23 order_id : 19043 customer_email : p.brugiere23@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 = "19044" select * from cms_frontusers where identifiant = "t.ory21" 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 = "19044" select * from cotisations where identifiant = "t.ory21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 170234 payment_means : VISA transmission_date : 20161225160234 payment_time : 170449 payment_date : 20161225 response_code : 00 payment_certificate : 69c56c7543d9 authorisation_id : 104615 currency_code : 978 card_number : 4970.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.ory21 order_id : 19044 customer_email : t.ory21@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 = "19045" select * from cms_frontusers where identifiant = "t.javelot16" 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 = "19045" select * from cotisations where identifiant = "t.javelot16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174839 payment_means : VISA transmission_date : 20161225164839 payment_time : 175137 payment_date : 20161225 response_code : 00 payment_certificate : c5f00ca1eee5 authorisation_id : 852117 currency_code : 978 card_number : 4150.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.javelot16 order_id : 19045 customer_email : t.javelot16@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 = "19046" select * from cms_frontusers where identifiant = "jl.bataille01" 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 = "19046" select * from cotisations where identifiant = "jl.bataille01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182914 payment_means : MASTERCARD transmission_date : 20161225172914 payment_time : 183508 payment_date : 20161225 response_code : 00 payment_certificate : 979f48b5100d authorisation_id : 649312 currency_code : 978 card_number : 5137.89 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.bataille01 order_id : 19046 customer_email : jl.bataille01@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 = "19047" select * from cms_frontusers where identifiant = "k.despujols14" 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 = "19047" select * from cotisations where identifiant = "k.despujols14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183422 payment_means : VISA transmission_date : 20161225173422 payment_time : 183807 payment_date : 20161225 response_code : 00 payment_certificate : 0fa3d57e3b3f authorisation_id : 095633 currency_code : 978 card_number : 4972.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 : k.despujols14 order_id : 19047 customer_email : k.despujols14@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19048" select * from cms_frontusers where identifiant = "d.canonne22" 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 = "19048" select * from cotisations where identifiant = "d.canonne22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192157 payment_means : VISA transmission_date : 20161225182157 payment_time : 192402 payment_date : 20161225 response_code : 00 payment_certificate : e26ea7049a62 authorisation_id : 825295 currency_code : 978 card_number : 4975.56 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.canonne22 order_id : 19048 customer_email : d.canonne22@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 = "19049" select * from cms_frontusers where identifiant = "p.bernard10" 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 = "19049" select * from cotisations where identifiant = "p.bernard10" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "p.bernard10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195253 payment_means : MASTERCARD transmission_date : 20161225185253 payment_time : 195525 payment_date : 20161225 response_code : 00 payment_certificate : d25a3ee10a5e authorisation_id : 471071 currency_code : 978 card_number : 5131.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bernard10 order_id : 19049 customer_email : p.bernard10@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 = "19050" select * from cms_frontusers where identifiant = "g.canuet17" 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 = "19050" select * from cotisations where identifiant = "g.canuet17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195441 payment_means : VISA transmission_date : 20161225185441 payment_time : 195735 payment_date : 20161225 response_code : 00 payment_certificate : b6d185c66102 authorisation_id : 161761 currency_code : 978 card_number : 4973.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.canuet17 order_id : 19050 customer_email : g.canuet17@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 = "19052" select * from cms_frontusers where identifiant = "b.menestrello22" 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 = "19052" select * from cotisations where identifiant = "a.menestrello12" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "v.menestrello14" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "v.menestrello14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 215628 payment_means : VISA transmission_date : 20161225205628 payment_time : 215737 payment_date : 20161225 response_code : 00 payment_certificate : 5ad4e614d2bf authorisation_id : 346025 currency_code : 978 card_number : 4974.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.menestrello22 order_id : 19052 customer_email : b.menestrello22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19053" select * from cms_frontusers where identifiant = "b.menestrello22" 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 = "19053" select * from cotisations where identifiant = "f.vitry22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215902 payment_means : VISA transmission_date : 20161225205902 payment_time : 215941 payment_date : 20161225 response_code : 00 payment_certificate : 99157dd07050 authorisation_id : 047865 currency_code : 978 card_number : 4974.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.menestrello22 order_id : 19053 customer_email : b.menestrello22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19054" select * from cms_frontusers where identifiant = "y.krivocheine26" 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 = "19054" select * from cotisations where identifiant = "y.krivocheine26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221154 payment_means : VISA transmission_date : 20161225211154 payment_time : 221351 payment_date : 20161225 response_code : 00 payment_certificate : 2efa8f603e66 authorisation_id : 954610 currency_code : 978 card_number : 4973.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 : y.krivocheine26 order_id : 19054 customer_email : y.krivocheine26@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 = "19055" select * from cms_frontusers where identifiant = "n.poupard10" 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 = "19055" select * from cotisations where identifiant = "n.poupard10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225659 payment_means : MASTERCARD transmission_date : 20161225215659 payment_time : 230104 payment_date : 20161225 response_code : 00 payment_certificate : f5221744db96 authorisation_id : 466969 currency_code : 978 card_number : 5131.33 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.poupard10 order_id : 19055 customer_email : n.poupard10@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 : -------------------------------------------