select * from cotisations_commande where id = "6390" 
select * from cms_frontusers where identifiant = "c.guyard17" 
 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 = "6390" 
 select * from cotisations where identifiant = "m.kowalzyk11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 065137
payment_means : VISA
transmission_date : 20150218055137
payment_time : 065328
payment_date : 20150218
response_code : 00
payment_certificate : a9bc8cd3d506
authorisation_id : 933195
currency_code : 978
card_number : 4975.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.guyard17
order_id : 6390
customer_email : c.guyard17@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 = "6391" 
select * from cms_frontusers where identifiant = "p.jorge17" 
 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 = "6391" 
 select * from cotisations where identifiant = "s.daviau06" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 075211
payment_means : MASTERCARD
transmission_date : 20150218065211
payment_time : 075329
payment_date : 20150218
response_code : 00
payment_certificate : 09fe15f1373b
authorisation_id : 894290
currency_code : 978
card_number : 5132.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 : p.jorge17
order_id : 6391
customer_email : p.jorge17@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 = "6392" 
select * from cms_frontusers where identifiant = "f.lasserre19" 
 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 = "6392" 
 select * from cotisations where identifiant = "f.lasserre19" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 090529
payment_means : VISA
transmission_date : 20150218080529
payment_time : 091222
payment_date : 20150218
response_code : 00
payment_certificate : 6f23f9a1ed27
authorisation_id : 522147
currency_code : 978
card_number : 4970.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.lasserre19
order_id : 6392
customer_email : f.lasserre19@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 121958
payment_means : VISA
transmission_date : 20150218111958
payment_time : 122204
payment_date : 20150218
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.40
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 56
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.lapalus21
order_id : 6393
customer_email : m.lapalus21@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 = "6394" 
select * from cms_frontusers where identifiant = "a.guinee11" 
 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 = "6394" 
 select * from cotisations where identifiant = "a.guinee11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 132338
payment_means : MASTERCARD
transmission_date : 20150218122338
payment_time : 132447
payment_date : 20150218
response_code : 00
payment_certificate : efa8357de25a
authorisation_id : 369600
currency_code : 978
card_number : 5341.11
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.guinee11
order_id : 6394
customer_email : a.guinee11@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 = "6395" 
select * from cms_frontusers where identifiant = "d.lallouet08" 
 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 = "6395" 
 select * from cotisations where identifiant = "d.lallouet08" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 164727
payment_means : VISA
transmission_date : 20150218154727
payment_time : 165010
payment_date : 20150218
response_code : 00
payment_certificate : bfe918a8fa7e
authorisation_id : 116221
currency_code : 978
card_number : 4973.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 : d.lallouet08
order_id : 6395
customer_email : d.lallouet08@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 : 181037
payment_means : VISA
transmission_date : 20150218171037
payment_time : 181615
payment_date : 20150218
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4562.87
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 : e.simplot10
order_id : 6397
customer_email : e.simplot10@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 : 201603
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6397" 
select * from cms_frontusers where identifiant = "e.simplot10" 
 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 = "6397" 
 select * from cotisations where identifiant = "e.simplot10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181632
payment_means : VISA
transmission_date : 20150218171632
payment_time : 181839
payment_date : 20150218
response_code : 00
payment_certificate : 4e8f6e18f942
authorisation_id : 506137
currency_code : 978
card_number : 4562.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 : e.simplot10
order_id : 6397
customer_email : e.simplot10@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 = "6398" 
select * from cms_frontusers where identifiant = "a.essaih01" 
 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 = "6398" 
 select * from cotisations where identifiant = "a.essaih01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 181917
payment_means : VISA
transmission_date : 20150218171917
payment_time : 182201
payment_date : 20150218
response_code : 00
payment_certificate : 4d55e3ca7c96
authorisation_id : 445272
currency_code : 978
card_number : 4973.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 : a.essaih01
order_id : 6398
customer_email : a.essaih01@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 = "6399" 
select * from cms_frontusers where identifiant = "m.chaillot27" 
 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 = "6399" 
 select * from cotisations where identifiant = "jl.chastel28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182538
