select * from cotisations_commande where id = "5592" 
select * from cms_frontusers where identifiant = "j.moal27" 
 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 = "5592" 
 select * from cotisations where identifiant = "j.moal27" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 065532
payment_means : MASTERCARD
transmission_date : 20150117055532
payment_time : 065705
payment_date : 20150117
response_code : 00
payment_certificate : a346b3f85539
authorisation_id : 237544
currency_code : 978
card_number : 5131.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 : j.moal27
order_id : 5592
customer_email : j.moal27@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5593" 
select * from cms_frontusers where identifiant = "t.stolla07" 
 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 = "5593" 
 select * from cotisations where identifiant = "t.stolla07" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 080941
payment_means : VISA
transmission_date : 20150117070941
payment_time : 081135
payment_date : 20150117
response_code : 00
payment_certificate : 76290a2d2b96
authorisation_id : 521451
currency_code : 978
card_number : 4976.22
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.stolla07
order_id : 5593
customer_email : t.stolla07@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 : 201504
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5594" 
select * from cms_frontusers where identifiant = "e.walker06" 
 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 = "5594" 
 select * from cotisations where identifiant = "e.walker06" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 082308
payment_means : VISA
transmission_date : 20150117072308
payment_time : 082502
payment_date : 20150117
response_code : 00
payment_certificate : 4083cb81f8bb
authorisation_id : 332956
currency_code : 978
card_number : 4973.60
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.walker06
order_id : 5594
customer_email : e.walker06@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201505
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5595" 
select * from cms_frontusers where identifiant = "n.bouvet16" 
 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 = "5595" 
 select * from cotisations where identifiant = "r.minozzi20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 082808
payment_means : VISA
transmission_date : 20150117072808
payment_time : 083115
payment_date : 20150117
response_code : 00
payment_certificate : b9a4614d9d31
authorisation_id : 384454
currency_code : 978
card_number : 4978.85
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : n.bouvet16
order_id : 5595
customer_email : n.bouvet16@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 = "5599" 
select * from cms_frontusers where identifiant = "c.carrara13" 
 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 = "5599" 
 select * from cotisations where identifiant = "c.carrara13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 102756
payment_means : MASTERCARD
transmission_date : 20150117092756
payment_time : 102927
payment_date : 20150117
response_code : 00
payment_certificate : 7fe591914756
authorisation_id : 641442
currency_code : 978
card_number : 5131.65
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.carrara13
order_id : 5599
customer_email : c.carrara13@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 = "5600" 
select * from cms_frontusers where identifiant = "c.vareillaud02" 
 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 = "5600" 
 select * from cotisations where identifiant = "f.gardet16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 103447
payment_means : VISA
transmission_date : 20150117093447
payment_time : 103550
payment_date : 20150117
response_code : 00
payment_certificate : 82a5baaa830d
authorisation_id : 302593
currency_code : 978
card_number : 4973.62
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.vareillaud02
order_id : 5600
customer_email : c.vareillaud02@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201506
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5601" 
select * from cms_frontusers where identifiant = "t.dermaux19" 
 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 = "5601" 
 select * from cotisations where identifiant = "t.dermaux19" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 111906
payment_means : VISA
transmission_date : 20150117101906
payment_time : 112043
payment_date : 20150117
response_code : 00
payment_certificate : 23fdeb7e018b
authorisation_id : 202650
currency_code : 978
card_number : 4978.15
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.dermaux19
order_id : 5601
customer_email : t.dermaux19@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 = "5602" 
select * from cms_frontusers where identifiant = "q.colin03" 
 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 = "5602" 
 select * from cotisations where identifiant = "q.colin03" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 112039
payment_means : VISA
transmission_date : 20150117102039
payment_time : 112402
payment_date : 20150117
response_code : 00
payment_certificate : dc0b5041b08e
authorisation_id : 112230
currency_code : 978
card_number : 4974.46
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 : q.colin03
order_id : 5602
customer_email : q.colin03@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 = "5603" 
select * from cms_frontusers where identifiant = "x.jeunier24" 
 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 = "5603" 
 select * from cotisations where identifiant = "x.jeunier24" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 112835
payment_means : VISA
transmission_date : 20150117102835
payment_time : 113108
payment_date : 20150117
response_code : 00
payment_certificate : dfd5f9af3b96
authorisation_id : 345684
currency_code : 978
card_number : 4978.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : x.jeunier24
order_id : 5603
customer_email : x.jeunier24@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 : 201502
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5604" 
select * from cms_frontusers where identifiant = "p.bonnifait28" 
 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 = "5604" 
 select * from cotisations where identifiant = "h.prevost28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 115141
