select * from cotisations_commande where id = "9787" 
select * from cms_frontusers where identifiant = "d.merzeau28" 
 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 = "9787" 
 select * from cotisations where identifiant = "d.merzeau28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 064508
payment_means : VISA
transmission_date : 20151203054508
payment_time : 064833
payment_date : 20151203
response_code : 00
payment_certificate : 967a9ead6922
authorisation_id : 686236
currency_code : 978
card_number : 4978.48
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.merzeau28
order_id : 9787
customer_email : d.merzeau28@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 = "9788" 
select * from cms_frontusers where identifiant = "vr.macel25" 
 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 = "9788" 
 select * from cotisations where identifiant = "vr.macel25" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 065413
payment_means : VISA
transmission_date : 20151203055413
payment_time : 065551
payment_date : 20151203
response_code : 00
payment_certificate : 6dffa2f74063
authorisation_id : 727304
currency_code : 978
card_number : 4976.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 : vr.macel25
order_id : 9788
customer_email : vr.macel25@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 = "9789" 
select * from cms_frontusers where identifiant = "jb.carrere30" 
 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 = "9789" 
 select * from cotisations where identifiant = "jb.carrere30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 074226
payment_means : VISA
transmission_date : 20151203064226
payment_time : 074503
payment_date : 20151203
response_code : 00
payment_certificate : 6557430afbef
authorisation_id : 060183
currency_code : 978
card_number : 4975.40
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 : jb.carrere30
order_id : 9789
customer_email : jb.carrere30@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 = "9790" 
select * from cms_frontusers where identifiant = "s.marquis22" 
 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 = "9790" 
 select * from cotisations where identifiant = "c.barbareau30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 094328
payment_means : VISA
transmission_date : 20151203084328
payment_time : 094528
payment_date : 20151203
response_code : 00
payment_certificate : 807c81ee2561
authorisation_id : 224448
currency_code : 978
card_number : 4970.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 : s.marquis22
order_id : 9790
customer_email : s.marquis22@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 = "9791" 
select * from cms_frontusers where identifiant = "ja.frouin05" 
 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 = "9791" 
 select * from cotisations where identifiant = "ja.frouin05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 094954
payment_means : MASTERCARD
transmission_date : 20151203084954
payment_time : 095128
payment_date : 20151203
response_code : 00
payment_certificate : 90f0a4636085
authorisation_id : 116056
currency_code : 978
card_number : 5137.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 : ja.frouin05
order_id : 9791
customer_email : ja.frouin05@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 = "9792" 
select * from cms_frontusers where identifiant = "y.jallu15" 
 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 = "9792" 
 select * from cotisations where identifiant = "y.jallu15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 110010
payment_means : MASTERCARD
transmission_date : 20151203100010
payment_time : 110238
payment_date : 20151203
response_code : 00
payment_certificate : 3148c1a7d12a
authorisation_id : 533469
currency_code : 978
card_number : 5137.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 : y.jallu15
order_id : 9792
customer_email : y.jallu15@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 = "9793" 
select * from cms_frontusers where identifiant = "h.dickx01" 
 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 = "9793" 
 select * from cotisations where identifiant = "h.dickx01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 111114
payment_means : VISA
transmission_date : 20151203101114
payment_time : 111426
payment_date : 20151203
response_code : 00
payment_certificate : 33ccec4ce354
authorisation_id : 381622
currency_code : 978
card_number : 4975.67
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.dickx01
order_id : 9793
customer_email : h.dickx01@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 = "9794" 
select * from cms_frontusers where identifiant = "h.dickx01" 
 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 = "9794" 
 select * from cotisations where identifiant = "h.dickx01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 111823
payment_means : VISA
transmission_date : 20151203101823
payment_time : 112000
payment_date : 20151203
response_code : 00
payment_certificate : 9922131648d0
authorisation_id : 371143
currency_code : 978
card_number : 4975.67
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.dickx01
order_id : 9794
customer_email : h.dickx01@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 = "9796" 
select * from cms_frontusers where identifiant = "f.gioria17" 
 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 = "9796" 
 select * from cotisations where identifiant = "f.gioria17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 112757
