select * from cotisations_commande where id = "21860" 
select * from cms_frontusers where identifiant = "m.gaurin13" 
 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 = "21860" 
 select * from cotisations where identifiant = "m.gaurin13" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 114032
payment_means : VISA
transmission_date : 20170216104032
payment_time : 114407
payment_date : 20170216
response_code : 00
payment_certificate : ca9ad905e2c5
authorisation_id : 226692
currency_code : 978
card_number : 4977.18
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.gaurin13
order_id : 21860
customer_email : m.gaurin13@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 = "21861" 
select * from cms_frontusers where identifiant = "j.dasneves09" 
 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 = "21861" 
 select * from cotisations where identifiant = "j.dasneves09" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 115714
payment_means : MASTERCARD
transmission_date : 20170216105714
payment_time : 115947
payment_date : 20170216
response_code : 00
payment_certificate : 04917c902335
authorisation_id : 609434
currency_code : 978
card_number : 5137.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 : j.dasneves09
order_id : 21861
customer_email : j.dasneves09@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 = "21864" 
select * from cms_frontusers where identifiant = "j.daems04" 
 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 = "21864" 
 select * from cotisations where identifiant = "j.daems04" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 194157
payment_means : VISA
transmission_date : 20170216184157
payment_time : 194327
payment_date : 20170216
response_code : 00
payment_certificate : 18c3e31ca305
authorisation_id : 211409
currency_code : 978
card_number : 4978.87
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : j.daems04
order_id : 21864
customer_email : j.daems04@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 = "21865" 
select * from cms_frontusers where identifiant = "d.hauss27" 
 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 = "21865" 
 select * from cotisations where identifiant = "d.hauss27" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 195030
payment_means : VISA
transmission_date : 20170216185030
payment_time : 195223
payment_date : 20170216
response_code : 00
payment_certificate : 12e830f10e42
authorisation_id : 554153
currency_code : 978
card_number : 4972.45
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : d.hauss27
order_id : 21865
customer_email : d.hauss27@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 = "21866" 
select * from cms_frontusers where identifiant = "m.groleau10" 
 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 = "21866" 
 select * from cotisations where identifiant = "m.groleau10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211202
payment_means : MASTERCARD
transmission_date : 20170216201202
payment_time : 211448
payment_date : 20170216
response_code : 00
payment_certificate : bd9c02eb299c
authorisation_id : 934682
currency_code : 978
card_number : 5132.12
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.groleau10
order_id : 21866
customer_email : m.groleau10@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201804
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21867" 
select * from cms_frontusers where identifiant = "d.vonin28" 
 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 = "21867" 
 select * from cotisations where identifiant = "n.lesage20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 215618
payment_means : VISA
transmission_date : 20170216205618
payment_time : 215923
payment_date : 20170216
response_code : 00
payment_certificate : ec49fa1017b9
authorisation_id : 364784
currency_code : 978
card_number : 4973.43
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : d.vonin28
order_id : 21867
customer_email : d.vonin28@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 = "21868" 
select * from cms_frontusers where identifiant = "d.vonin28" 
 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 = "21868" 
 select * from cotisations where identifiant = "n.lesage20" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 220136
payment_means : VISA
transmission_date : 20170216210136
payment_time : 220417
payment_date : 20170216
response_code : 00
payment_certificate : 4f0064887dfc
authorisation_id : 265423
currency_code : 978
card_number : 4973.43
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : d.vonin28
order_id : 21868
customer_email : d.vonin28@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 : 
-------------------------------------------