select * from cotisations_commande where id = "11478" 
select * from cms_frontusers where identifiant = "y.wilhelm07" 
 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 = "11478" 
 select * from cotisations where identifiant = "a.ricaud29" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 070932
payment_means : VISA
transmission_date : 20151225060932
payment_time : 071308
payment_date : 20151225
response_code : 00
payment_certificate : 2430598a6921
authorisation_id : 150641
currency_code : 978
card_number : 4974.39
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : y.wilhelm07
order_id : 11478
customer_email : y.wilhelm07@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 = "11479" 
select * from cms_frontusers where identifiant = "y.wilhelm07" 
 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 = "11479" 
 select * from cotisations where identifiant = "c.pollien02" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 071409
payment_means : VISA
transmission_date : 20151225061409
payment_time : 071535
payment_date : 20151225
response_code : 00
payment_certificate : 240b4e16fee1
authorisation_id : 254491
currency_code : 978
card_number : 4974.39
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : y.wilhelm07
order_id : 11479
customer_email : y.wilhelm07@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 = "11480" 
select * from cms_frontusers where identifiant = "c.gouret14" 
 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 = "11480" 
 select * from cotisations where identifiant = "c.gouret14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 101357
payment_means : VISA
transmission_date : 20151225091357
payment_time : 101522
payment_date : 20151225
response_code : 00
payment_certificate : 15755ad42b52
authorisation_id : 285231
currency_code : 978
card_number : 4561.98
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.gouret14
order_id : 11480
customer_email : c.gouret14@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 = "11481" 
select * from cms_frontusers where identifiant = "j.fort07" 
 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 = "11481" 
 select * from cotisations where identifiant = "j.fort07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 101851
payment_means : VISA
transmission_date : 20151225091851
payment_time : 102241
payment_date : 20151225
response_code : 00
payment_certificate : bd5062648516
authorisation_id : 485522
currency_code : 978
card_number : 4978.18
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : j.fort07
order_id : 11481
customer_email : j.fort07@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 = "11482" 
select * from cms_frontusers where identifiant = "l.adam18" 
 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 = "11482" 
 select * from cotisations where identifiant = "l.adam18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 103612
payment_means : VISA
transmission_date : 20151225093612
payment_time : 103953
payment_date : 20151225
response_code : 00
payment_certificate : 2b97606d730b
authorisation_id : 645041
currency_code : 978
card_number : 4975.25
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : l.adam18
order_id : 11482
customer_email : l.adam18@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "11483" 
select * from cms_frontusers where identifiant = "h.mollaret27" 
 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 = "11483" 
 select * from cotisations where identifiant = "h.mollaret27" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "a.mollaret02" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 12000
transaction_id : 111752
payment_means : VISA
transmission_date : 20151225101752
payment_time : 112157
payment_date : 20151225
response_code : 00
payment_certificate : 3b648be97b83
authorisation_id : 534678
currency_code : 978
card_number : 4973.84
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : h.mollaret27
order_id : 11483
customer_email : h.mollaret27@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 = "11485" 
select * from cms_frontusers where identifiant = "b.medina03" 
 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 = "11485" 
 select * from cotisations where identifiant = "b.medina03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 143857
payment_means : VISA
transmission_date : 20151225133857
payment_time : 144046
payment_date : 20151225
response_code : 00
payment_certificate : 6b3615e48d61
authorisation_id : 345012
currency_code : 978
card_number : 4974.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 : b.medina03
order_id : 11485
customer_email : b.medina03@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 = "11486" 
select * from cms_frontusers where identifiant = "j.dessenne05" 
 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 = "11486" 
 select * from cotisations where identifiant = "j.dessenne05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 180641
payment_means : MASTERCARD
transmission_date : 20151225170641
payment_time : 180805
payment_date : 20151225
response_code : 00
payment_certificate : de899acb7cc1
authorisation_id : 241665
currency_code : 978
card_number : 5131.99
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.dessenne05
order_id : 11486
customer_email : j.dessenne05@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 : 201806
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11487" 
select * from cms_frontusers where identifiant = "g.denoyelle17" 
 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 = "11487" 
 select * from cotisations where identifiant = "g.denoyelle17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 181218
payment_means : MASTERCARD
transmission_date : 20151225171218
payment_time : 181555
payment_date : 20151225
response_code : 00
payment_certificate : c889c641be8a
authorisation_id : 440646
currency_code : 978
card_number : 5132.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 : g.denoyelle17
order_id : 11487
customer_email : g.denoyelle17@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201710
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190104
payment_means : VISA
transmission_date : 20151225180104
payment_time : 190504
payment_date : 20151225
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.66
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 : jc.juzan18
order_id : 11488
customer_email : jc.juzan18@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 = "11488" 
select * from cms_frontusers where identifiant = "jc.juzan18" 
 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 = "11488" 
 select * from cotisations where identifiant = "jc.juzan18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190630
payment_means : VISA
transmission_date : 20151225180630
payment_time : 190745
payment_date : 20151225
response_code : 00
payment_certificate : 624070c6f033
authorisation_id : 123143
currency_code : 978
card_number : 4970.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 : jc.juzan18
order_id : 11488
customer_email : jc.juzan18@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 = "11489" 
select * from cms_frontusers where identifiant = "m.rolland27" 
 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 = "11489" 
 select * from cotisations where identifiant = "m.rolland27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 194217
payment_means : VISA
transmission_date : 20151225184217
payment_time : 194424
payment_date : 20151225
response_code : 00
payment_certificate : 70d5d910f1ff
authorisation_id : 478514
currency_code : 978
card_number : 4974.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 : m.rolland27
order_id : 11489
customer_email : m.rolland27@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "11490" 
select * from cms_frontusers where identifiant = "g.gres05" 
 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 = "11490" 
 select * from cotisations where identifiant = "g.gres05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204448
payment_means : VISA
transmission_date : 20151225194448
payment_time : 204814
payment_date : 20151225
response_code : 00
payment_certificate : 0ef80736cdff
authorisation_id : 069482
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 : g.gres05
order_id : 11490
customer_email : g.gres05@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "11491" 
select * from cms_frontusers where identifiant = "jy.nicolas04" 
 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 = "11491" 
 select * from cotisations where identifiant = "jy.nicolas04" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 223255
payment_means : VISA
transmission_date : 20151225213255
payment_time : 224015
payment_date : 20151225
response_code : 00
payment_certificate : 4174e4a2508c
authorisation_id : 285303
currency_code : 978
card_number : 4974.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 : jy.nicolas04
order_id : 11491
customer_email : jy.nicolas04@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 : 
-------------------------------------------