payment_means : VISA
transmission_date : 20151203102757
payment_time : 113024
payment_date : 20151203
response_code : 00
payment_certificate : ad394cc7707d
authorisation_id : 413918
currency_code : 978
card_number : 4976.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 : f.gioria17
order_id : 9796
customer_email : f.gioria17@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "9798" 
select * from cms_frontusers where identifiant = "n.henry16" 
 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 = "9798" 
 select * from cotisations where identifiant = "n.henry16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 114406
payment_means : VISA
transmission_date : 20151203104406
payment_time : 114632
payment_date : 20151203
response_code : 00
payment_certificate : 1c7256610fae
authorisation_id : 636170
currency_code : 978
card_number : 4150.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 : n.henry16
order_id : 9798
customer_email : n.henry16@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 = "9800" 
select * from cms_frontusers where identifiant = "h.barras23" 
 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 = "9800" 
 select * from cotisations where identifiant = "h.barras23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 115944
payment_means : VISA
transmission_date : 20151203105944
payment_time : 120201
payment_date : 20151203
response_code : 00
payment_certificate : 3897c3760e75
authorisation_id : 734290
currency_code : 978
card_number : 4970.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 : h.barras23
order_id : 9800
customer_email : h.barras23@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 : 201704
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9801" 
select * from cms_frontusers where identifiant = "p.venien26" 
 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 = "9801" 
 select * from cotisations where identifiant = "p.venien26" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 133825
payment_means : VISA
transmission_date : 20151203123825
payment_time : 134146
payment_date : 20151203
response_code : 00
payment_certificate : a296fe315e4f
authorisation_id : 640444
currency_code : 978
card_number : 4970.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.venien26
order_id : 9801
customer_email : p.venien26@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 : 201704
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9802" 
select * from cms_frontusers where identifiant = "jm.labeaune01" 
 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 = "9802" 
 select * from cotisations where identifiant = "jm.labeaune01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 143801
payment_means : MASTERCARD
transmission_date : 20151203133801
payment_time : 144634
payment_date : 20151203
response_code : 00
payment_certificate : 79c8e3c1b083
authorisation_id : 551329
currency_code : 978
card_number : 5137.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 : jm.labeaune01
order_id : 9802
customer_email : jm.labeaune01@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 = "9804" 
select * from cms_frontusers where identifiant = "m.guyader27" 
 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 = "9804" 
 select * from cotisations where identifiant = "m.guyader27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 151846
payment_means : VISA
transmission_date : 20151203141846
payment_time : 152012
payment_date : 20151203
response_code : 00
payment_certificate : bf5f3b6b04de
authorisation_id : 032133
currency_code : 978
card_number : 4978.49
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.guyader27
order_id : 9804
customer_email : m.guyader27@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 = "9805" 
select * from cms_frontusers where identifiant = "v.joly28" 
 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 = "9805" 
 select * from cotisations where identifiant = "v.joly28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 161826
payment_means : MASTERCARD
transmission_date : 20151203151826
payment_time : 161949
payment_date : 20151203
response_code : 00
payment_certificate : 42288835356d
authorisation_id : 564066
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 : v.joly28
order_id : 9805
customer_email : v.joly28@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9806" 
select * from cms_frontusers where identifiant = "j.berna16" 
 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 = "9806" 
 select * from cotisations where identifiant = "j.berna16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 162357
payment_means : VISA
transmission_date : 20151203152357
payment_time : 162600
payment_date : 20151203
response_code : 00
payment_certificate : edcf6cb328a7
authorisation_id : 171251
currency_code : 978
card_number : 4975.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 : j.berna16
order_id : 9806
customer_email : j.berna16@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 = "9807" 
select * from cms_frontusers where identifiant = "j.charles19" 
 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 = "9807" 
 select * from cotisations where identifiant = "j.charles19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 172216
