select * from cotisations_commande where id = "22563" 
select * from cms_frontusers where identifiant = "f.bureau27" 
 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 = "22563" 
 select * from cotisations where identifiant = "v.jolit19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104022
payment_means : VISA
transmission_date : 20170414084022
payment_time : 104220
payment_date : 20170414
response_code : 00
payment_certificate : 50a29ea7f554
authorisation_id : 255733
currency_code : 978
card_number : 4970.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 : f.bureau27
order_id : 22563
customer_email : f.bureau27@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 = "22564" 
select * from cms_frontusers where identifiant = "d.martin06" 
 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 = "22564" 
 select * from cotisations where identifiant = "d.martin06" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 111446
payment_means : VISA
transmission_date : 20170414091446
payment_time : 111606
payment_date : 20170414
response_code : 00
payment_certificate : e4b9b88a34a3
authorisation_id : 921522
currency_code : 978
card_number : 4561.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 : d.martin06
order_id : 22564
customer_email : d.martin06@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 : 202002
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22565" 
select * from cms_frontusers where identifiant = "l.sbrava12" 
 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 = "22565" 
 select * from cotisations where identifiant = "l.lacroux29" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 142614
payment_means : VISA
transmission_date : 20170414122614
payment_time : 142724
payment_date : 20170414
response_code : 00
payment_certificate : db272cd3d99d
authorisation_id : 567333
currency_code : 978
card_number : 4970.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 : l.sbrava12
order_id : 22565
customer_email : l.sbrava12@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 = "22566" 
select * from cms_frontusers where identifiant = "r.fournel19" 
 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 = "22566" 
 select * from cotisations where identifiant = "p.musy28" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 174433
payment_means : VISA
transmission_date : 20170414154433
payment_time : 174619
payment_date : 20170414
response_code : 00
payment_certificate : 84b610fd2951
authorisation_id : 535113
currency_code : 978
card_number : 4978.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 : r.fournel19
order_id : 22566
customer_email : r.fournel19@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 : 202002
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22567" 
select * from cms_frontusers where identifiant = "n.massas03" 
 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 = "22567" 
 select * from cotisations where identifiant = "n.massas03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181505
payment_means : MASTERCARD
transmission_date : 20170414161505
payment_time : 182107
payment_date : 20170414
response_code : 00
payment_certificate : 9652fbf33205
authorisation_id : 374092
currency_code : 978
card_number : 5137.75
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : n.massas03
order_id : 22567
customer_email : n.massas03@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 : 202001
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "22568" 
select * from cms_frontusers where identifiant = "m.fidalgo31" 
 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 = "22568" 
 select * from cotisations where identifiant = "m.fidalgo31" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 195302
payment_means : MASTERCARD
transmission_date : 20170414175302
payment_time : 195707
payment_date : 20170414
response_code : 00
payment_certificate : f58b15559c31
authorisation_id : 943317
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 : m.fidalgo31
order_id : 22568
customer_email : m.fidalgo31@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 = "22569" 
select * from cms_frontusers where identifiant = "l.bardy26" 
 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 = "22569" 
 select * from cotisations where identifiant = "l.bardy26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 203157
payment_means : MASTERCARD
transmission_date : 20170414183157
payment_time : 203323
payment_date : 20170414
response_code : 00
payment_certificate : b9f9e075b477
authorisation_id : 704040
currency_code : 978
card_number : 5573.96
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.bardy26
order_id : 22569
customer_email : l.bardy26@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 : 
-------------------------------------------