select * from cotisations_commande where id = "21822" 
select * from cms_frontusers where identifiant = "l.fave03" 
 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 = "21822" 
 select * from cotisations where identifiant = "l.fave03" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 070458
payment_means : VISA
transmission_date : 20170214060458
payment_time : 070624
payment_date : 20170214
response_code : 00
payment_certificate : b1f931cfb156
authorisation_id : 338281
currency_code : 978
card_number : 4978.01
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.fave03
order_id : 21822
customer_email : l.fave03@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 081635
payment_means : VISA
transmission_date : 20170214071635
payment_time : 081809
payment_date : 20170214
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.78
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.chazot03
order_id : 21823
customer_email : f.chazot03@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 = "21824" 
select * from cms_frontusers where identifiant = "m.desantis22" 
 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 = "21824" 
 select * from cotisations where identifiant = "m.desantis22" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 092219
payment_means : MASTERCARD
transmission_date : 20170214082219
payment_time : 092409
payment_date : 20170214
response_code : 00
payment_certificate : b0350685fe4f
authorisation_id : 212113
currency_code : 978
card_number : 5131.26
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.desantis22
order_id : 21824
customer_email : m.desantis22@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 : 201912
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21825" 
select * from cms_frontusers where identifiant = "c.lefeunteun04" 
 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 = "21825" 
 select * from cotisations where identifiant = "c.lefeunteun04" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 092554
payment_means : MASTERCARD
transmission_date : 20170214082554
payment_time : 092704
payment_date : 20170214
response_code : 00
payment_certificate : 48f7a34e629d
authorisation_id : 665182
currency_code : 978
card_number : 5137.31
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.lefeunteun04
order_id : 21825
customer_email : c.lefeunteun04@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 = "21826" 
select * from cms_frontusers where identifiant = "d.loizeau18" 
 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 = "21826" 
 select * from cotisations where identifiant = "d.loizeau18" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "d.loizeau18" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 095759
payment_means : VISA
transmission_date : 20170214085759
payment_time : 100035
payment_date : 20170214
response_code : 00
payment_certificate : 28a220e391bf
authorisation_id : 587542
currency_code : 978
card_number : 4971.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 : d.loizeau18
order_id : 21826
customer_email : d.loizeau18@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 : 201812
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21827" 
select * from cms_frontusers where identifiant = "a.bonnaterre07" 
 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 = "21827" 
 select * from cotisations where identifiant = "a.bonnaterre07" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 102639
payment_means : VISA
transmission_date : 20170214092639
payment_time : 102846
payment_date : 20170214
response_code : 00
payment_certificate : 010af4b64bc2
authorisation_id : 209239
currency_code : 978
card_number : 4971.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 : a.bonnaterre07
order_id : 21827
customer_email : a.bonnaterre07@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 = "21828" 
select * from cms_frontusers where identifiant = "y.mathias15" 
 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 = "21828" 
 select * from cotisations where identifiant = "y.mathias15" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 130431
payment_means : VISA
transmission_date : 20170214120431
payment_time : 130535
payment_date : 20170214
response_code : 00
payment_certificate : eb6a1454215b
authorisation_id : 392731
currency_code : 978
card_number : 4533.77
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.mathias15
order_id : 21828
customer_email : y.mathias15@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 = "21829" 
select * from cms_frontusers where identifiant = "j.bazantay22" 
 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 = "21829" 
 select * from cotisations where identifiant = "j.bazantay22" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "j.bazantay22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 140258
payment_means : VISA
transmission_date : 20170214130258
payment_time : 140510
payment_date : 20170214
response_code : 00
payment_certificate : 39b1c7844f21
authorisation_id : 155217
currency_code : 978
card_number : 4976.89
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.bazantay22
order_id : 21829
customer_email : j.bazantay22@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 : 153105
payment_means : VISA
transmission_date : 20170214143105
payment_time : 153643
payment_date : 20170214
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4979.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.froidevaux11
order_id : 21830
customer_email : m.froidevaux11@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21831" 
select * from cms_frontusers where identifiant = "l.ogez09" 
 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 = "21831" 
 select * from cotisations where identifiant = "l.ogez09" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 174046
payment_means : VISA
transmission_date : 20170214164046
payment_time : 174217
payment_date : 20170214
response_code : 00
payment_certificate : 1ec2a2bdf786
authorisation_id : 607234
currency_code : 978
card_number : 4978.32
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : l.ogez09
order_id : 21831
customer_email : l.ogez09@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 : 201912
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21832" 
select * from cms_frontusers where identifiant = "d.pitois02" 
 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 = "21832" 
 select * from cotisations where identifiant = "d.pitois02" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 185219
payment_means : MASTERCARD
transmission_date : 20170214175219
payment_time : 185356
payment_date : 20170214
response_code : 00
payment_certificate : dc14812237b3
authorisation_id : 416112
currency_code : 978
card_number : 5131.22
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.pitois02
order_id : 21832
customer_email : d.pitois02@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 : 201909
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 : 185309
payment_means : VISA
transmission_date : 20170214175309
payment_time : 185530
payment_date : 20170214
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4974.56
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 : e.abraham03
order_id : 21833
customer_email : e.abraham03@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201708
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21833" 
select * from cms_frontusers where identifiant = "e.abraham03" 
 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 = "21833" 
 select * from cotisations where identifiant = "v.abraham11" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 190035