payment_means : VISA
transmission_date : 20150117105141
payment_time : 115453
payment_date : 20150117
response_code : 00
payment_certificate : 00d07e32a552
authorisation_id : 113656
currency_code : 978
card_number : 4976.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 : p.bonnifait28
order_id : 5604
customer_email : p.bonnifait28@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 = "5605" 
select * from cms_frontusers where identifiant = "e.korner28" 
 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 = "5605" 
 select * from cotisations where identifiant = "e.korner28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 115829
payment_means : MASTERCARD
transmission_date : 20150117105829
payment_time : 115947
payment_date : 20150117
response_code : 00
payment_certificate : 02124620cb56
authorisation_id : 836818
currency_code : 978
card_number : 5132.47
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : e.korner28
order_id : 5605
customer_email : e.korner28@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 = "5606" 
select * from cms_frontusers where identifiant = "d.bris21" 
 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 = "5606" 
 select * from cotisations where identifiant = "d.bris21" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120029
payment_means : VISA
transmission_date : 20150117110029
payment_time : 120351
payment_date : 20150117
response_code : 00
payment_certificate : 6c9c41129421
authorisation_id : 000801
currency_code : 978
card_number : 4338.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 : d.bris21
order_id : 5606
customer_email : d.bris21@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201611
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5607" 
select * from cms_frontusers where identifiant = "n.beuzon05" 
 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 = "5607" 
 select * from cotisations where identifiant = "n.beuzon05" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120340
payment_means : VISA
transmission_date : 20150117110340
payment_time : 120611
payment_date : 20150117
response_code : 00
payment_certificate : 6e0c007bb393
authorisation_id : 220796
currency_code : 978
card_number : 4972.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 : n.beuzon05
order_id : 5607
customer_email : n.beuzon05@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 = "5608" 
select * from cms_frontusers where identifiant = "g.rossignol14" 
 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 = "5608" 
 select * from cotisations where identifiant = "g.rossignol14" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 120829
payment_means : MASTERCARD
transmission_date : 20150117110829
payment_time : 120959
payment_date : 20150117
response_code : 00
payment_certificate : f778ef4b06ea
authorisation_id : 346665
currency_code : 978
card_number : 5131.24
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.rossignol14
order_id : 5608
customer_email : g.rossignol14@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 = "5609" 
select * from cms_frontusers where identifiant = "l.sbrava12" 
 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 = "5609" 
 select * from cotisations where identifiant = "x.leger14" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 124220
payment_means : MASTERCARD
transmission_date : 20150117114220
payment_time : 124359
payment_date : 20150117
response_code : 00
payment_certificate : 05bdf59c1d0d
authorisation_id : 344424
currency_code : 978
card_number : 5132.07
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.sbrava12
order_id : 5609
customer_email : l.sbrava12@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 133610
payment_means : VISA
transmission_date : 20150117123610
payment_time : 133952
payment_date : 20150117
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.61
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.cabos13
order_id : 5610
customer_email : c.cabos13@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_FAILURE
statement_reference : 
card_validity : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 143546
payment_means : VISA
transmission_date : 20150117133546
payment_time : 143835
payment_date : 20150117
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.75
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 : l.bleton04
order_id : 5612
customer_email : l.bleton04@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 : 201705
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5613" 
select * from cms_frontusers where identifiant = "k.vervaeke31" 
 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 = "5613" 
 select * from cotisations where identifiant = "s.herail20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 144448
payment_means : VISA
transmission_date : 20150117134448
payment_time : 144615
payment_date : 20150117
response_code : 00
payment_certificate : e497e452b734
authorisation_id : 916293
currency_code : 978
card_number : 4972.36
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.vervaeke31
order_id : 5613
customer_email : k.vervaeke31@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 = "5614" 
select * from cms_frontusers where identifiant = "l.renvoise25" 
 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 = "5614" 
 select * from cotisations where identifiant = "l.renvoise25" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "l.renvoise25" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 144604
payment_means : VISA
transmission_date : 20150117134604
payment_time : 144759
payment_date : 20150117
response_code : 00
payment_certificate : 4f47184a1ae4
authorisation_id : 730108
currency_code : 978
card_number : 4978.01
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.renvoise25
order_id : 5614
customer_email : l.renvoise25@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201702
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5612" 
select * from cms_frontusers where identifiant = "l.bleton04" 
 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 = "5612" 
 select * from cotisations where identifiant = "l.bleton04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 143845