payment_means : MASTERCARD
transmission_date : 20151203162216
payment_time : 172327
payment_date : 20151203
response_code : 00
payment_certificate : 8c5ddbc1d099
authorisation_id : 672545
currency_code : 978
card_number : 5131.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 : j.charles19
order_id : 9807
customer_email : j.charles19@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 = "9808" 
select * from cms_frontusers where identifiant = "jb.leroy17" 
 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 = "9808" 
 select * from cotisations where identifiant = "jb.leroy17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 173801
payment_means : VISA
transmission_date : 20151203163801
payment_time : 174015
payment_date : 20151203
response_code : 00
payment_certificate : 20acaf80dfd2
authorisation_id : 645952
currency_code : 978
card_number : 4561.35
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 : jb.leroy17
order_id : 9808
customer_email : jb.leroy17@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 : 201704
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9809" 
select * from cms_frontusers where identifiant = "l.grolier30" 
 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 = "9809" 
 select * from cotisations where identifiant = "l.grolier30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 174405
payment_means : MASTERCARD
transmission_date : 20151203164405
payment_time : 175102
payment_date : 20151203
response_code : 00
payment_certificate : 20940609fafd
authorisation_id : 146653
currency_code : 978
card_number : 5138.13
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.grolier30
order_id : 9809
customer_email : l.grolier30@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 = "9810" 
select * from cms_frontusers where identifiant = "jl.hybois23" 
 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 = "9810" 
 select * from cotisations where identifiant = "jl.hybois23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182220
payment_means : VISA
transmission_date : 20151203172220
payment_time : 182509
payment_date : 20151203
response_code : 00
payment_certificate : 47602c998c14
authorisation_id : 146471
currency_code : 978
card_number : 4972.23
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 : jl.hybois23
order_id : 9810
customer_email : jl.hybois23@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 = "9812" 
select * from cms_frontusers where identifiant = "s.groux27" 
 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 = "9812" 
 select * from cotisations where identifiant = "s.groux27" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "s.groux27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183053
payment_means : VISA
transmission_date : 20151203173053
payment_time : 183250
payment_date : 20151203
response_code : 00
payment_certificate : b31ace3fe314
authorisation_id : 242553
currency_code : 978
card_number : 4978.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 : s.groux27
order_id : 9812
customer_email : s.groux27@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 = "9811" 
select * from cms_frontusers where identifiant = "f.jezierski07" 
 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 = "9811" 
 select * from cotisations where identifiant = "f.jezierski07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183016
payment_means : VISA
transmission_date : 20151203173016
payment_time : 183309
payment_date : 20151203
response_code : 00
payment_certificate : 93e814f8dcee
authorisation_id : 186263
currency_code : 978
card_number : 4976.40
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.jezierski07
order_id : 9811
customer_email : f.jezierski07@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 = "9813" 
select * from cms_frontusers where identifiant = "a.doyharcabal28" 
 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 = "9813" 
 select * from cotisations where identifiant = "a.doyharcabal28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183542
payment_means : MASTERCARD
transmission_date : 20151203173542
payment_time : 183801
payment_date : 20151203
response_code : 00
payment_certificate : 89fb5c1a6106
authorisation_id : 614795
currency_code : 978
card_number : 5137.83
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.doyharcabal28
order_id : 9813
customer_email : a.doyharcabal28@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 = "9814" 
select * from cms_frontusers where identifiant = "jp.huart13" 
 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 = "9814" 
 select * from cotisations where identifiant = "jp.huart13" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 184722