payment_means : MASTERCARD
transmission_date : 20150218172538
payment_time : 182701
payment_date : 20150218
response_code : 00
payment_certificate : 9cf70ab15e25
authorisation_id : 151254
currency_code : 978
card_number : 5132.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 : m.chaillot27
order_id : 6399
customer_email : m.chaillot27@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6401" 
select * from cms_frontusers where identifiant = "j.froidefond20" 
 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 = "6401" 
 select * from cotisations where identifiant = "j.froidefond20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 203246
payment_means : VISA
transmission_date : 20150218193246
payment_time : 203507
payment_date : 20150218
response_code : 00
payment_certificate : fdb4eeb4432f
authorisation_id : 101301
currency_code : 978
card_number : 4974.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 : j.froidefond20
order_id : 6401
customer_email : j.froidefond20@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 : 201708
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6402" 
select * from cms_frontusers where identifiant = "s.rodrigo25" 
 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 = "6402" 
 select * from cotisations where identifiant = "a.boutin09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 203337
payment_means : VISA
transmission_date : 20150218193337
payment_time : 203605
payment_date : 20150218
response_code : 00
payment_certificate : 8b13263d9da4
authorisation_id : 164522
currency_code : 978
card_number : 4978.17
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : s.rodrigo25
order_id : 6402
customer_email : s.rodrigo25@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 = "6403" 
select * from cms_frontusers where identifiant = "l.cacchia05" 
 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 = "6403" 
 select * from cotisations where identifiant = "l.cacchia05" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 203651
payment_means : VISA
transmission_date : 20150218193651
payment_time : 203830
payment_date : 20150218
response_code : 00
payment_certificate : 6897be029966
authorisation_id : 240545
currency_code : 978
card_number : 4976.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 : l.cacchia05
order_id : 6403
customer_email : l.cacchia05@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 = "6404" 
select * from cms_frontusers where identifiant = "t.gerard12" 
 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 = "6404" 
 select * from cotisations where identifiant = "t.gerard12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211140
payment_means : VISA
transmission_date : 20150218201140
payment_time : 211907
payment_date : 20150218
response_code : 00
payment_certificate : 650139296be1
authorisation_id : 637330
currency_code : 978
card_number : 4970.69
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.gerard12
order_id : 6404
customer_email : t.gerard12@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 = "6405" 
select * from cms_frontusers where identifiant = "v.audebert08" 
 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 = "6405" 
 select * from cotisations where identifiant = "v.audebert08" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212616
payment_means : VISA
transmission_date : 20150218202616
payment_time : 212821
payment_date : 20150218
response_code : 00
payment_certificate : 83c58974e461
authorisation_id : 557319
currency_code : 978
card_number : 4975.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 : v.audebert08
order_id : 6405
customer_email : v.audebert08@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 = "6406" 
select * from cms_frontusers where identifiant = "m.philippe13" 
 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 = "6406" 
 select * from cotisations where identifiant = "m.philippe13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214705
payment_means : VISA
transmission_date : 20150218204705
payment_time : 215048
payment_date : 20150218
response_code : 00
payment_certificate : 5359402cc21c
authorisation_id : 418463
currency_code : 978
card_number : 4973.95
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.philippe13
order_id : 6406
customer_email : m.philippe13@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 = "6407" 
select * from cms_frontusers where identifiant = "t.wolfert06" 
 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 = "6407" 
 select * from cotisations where identifiant = "t.wolfert06" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 234902
payment_means : MASTERCARD
transmission_date : 20150218224902
payment_time : 235233
payment_date : 20150218
response_code : 00
payment_certificate : c287888c4ff6
authorisation_id : 755613
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 : t.wolfert06
order_id : 6407
customer_email : t.wolfert06@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 : 
-------------------------------------------