select * from cotisations_commande where id = "13936" 
select * from cms_frontusers where identifiant = "a.fumard29" 
 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 = "13936" 
 select * from cotisations where identifiant = "a.fumard29" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 072506
payment_means : VISA
transmission_date : 20160216062506
payment_time : 072638
payment_date : 20160216
response_code : 00
payment_certificate : f70b33e08a6b
authorisation_id : 333628
currency_code : 978
card_number : 4533.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 : a.fumard29
order_id : 13936
customer_email : a.fumard29@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 073433
payment_means : VISA
transmission_date : 20160216063433
payment_time : 073600
payment_date : 20160216
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4533.09
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.combernoux22
order_id : 13937
customer_email : b.combernoux22@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 : 201801
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "13938" 
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 = "13938" 
 select * from cotisations where identifiant = "a.essaih01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 081620
payment_means : VISA
transmission_date : 20160216071620
payment_time : 081916
payment_date : 20160216
response_code : 00
payment_certificate : 395430bcd072
authorisation_id : 514132
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 : 13938
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 = "13940" 
select * from cms_frontusers where identifiant = "b.borruso28" 
 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 = "13940" 
 select * from cotisations where identifiant = "b.borruso28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 085651
payment_means : MASTERCARD
transmission_date : 20160216075651
payment_time : 090219
payment_date : 20160216
response_code : 00
payment_certificate : ad71ece645ca
authorisation_id : 412245
currency_code : 978
card_number : 5131.80
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.borruso28
order_id : 13940
customer_email : b.borruso28@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 : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "13941" 
select * from cms_frontusers where identifiant = "c.deruggiero05" 
 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 = "13941" 
 select * from cotisations where identifiant = "c.deruggiero05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 105215
payment_means : VISA
transmission_date : 20160216095215
payment_time : 105341
payment_date : 20160216
response_code : 00
payment_certificate : 5945e4b77603
authorisation_id : 300155
currency_code : 978
card_number : 4972.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 : c.deruggiero05
order_id : 13941
customer_email : c.deruggiero05@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 = "13943" 
select * from cms_frontusers where identifiant = "y.madec17" 
 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 = "13943" 
 select * from cotisations where identifiant = "d.sergeant10" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "d.sergeant10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 120534
payment_means : VISA
transmission_date : 20160216110534
payment_time : 120817
payment_date : 20160216
response_code : 00
payment_certificate : aed92d313162
authorisation_id : 434336
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 : y.madec17
order_id : 13943
customer_email : y.madec17@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 = "13946" 
select * from cms_frontusers where identifiant = "a.coutarel08" 
 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 = "13946" 
 select * from cotisations where identifiant = "a.coutarel08" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 151607
payment_means : MASTERCARD
transmission_date : 20160216141607
payment_time : 151713
payment_date : 20160216
response_code : 00
payment_certificate : a27dc7ba31dc
authorisation_id : 033656
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 : a.coutarel08
order_id : 13946
customer_email : a.coutarel08@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 = "13947" 
select * from cms_frontusers where identifiant = "e.corsini02" 
 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 = "13947" 
 select * from cotisations where identifiant = "e.corsini02" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 154202
payment_means : VISA
transmission_date : 20160216144202
payment_time : 154412
payment_date : 20160216
response_code : 00
payment_certificate : a9fc720eecfc
authorisation_id : 124741
currency_code : 978
card_number : 4975.28
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.corsini02
order_id : 13947
customer_email : e.corsini02@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 = "13948" 
select * from cms_frontusers where identifiant = "j.huard12" 
 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 = "13948" 
 select * from cotisations where identifiant = "g.bruon07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 163036
payment_means : VISA
transmission_date : 20160216153036
payment_time : 163225
payment_date : 20160216
response_code : 00
payment_certificate : fa1929d578ff
authorisation_id : 616340
currency_code : 978
card_number : 4973.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 : j.huard12
order_id : 13948
customer_email : j.huard12@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 = "13949" 
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 = "13949" 
 select * from cotisations where identifiant = "p.valet01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 171148
payment_means : VISA
transmission_date : 20160216161148
payment_time : 171359
payment_date : 20160216
response_code : 00
payment_certificate : 142aea5b78a7
authorisation_id : 129156
currency_code : 978
card_number : 4974.39
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : y.wilhelm07
order_id : 13949
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 = "13951" 
select * from cms_frontusers where identifiant = "v.vanhove26" 
 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 = "13951" 
 select * from cotisations where identifiant = "v.vanhove26" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182505
payment_means : VISA
transmission_date : 20160216172505
payment_time : 182914
payment_date : 20160216
response_code : 00
payment_certificate : 080e5c7f641f
authorisation_id : 846127
currency_code : 978
card_number : 4974.08
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : v.vanhove26
order_id : 13951
customer_email : v.vanhove26@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 = "13952" 
select * from cms_frontusers where identifiant = "z.mouhot25" 
 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 = "13952" 
 select * from cotisations where identifiant = "m.fontanay10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 182907
payment_means : MASTERCARD
transmission_date : 20160216172907
payment_time : 183039
payment_date : 20160216
response_code : 00
payment_certificate : 21fd6921ca74
authorisation_id : 155714
currency_code : 978
card_number : 5132.68
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 : z.mouhot25
order_id : 13952
customer_email : z.mouhot25@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 = "13953" 
select * from cms_frontusers where identifiant = "h.raharijao04" 
 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 = "13953" 
 select * from cotisations where identifiant = "pa.charbonneau23" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "pa.charbonneau23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 190022
