select * from cotisations_commande where id = "14646" 
select * from cms_frontusers where identifiant = "j.riviere26" 
 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 = "14646" 
 select * from cotisations where identifiant = "j.riviere26" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 062935
payment_means : VISA
transmission_date : 20160408042935
payment_time : 063218
payment_date : 20160408
response_code : 00
payment_certificate : 40d2869b1172
authorisation_id : 495216
currency_code : 978
card_number : 4561.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 : j.riviere26
order_id : 14646
customer_email : j.riviere26@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 = "14648" 
select * from cms_frontusers where identifiant = "v.lipp18" 
 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 = "14648" 
 select * from cotisations where identifiant = "n.george15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 124926
payment_means : VISA
transmission_date : 20160408104926
payment_time : 125143
payment_date : 20160408
response_code : 00
payment_certificate : a41a52a26988
authorisation_id : 801265
currency_code : 978
card_number : 4974.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 : v.lipp18
order_id : 14648
customer_email : v.lipp18@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 = "14647" 
select * from cms_frontusers where identifiant = "b.seres21" 
 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 = "14647" 
 select * from cotisations where identifiant = "d.touchard27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 124857
payment_means : MASTERCARD
transmission_date : 20160408104857
payment_time : 125203
payment_date : 20160408
response_code : 00
payment_certificate : 4bc40d00419d
authorisation_id : 545032
currency_code : 978
card_number : 5137.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 : b.seres21
order_id : 14647
customer_email : b.seres21@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 = "14650" 
select * from cms_frontusers where identifiant = "v.lipp18" 
 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 = "14650" 
 select * from cotisations where identifiant = "v.lipp18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 143300
payment_means : MASTERCARD
transmission_date : 20160408123300
payment_time : 151705
payment_date : 20160408
response_code : 00
payment_certificate : 9c4aede96f54
authorisation_id : 348442
currency_code : 978
card_number : 5132.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 : v.lipp18
order_id : 14650
customer_email : v.lipp18@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 = "14651" 
select * from cms_frontusers where identifiant = "n.ourdouillie17" 
 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 = "14651" 
 select * from cotisations where identifiant = "c.griset17" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "c.griset17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 152433
payment_means : CB
transmission_date : 20160408132433
payment_time : 152520
payment_date : 20160408
response_code : 00
payment_certificate : 8e86c1419442
authorisation_id : 253598
currency_code : 978
card_number : 5132.02
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.ourdouillie17
order_id : 14651
customer_email : n.ourdouillie17@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 : 201608
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14652" 
select * from cms_frontusers where identifiant = "f.ortscheid09" 
 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 = "14652" 
 select * from cotisations where identifiant = "e.fuchs25" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 184125
payment_means : MASTERCARD
transmission_date : 20160408164125
payment_time : 184444
payment_date : 20160408
response_code : 00
payment_certificate : 66c6bfb67129
authorisation_id : 450976
currency_code : 978
card_number : 5132.76
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.ortscheid09
order_id : 14652
customer_email : f.ortscheid09@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 194102
payment_means : MASTERCARD
transmission_date : 20160408174102
payment_time : 194213
payment_date : 20160408
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 
cvv_flag : 
cvv_response_code : 
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : p.pringuenon08
order_id : 14653
customer_email : p.pringuenon08@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : SSL
statement_reference : 
card_validity : 
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14653" 
select * from cms_frontusers where identifiant = "p.pringuenon08" 
 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 = "14653" 
 select * from cotisations where identifiant = "p.esnault27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 194220
payment_means : MASTERCARD
transmission_date : 20160408174220
payment_time : 194332
payment_date : 20160408
response_code : 00
payment_certificate : e3dd5ef831dd
authorisation_id : 131043
currency_code : 978
card_number : 5138.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 : p.pringuenon08
order_id : 14653
customer_email : p.pringuenon08@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 = "14654" 
select * from cms_frontusers where identifiant = "p.pringuenon08" 
 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 = "14654" 
 select * from cotisations where identifiant = "p.pringuenon08" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 194527
payment_means : VISA
transmission_date : 20160408174527
payment_time : 194649
payment_date : 20160408
response_code : 00
payment_certificate : 50fb0cb66427
authorisation_id : 164864
currency_code : 978
card_number : 4976.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 : p.pringuenon08
order_id : 14654
customer_email : p.pringuenon08@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201810
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14657" 
select * from cms_frontusers where identifiant = "a.allut17" 
 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 = "14657" 
 select * from cotisations where identifiant = "a.allut17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 202642
payment_means : VISA
transmission_date : 20160408182642
payment_time : 203737
payment_date : 20160408
response_code : 00
payment_certificate : 92ff32822b24
authorisation_id : 999249
currency_code : 978
card_number : 4972.50
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.allut17
order_id : 14657
customer_email : a.allut17@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 : 
-------------------------------------------