select * from cotisations_commande where id = "14072" 
select * from cms_frontusers where identifiant = "b.seres21" 
 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 = "14072" 
 select * from cotisations where identifiant = "a.chaignon17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 075538
payment_means : MASTERCARD
transmission_date : 20160221065538
payment_time : 075723
payment_date : 20160221
response_code : 00
payment_certificate : b791e06f21f5
authorisation_id : 014660
currency_code : 978
card_number : 5137.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 : b.seres21
order_id : 14072
customer_email : b.seres21@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 = "14073" 
select * from cms_frontusers where identifiant = "b.seres21" 
 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 = "14073" 
 select * from cotisations where identifiant = "a.lopezmoscoso09" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 075833
payment_means : MASTERCARD
transmission_date : 20160221065833
payment_time : 075939
payment_date : 20160221
response_code : 00
payment_certificate : ca8fd0c83dff
authorisation_id : 254405
currency_code : 978
card_number : 5137.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 : b.seres21
order_id : 14073
customer_email : b.seres21@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 = "14074" 
select * from cms_frontusers where identifiant = "c.bourgeois09" 
 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 = "14074" 
 select * from cotisations where identifiant = "c.bourgeois09" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 092500
payment_means : VISA
transmission_date : 20160221082500
payment_time : 092632
payment_date : 20160221
response_code : 00
payment_certificate : e08cdf82abb9
authorisation_id : 825342
currency_code : 978
card_number : 4970.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 : c.bourgeois09
order_id : 14074
customer_email : c.bourgeois09@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 = "14075" 
select * from cms_frontusers where identifiant = "b.combernoux22" 
 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 = "14075" 
 select * from cotisations where identifiant = "b.combernoux22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 112431
payment_means : VISA
transmission_date : 20160221102431
payment_time : 112603
payment_date : 20160221
response_code : 00
payment_certificate : 1edc52e49ee5
authorisation_id : 129241
currency_code : 978
card_number : 4533.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 : b.combernoux22
order_id : 14075
customer_email : b.combernoux22@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201801
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14077" 
select * from cms_frontusers where identifiant = "t.duverger16" 
 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 = "14077" 
 select * from cotisations where identifiant = "t.duverger16" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "t.duverger16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 121405
payment_means : MASTERCARD
transmission_date : 20160221111405
payment_time : 121701
payment_date : 20160221
response_code : 00
payment_certificate : 5cf10add19b2
authorisation_id : 333047
currency_code : 978
card_number : 5131.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 : t.duverger16
order_id : 14077
customer_email : t.duverger16@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 = "14078" 
select * from cms_frontusers where identifiant = "l.penna14" 
 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 = "14078" 
 select * from cotisations where identifiant = "l.penna14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 131614
payment_means : VISA
transmission_date : 20160221121614
payment_time : 131824
payment_date : 20160221
response_code : 00
payment_certificate : c5665258f065
authorisation_id : 346104
currency_code : 978
card_number : 4974.02
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.penna14
order_id : 14078
customer_email : l.penna14@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 : 201808
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14079" 
select * from cms_frontusers where identifiant = "l.claparede14" 
 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 = "14079" 
 select * from cotisations where identifiant = "l.claparede14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 154839
payment_means : VISA
transmission_date : 20160221144839
payment_time : 155010
payment_date : 20160221
response_code : 00
payment_certificate : 9bced098c3ea
authorisation_id : 377124
currency_code : 978
card_number : 4972.43
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.claparede14
order_id : 14079
customer_email : l.claparede14@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 = "14080" 
select * from cms_frontusers where identifiant = "j.huard12" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "14080" 
 select * from cotisations where identifiant = "b.dabin22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 163132
payment_means : MASTERCARD
transmission_date : 20160221153132
payment_time : 163408
payment_date : 20160221
response_code : 00
payment_certificate : f51c28e671cc
authorisation_id : 661459
currency_code : 978
card_number : 5131.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 : j.huard12
order_id : 14080
customer_email : j.huard12@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14081" 
select * from cms_frontusers where identifiant = "x.braillon11" 
 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 = "14081" 
 select * from cotisations where identifiant = "x.braillon11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 185136
payment_means : VISA
transmission_date : 20160221175136
payment_time : 185324
payment_date : 20160221
response_code : 00
payment_certificate : bd2621ef5dd8
authorisation_id : 114523
currency_code : 978
card_number : 4970.20
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 : x.braillon11
order_id : 14081
customer_email : x.braillon11@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 = "14082" 
select * from cms_frontusers where identifiant = "a.perrier28" 
 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 = "14082" 
 select * from cotisations where identifiant = "a.perrier28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211531
payment_means : MASTERCARD
transmission_date : 20160221201531
payment_time : 211746
payment_date : 20160221
response_code : 00
payment_certificate : a87a187ce71d
authorisation_id : 344364
currency_code : 978
card_number : 5132.59
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.perrier28
order_id : 14082
customer_email : a.perrier28@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 : 
-------------------------------------------