payment_means : VISA
transmission_date : 20150117133845
payment_time : 150657
payment_date : 20150117
response_code : 00
payment_certificate : 6c74c351e14f
authorisation_id : 206166
currency_code : 978
card_number : 4973.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 : l.bleton04
order_id : 5612
customer_email : l.bleton04@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 151335
payment_means : MASTERCARD
transmission_date : 20150117141335
payment_time : 152028
payment_date : 20150117
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.14
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 : b.perin21
order_id : 5616
customer_email : b.perin21@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_FAILURE
statement_reference : 
card_validity : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5617" 
select * from cms_frontusers where identifiant = "r.stouvenot25" 
 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 = "5617" 
 select * from cotisations where identifiant = "r.stouvenot25" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153010
payment_means : VISA
transmission_date : 20150117143010
payment_time : 153210
payment_date : 20150117
response_code : 00
payment_certificate : 5f7a5eb0ee40
authorisation_id : 395916
currency_code : 978
card_number : 4977.70
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.stouvenot25
order_id : 5617
customer_email : r.stouvenot25@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 = "5620" 
select * from cms_frontusers where identifiant = "f.march19" 
 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 = "5620" 
 select * from cotisations where identifiant = "s.antonio16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 155326
payment_means : VISA
transmission_date : 20150117145326
payment_time : 155516
payment_date : 20150117
response_code : 00
payment_certificate : d88aaab6d841
authorisation_id : 508354
currency_code : 978
card_number : 4978.37
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.march19
order_id : 5620
customer_email : f.march19@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 = "5621" 
select * from cms_frontusers where identifiant = "c.cabos13" 
 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 = "5621" 
 select * from cotisations where identifiant = "c.cabos13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 163056
payment_means : MASTERCARD
transmission_date : 20150117153056
payment_time : 163349
payment_date : 20150117
response_code : 00
payment_certificate : 186b3aa9fd11
authorisation_id : 184731
currency_code : 978
card_number : 5131.34
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.cabos13
order_id : 5621
customer_email : c.cabos13@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 = "5622" 
select * from cms_frontusers where identifiant = "s.kerimici18" 
 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 = "5622" 
 select * from cotisations where identifiant = "m.porta27" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 163234
payment_means : MASTERCARD
transmission_date : 20150117153234
payment_time : 163514
payment_date : 20150117
response_code : 00
payment_certificate : 9a35cd3a3211
authorisation_id : 610222
currency_code : 978
card_number : 5137.62
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.kerimici18
order_id : 5622
customer_email : s.kerimici18@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 : 201510
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5624" 
select * from cms_frontusers where identifiant = "a.marion28" 
 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 = "5624" 
 select * from cotisations where identifiant = "f.allab20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 164042
payment_means : VISA
transmission_date : 20150117154042
payment_time : 164231
payment_date : 20150117
response_code : 00
payment_certificate : 84dbafa57c57
authorisation_id : 465520
currency_code : 978
card_number : 4970.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.marion28
order_id : 5624
customer_email : a.marion28@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 165103
payment_means : MASTERCARD
transmission_date : 20150117155103
payment_time : 165755
payment_date : 20150117
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5137.80
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 : p1.esteban28
order_id : 5625
customer_email : p1.esteban28@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_FAILURE
statement_reference : 
card_validity : 201710
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5627" 
select * from cms_frontusers where identifiant = "a.fettu02" 
 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 = "5627" 
 select * from cotisations where identifiant = "c.bourgeois09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 175959
payment_means : VISA
transmission_date : 20150117165959
payment_time : 180200
payment_date : 20150117
response_code : 00
payment_certificate : 8e2a634dbf5b
authorisation_id : 788635
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 : a.fettu02
order_id : 5627
customer_email : a.fettu02@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 : 201510
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5628" 
select * from cms_frontusers where identifiant = "c.adam29" 
 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 = "5628" 
 select * from cotisations where identifiant = "c.adam29" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181920
payment_means : MASTERCARD
transmission_date : 20150117171920
payment_time : 182215
payment_date : 20150117
response_code : 00
payment_certificate : c3efa9efaace
authorisation_id : 336105
currency_code : 978
card_number : 5137.37
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.adam29
order_id : 5628
customer_email : c.adam29@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 = "5629" 
select * from cms_frontusers where identifiant = "d.glemin23" 
 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 = "5629" 
 select * from cotisations where identifiant = "d.glemin23" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183156
payment_means : MASTERCARD
transmission_date : 20150117173156
payment_time : 183359
payment_date : 20150117
response_code : 00
payment_certificate : 9c0d98a2e16b
authorisation_id : 945143
currency_code : 978
card_number : 5131.12
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : d.glemin23
order_id : 5629
customer_email : d.glemin23@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201501
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190856
payment_means : MASTERCARD
transmission_date : 20150117180856
payment_time : 191317
payment_date : 20150117
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.14
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 : b.perin21
order_id : 5630
customer_email : b.perin21@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_FAILURE
statement_reference : 
card_validity : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------