payment_means : MASTERCARD
transmission_date : 20160216180022
payment_time : 190211
payment_date : 20160216
response_code : 00
payment_certificate : a269026f4a11
authorisation_id : 110415
currency_code : 978
card_number : 5131.04
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 : h.raharijao04
order_id : 13953
customer_email : h.raharijao04@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 : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "13954" 
select * from cms_frontusers where identifiant = "l.dufoix11" 
 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 = "13954" 
 select * from cotisations where identifiant = "l.dufoix11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 191440
payment_means : VISA
transmission_date : 20160216181440
payment_time : 191759
payment_date : 20160216
response_code : 00
payment_certificate : 021fbcd6ced0
authorisation_id : 508060
currency_code : 978
card_number : 4977.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 : l.dufoix11
order_id : 13954
customer_email : l.dufoix11@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 200356
payment_means : VISA
transmission_date : 20160216190356
payment_time : 200650
payment_date : 20160216
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4762.11
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 54
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.fruneau26
order_id : 13955
customer_email : t.fruneau26@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "13957" 
select * from cms_frontusers where identifiant = "c.pincemaille28" 
 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 = "13957" 
 select * from cotisations where identifiant = "j.tylman19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 203306
payment_means : MASTERCARD
transmission_date : 20160216193306
payment_time : 203507
payment_date : 20160216
response_code : 00
payment_certificate : 1a99e33e46e0
authorisation_id : 154656
currency_code : 978
card_number : 5137.71
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.pincemaille28
order_id : 13957
customer_email : c.pincemaille28@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 : 201707
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 : 210314
payment_means : VISA
transmission_date : 20160216200314
payment_time : 211030
payment_date : 20160216
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.42
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 : k.ardouin21
order_id : 13958
customer_email : k.ardouin21@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 = "13958" 
select * from cms_frontusers where identifiant = "k.ardouin21" 
 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 = "13958" 
 select * from cotisations where identifiant = "k.ardouin21" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211142
payment_means : VISA
transmission_date : 20160216201142
payment_time : 211505
payment_date : 20160216
response_code : 00
payment_certificate : c5114dceeb3a
authorisation_id : 566353
currency_code : 978
card_number : 4970.42
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.ardouin21
order_id : 13958
customer_email : k.ardouin21@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "13959" 
select * from cms_frontusers where identifiant = "m.carlin26" 
 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 = "13959" 
 select * from cotisations where identifiant = "m.carlin26" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "s.douay31" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 211553
payment_means : VISA
transmission_date : 20160216201553
payment_time : 211828
payment_date : 20160216
response_code : 00
payment_certificate : 4bd4a9d8e793
authorisation_id : 354946
currency_code : 978
card_number : 4562.10
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.carlin26
order_id : 13959
customer_email : m.carlin26@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "13961" 
select * from cms_frontusers where identifiant = "h.vaslin20" 
 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 = "13961" 
 select * from cotisations where identifiant = "h.vaslin20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 220438
payment_means : VISA
transmission_date : 20160216210438
payment_time : 220740
payment_date : 20160216
response_code : 00
payment_certificate : fe3f9e9b0e45
authorisation_id : 292325
currency_code : 978
card_number : 4978.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 : h.vaslin20
order_id : 13961
customer_email : h.vaslin20@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 = "13962" 
select * from cms_frontusers where identifiant = "h.vaslin20" 
 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 = "13962" 
 select * from cotisations where identifiant = "h.vaslin20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 220821
payment_means : VISA
transmission_date : 20160216210821
payment_time : 220929
payment_date : 20160216
response_code : 00
payment_certificate : c271e2b91ccc
authorisation_id : 636744
currency_code : 978
card_number : 4978.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 : h.vaslin20
order_id : 13962
customer_email : h.vaslin20@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 = "13964" 
select * from cms_frontusers where identifiant = "t.wattiau29" 
 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 = "13964" 
 select * from cotisations where identifiant = "t.wattiau29" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221821
payment_means : VISA
transmission_date : 20160216211821
payment_time : 222000
payment_date : 20160216
response_code : 00
payment_certificate : 7d074eaf699a
authorisation_id : 025216
currency_code : 978
card_number : 4973.09
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.wattiau29
order_id : 13964
customer_email : t.wattiau29@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 = "13963" 
select * from cms_frontusers where identifiant = "y.desforges30" 
 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 = "13963" 
 select * from cotisations where identifiant = "y.desforges30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 221800
payment_means : VISA
transmission_date : 20160216211800
payment_time : 222113
payment_date : 20160216
response_code : 00
payment_certificate : a9a41cd7d115
authorisation_id : 626743
currency_code : 978
card_number : 4972.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 : y.desforges30
order_id : 13963
customer_email : y.desforges30@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 = "13965" 
select * from cms_frontusers where identifiant = "j.lebian25" 
 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 = "13965" 
 select * from cotisations where identifiant = "j.lebian25" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 222220
payment_means : MASTERCARD
transmission_date : 20160216212220
payment_time : 222641
payment_date : 20160216
response_code : 00
payment_certificate : 50119bc6d9ba
authorisation_id : 129831
currency_code : 978
card_number : 5135.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 : j.lebian25
order_id : 13965
customer_email : j.lebian25@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "13966" 
select * from cms_frontusers where identifiant = "n.mendonca06" 
 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 = "13966" 
 select * from cotisations where identifiant = "n.mendonca06" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "n.mendonca06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 223135
payment_means : MASTERCARD
transmission_date : 20160216213135
payment_time : 223243
payment_date : 20160216
response_code : 00
payment_certificate : 9c01bf550eec
authorisation_id : 617554
currency_code : 978
card_number : 5131.55
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.mendonca06
order_id : 13966
customer_email : n.mendonca06@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------