payment_means : VISA
transmission_date : 20170214180035
payment_time : 190228
payment_date : 20170214
response_code : 00
payment_certificate : 52c3d7f28be4
authorisation_id : 243414
currency_code : 978
card_number : 4974.56
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.abraham03
order_id : 21833
customer_email : e.abraham03@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 : 201908
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 : 192245
payment_means : VISA
transmission_date : 20170214182245
payment_time : 192444
payment_date : 20170214
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4974.12
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 59
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.vivier16
order_id : 21834
customer_email : a.vivier16@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 : 4000
transaction_id : 192519
payment_means : VISA
transmission_date : 20170214182519
payment_time : 192614
payment_date : 20170214
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4974.12
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.vivier16
order_id : 21835
customer_email : a.vivier16@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "21836" 
select * from cms_frontusers where identifiant = "a.vivier16" 
 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 = "21836" 
 select * from cotisations where identifiant = "a.vivier16" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 192800
payment_means : VISA
transmission_date : 20170214182800
payment_time : 192902
payment_date : 20170214
response_code : 00
payment_certificate : 87b3f6e92a9f
authorisation_id : 643612
currency_code : 978
card_number : 4974.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 : a.vivier16
order_id : 21836
customer_email : a.vivier16@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 : 201906
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21837" 
select * from cms_frontusers where identifiant = "v.corion23" 
 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 = "21837" 
 select * from cotisations where identifiant = "v.corion23" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 195346
payment_means : MASTERCARD
transmission_date : 20170214185346
payment_time : 195833
payment_date : 20170214
response_code : 00
payment_certificate : 23e5499fb22e
authorisation_id : 476161
currency_code : 978
card_number : 5132.85
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.corion23
order_id : 21837
customer_email : v.corion23@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 = "21838" 
select * from cms_frontusers where identifiant = "b.turcot05" 
 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 = "21838" 
 select * from cotisations where identifiant = "b.turcot05" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 203311
payment_means : MASTERCARD
transmission_date : 20170214193311
payment_time : 203620
payment_date : 20170214
response_code : 00
payment_certificate : 52b67e4dea9a
authorisation_id : 950623
currency_code : 978
card_number : 5131.78
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : b.turcot05
order_id : 21838
customer_email : b.turcot05@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 = "21839" 
select * from cms_frontusers where identifiant = "m.froidevaux11" 
 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 = "21839" 
 select * from cotisations where identifiant = "m.froidevaux11" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211400
payment_means : VISA
transmission_date : 20170214201400
payment_time : 211545
payment_date : 20170214
response_code : 00
payment_certificate : 01adcf1baa01
authorisation_id : 054926
currency_code : 978
card_number : 4972.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 : m.froidevaux11
order_id : 21839
customer_email : m.froidevaux11@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 = "21840" 
select * from cms_frontusers where identifiant = "q.morice03" 
 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 = "21840" 
 select * from cotisations where identifiant = "q.morice03" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221945
payment_means : MASTERCARD
transmission_date : 20170214211945
payment_time : 222112
payment_date : 20170214
response_code : 00
payment_certificate : a2c54c4257a6
authorisation_id : 354500
currency_code : 978
card_number : 5132.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 : q.morice03
order_id : 21840
customer_email : q.morice03@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 = "21842" 
select * from cms_frontusers where identifiant = "f.gaillard18" 
 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 = "21842" 
 select * from cotisations where identifiant = "f.gaillard18" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "f.gaillard18" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 231319
payment_means : MASTERCARD
transmission_date : 20170214221319
payment_time : 231550
payment_date : 20170214
response_code : 00
payment_certificate : de3c3ecef508
authorisation_id : 220711
currency_code : 978
card_number : 5817.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.gaillard18
order_id : 21842
customer_email : f.gaillard18@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 = "21843" 
select * from cms_frontusers where identifiant = "p.weyten24" 
 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 = "21843" 
 select * from cotisations where identifiant = "p.weyten24" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 233836
payment_means : VISA
transmission_date : 20170214223836
payment_time : 234240
payment_date : 20170214
response_code : 00
payment_certificate : d2b1b425ca00
authorisation_id : 184663
currency_code : 978
card_number : 4978.17
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : p.weyten24
order_id : 21843
customer_email : p.weyten24@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 : 201903
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21844" 
select * from cms_frontusers where identifiant = "m.diana14" 
 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 = "21844" 
 select * from cotisations where identifiant = "m.diana14" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 234347
payment_means : VISA
transmission_date : 20170214224347
payment_time : 234451
payment_date : 20170214
response_code : 00
payment_certificate : 092719c28d0f
authorisation_id : 169187
currency_code : 978
card_number : 4978.17
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.diana14
order_id : 21844
customer_email : m.diana14@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 : 201903
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------