payment_means : MASTERCARD
transmission_date : 20151203174722
payment_time : 184957
payment_date : 20151203
response_code : 00
payment_certificate : 8709fe3a2554
authorisation_id : 893953
currency_code : 978
card_number : 5132.06
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 : jp.huart13
order_id : 9814
customer_email : jp.huart13@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 = "9816" 
select * from cms_frontusers where identifiant = "a.bourgeois23" 
 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 = "9816" 
 select * from cotisations where identifiant = "a.bourgeois23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 200740
payment_means : VISA
transmission_date : 20151203190740
payment_time : 200937
payment_date : 20151203
response_code : 00
payment_certificate : 9e459aa1c4bc
authorisation_id : 205640
currency_code : 978
card_number : 4978.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.bourgeois23
order_id : 9816
customer_email : a.bourgeois23@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 = "9815" 
select * from cms_frontusers where identifiant = "a.chollet09" 
 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 = "9815" 
 select * from cotisations where identifiant = "d.mouradelort16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 200452
payment_means : VISA
transmission_date : 20151203190452
payment_time : 201335
payment_date : 20151203
response_code : 00
payment_certificate : e394031daa96
authorisation_id : 007185
currency_code : 978
card_number : 4659.45
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.chollet09
order_id : 9815
customer_email : a.chollet09@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "9817" 
select * from cms_frontusers where identifiant = "v.giraudet01" 
 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 = "9817" 
 select * from cotisations where identifiant = "v.giraudet01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 201232
payment_means : VISA
transmission_date : 20151203191232
payment_time : 201448
payment_date : 20151203
response_code : 00
payment_certificate : 9f3af169d66b
authorisation_id : 510565
currency_code : 978
card_number : 4972.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 : v.giraudet01
order_id : 9817
customer_email : v.giraudet01@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 = "9818" 
select * from cms_frontusers where identifiant = "a.poncin31" 
 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 = "9818" 
 select * from cotisations where identifiant = "a.poncin31" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201423
payment_means : VISA
transmission_date : 20151203191423
payment_time : 201734
payment_date : 20151203
response_code : 00
payment_certificate : 16c91c29c8be
authorisation_id : 553154
currency_code : 978
card_number : 4970.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 : a.poncin31
order_id : 9818
customer_email : a.poncin31@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 = "9820" 
select * from cms_frontusers where identifiant = "g.dumez15" 
 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 = "9820" 
 select * from cotisations where identifiant = "g.dumez15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 202240
payment_means : VISA
transmission_date : 20151203192240
payment_time : 202353
payment_date : 20151203
response_code : 00
payment_certificate : 6072296ef9bf
authorisation_id : 628019
currency_code : 978
card_number : 4978.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 : g.dumez15
order_id : 9820
customer_email : g.dumez15@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 = "9821" 
select * from cms_frontusers where identifiant = "f.scossabaggi30" 
 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 = "9821" 
 select * from cotisations where identifiant = "f.scossabaggi30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 203922
payment_means : MASTERCARD
transmission_date : 20151203193922
payment_time : 204021
payment_date : 20151203
response_code : 00
payment_certificate : 31dcc36c2872
authorisation_id : 144462
currency_code : 978
card_number : 5131.81
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.scossabaggi30
order_id : 9821
customer_email : f.scossabaggi30@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 204124
payment_means : MASTERCARD
transmission_date : 20151203194124
payment_time : 204233
payment_date : 20151203
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.07
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 : f.ovide19
order_id : 9822
customer_email : f.ovide19@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 : 201810
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 : 205120
payment_means : VISA
transmission_date : 20151203195120
payment_time : 210054
payment_date : 20151203
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.95
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 : a.laugier22
order_id : 9824
customer_email : a.laugier22@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 : 201703
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9824" 
select * from cms_frontusers where identifiant = "a.laugier22" 
 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 = "9824" 
 select * from cotisations where identifiant = "a.laugier22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 210123
payment_means : VISA
transmission_date : 20151203200123
payment_time : 210335
payment_date : 20151203
response_code : 00
payment_certificate : ed39c8658bbd
authorisation_id : 636114
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 : a.laugier22
order_id : 9824
customer_email : a.laugier22@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 = "9825" 
select * from cms_frontusers where identifiant = "f.royer01" 
 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 = "9825" 
 select * from cotisations where identifiant = "f.royer01" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 210225
payment_means : VISA
transmission_date : 20151203200225
payment_time : 210340
payment_date : 20151203
response_code : 00
payment_certificate : 7ded14078339
authorisation_id : 094340
currency_code : 978
card_number : 4539.00
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.royer01
order_id : 9825
customer_email : f.royer01@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 = "9827" 
select * from cms_frontusers where identifiant = "j.dardillac20" 
 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 = "9827" 
 select * from cotisations where identifiant = "j.dardillac20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211917
payment_means : VISA
transmission_date : 20151203201917
payment_time : 212212
payment_date : 20151203
response_code : 00
payment_certificate : 0f6fee7f964a
authorisation_id : 468505
currency_code : 978
card_number : 4978.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 : j.dardillac20
order_id : 9827
customer_email : j.dardillac20@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212831
payment_means : MASTERCARD
transmission_date : 20151203202831
payment_time : 212943
payment_date : 20151203
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5341.01
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 : j.campello15
order_id : 9828
customer_email : j.campello15@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 : 201609
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "9830" 
select * from cms_frontusers where identifiant = "c.nowecki02" 
 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 = "9830" 
 select * from cotisations where identifiant = "c.nowecki02" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 213143
payment_means : VISA
transmission_date : 20151203203143
payment_time : 213238
payment_date : 20151203
response_code : 00
payment_certificate : ec70f3c30f82
authorisation_id : 003124
currency_code : 978
card_number : 4762.16
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.nowecki02
order_id : 9830
customer_email : c.nowecki02@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212858
payment_means : MASTERCARD
transmission_date : 20151203202858
payment_time : 213514
payment_date : 20151203
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5138.13
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 : q.poirier28
order_id : 9829
customer_email : q.poirier28@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 = "9832" 
select * from cms_frontusers where identifiant = "jb.daheron11" 
 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 = "9832" 
 select * from cotisations where identifiant = "jb.daheron11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 215040
payment_means : VISA
transmission_date : 20151203205040
payment_time : 215155
payment_date : 20151203
response_code : 00
payment_certificate : d144d8fc6d0a
authorisation_id : 115279
currency_code : 978
card_number : 4533.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 : jb.daheron11
order_id : 9832
customer_email : jb.daheron11@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 = "9831" 
select * from cms_frontusers where identifiant = "p.besson19" 
 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 = "9831" 
 select * from cotisations where identifiant = "p.besson19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 214852
payment_means : VISA
transmission_date : 20151203204852
payment_time : 215212
payment_date : 20151203
response_code : 00
payment_certificate : 215ea8ffbbb2
authorisation_id : 965426
currency_code : 978
card_number : 4970.21
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.besson19
order_id : 9831
customer_email : p.besson19@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 = "9833" 
select * from cms_frontusers where identifiant = "g.divry18" 
 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 = "9833" 
 select * from cotisations where identifiant = "g.divry18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221119
payment_means : MASTERCARD
transmission_date : 20151203211119
payment_time : 221626
payment_date : 20151203
response_code : 00
payment_certificate : 32c1f03b72c1
authorisation_id : 442825
currency_code : 978
card_number : 5132.58
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.divry18
order_id : 9833
customer_email : g.divry18@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 = "9836" 
select * from cms_frontusers where identifiant = "c.anceau15" 
 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 = "9836" 
 select * from cotisations where identifiant = "c.anceau15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 225709
payment_means : VISA
transmission_date : 20151203215709
payment_time : 225913
payment_date : 20151203
response_code : 00
payment_certificate : f49d9cacc322
authorisation_id : 272800
currency_code : 978
card_number : 4974.48
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.anceau15
order_id : 9836
customer_email : c.anceau15@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 : 
-------------------------------------------