Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 094549
payment_means : VISA
transmission_date : 20160224084549
payment_time : 095231
payment_date : 20160224
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4974.24
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 : g.bueb03
order_id : 14128
customer_email : g.bueb03@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 = "14129" 
select * from cms_frontusers where identifiant = "r.couet28" 
 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 = "14129" 
 select * from cotisations where identifiant = "r.couet28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104202
payment_means : VISA
transmission_date : 20160224094202
payment_time : 104325
payment_date : 20160224
response_code : 00
payment_certificate : 929ab61dea0e
authorisation_id : 894962
currency_code : 978
card_number : 4499.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 : r.couet28
order_id : 14129
customer_email : r.couet28@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 : 201610
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14130" 
select * from cms_frontusers where identifiant = "c.couet14" 
 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 = "14130" 
 select * from cotisations where identifiant = "c.couet14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 105010
payment_means : VISA
transmission_date : 20160224095010
payment_time : 105108
payment_date : 20160224
response_code : 00
payment_certificate : aff542f36f3a
authorisation_id : 485521
currency_code : 978
card_number : 4499.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 : c.couet14
order_id : 14130
customer_email : c.couet14@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 : 201610
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 : 105440
payment_means : MASTERCARD
transmission_date : 20160224095440
payment_time : 110019
payment_date : 20160224
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.88
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 : k.courand18
order_id : 14131
customer_email : k.courand18@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 : 201806
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14133" 
select * from cms_frontusers where identifiant = "j.grasser10" 
 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 = "14133" 
 select * from cotisations where identifiant = "j.grasser10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 131256
payment_means : MASTERCARD
transmission_date : 20160224121256
payment_time : 131718
payment_date : 20160224
response_code : 00
payment_certificate : 5088e5890b8a
authorisation_id : 366201
currency_code : 978
card_number : 5136.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 : j.grasser10
order_id : 14133
customer_email : j.grasser10@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 = "14134" 
select * from cms_frontusers where identifiant = "b.lacroix31" 
 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 = "14134" 
 select * from cotisations where identifiant = "b.lacroix31" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153441
payment_means : MASTERCARD
transmission_date : 20160224143441
payment_time : 153545
payment_date : 20160224
response_code : 00
payment_certificate : 4e3d79f37f47
authorisation_id : 417763
currency_code : 978
card_number : 5138.07
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.lacroix31
order_id : 14134
customer_email : b.lacroix31@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 = "14135" 
select * from cms_frontusers where identifiant = "j.lipreau07" 
 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 = "14135" 
 select * from cotisations where identifiant = "j.lipreau07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 160125
payment_means : MASTERCARD
transmission_date : 20160224150125
payment_time : 160316
payment_date : 20160224
response_code : 00
payment_certificate : d3b60e34a386
authorisation_id : 486371
currency_code : 978
card_number : 5136.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 : j.lipreau07
order_id : 14135
customer_email : j.lipreau07@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 = "14137" 
select * from cms_frontusers where identifiant = "r.dutertre16" 
 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 = "14137" 
 select * from cotisations where identifiant = "r.dutertre16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 165201
payment_means : MASTERCARD
transmission_date : 20160224155201
payment_time : 165622
payment_date : 20160224
response_code : 00
payment_certificate : a0aac23ac6be
authorisation_id : 552814
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 : r.dutertre16
order_id : 14137
customer_email : r.dutertre16@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 : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "14138" 
select * from cms_frontusers where identifiant = "c.lesne05" 
 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 = "14138" 
 select * from cotisations where identifiant = "c.lesne05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 172957
payment_means : MASTERCARD
transmission_date : 20160224162957
payment_time : 173158
payment_date : 20160224
response_code : 00
payment_certificate : 675f0ff91cea
authorisation_id : 024112
currency_code : 978
card_number : 5131.37
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.lesne05
order_id : 14138
customer_email : c.lesne05@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 = "14139" 
select * from cms_frontusers where identifiant = "p.ouvrard06" 
 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 = "14139" 
 select * from cotisations where identifiant = "k.courand18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 181926
payment_means : VISA
transmission_date : 20160224171926
payment_time : 182203
payment_date : 20160224
response_code : 00
payment_certificate : a9bf75db7781
authorisation_id : 667597
currency_code : 978
card_number : 4974.46
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.ouvrard06
order_id : 14139
customer_email : p.ouvrard06@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 = "14140" 
select * from cms_frontusers where identifiant = "g.bueb03" 
 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 = "14140" 
 select * from cotisations where identifiant = "g.bueb03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 182916
payment_means : VISA
transmission_date : 20160224172916
payment_time : 183041
payment_date : 20160224
response_code : 00
payment_certificate : cf34237471f4
authorisation_id : 122211
currency_code : 978
card_number : 4974.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 : g.bueb03
order_id : 14140
customer_email : g.bueb03@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 = "14142" 
select * from cms_frontusers where identifiant = "a.cougnacq28" 
 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 = "14142" 
 select * from cotisations where identifiant = "a.cougnacq28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201555
payment_means : MASTERCARD
transmission_date : 20160224191555
payment_time : 201741
payment_date : 20160224
response_code : 00
payment_certificate : d953a21b0084
authorisation_id : 487150
currency_code : 978
card_number : 5138.42
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.cougnacq28
order_id : 14142
customer_email : a.cougnacq28@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201618
payment_means : VISA
transmission_date : 20160224191618
payment_time : 201811
payment_date : 20160224
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.80
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 51
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.caperan11
order_id : 14144
customer_email : a.caperan11@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 = "14143" 
select * from cms_frontusers where identifiant = "g.couturou16" 
 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 = "14143" 
 select * from cotisations where identifiant = "g.couturou16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201607
payment_means : VISA
transmission_date : 20160224191607
payment_time : 201825
payment_date : 20160224
response_code : 00
payment_certificate : ea78a927975b
authorisation_id : 343849
currency_code : 978
card_number : 4973.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 : g.couturou16
order_id : 14143
customer_email : g.couturou16@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 = "14145" 
select * from cms_frontusers where identifiant = "r.ravet13" 
 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 = "14145" 
 select * from cotisations where identifiant = "r.ravet13" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "r.ravet13" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 201722
payment_means : VISA
transmission_date : 20160224191722
payment_time : 201828
payment_date : 20160224
response_code : 00
payment_certificate : 9e95ff5d1a68
authorisation_id : 212205
currency_code : 978
card_number : 4971.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 : r.ravet13
order_id : 14145
customer_email : r.ravet13@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 = "14148" 
select * from cms_frontusers where identifiant = "c.pechour19" 
 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 = "14148" 
 select * from cotisations where identifiant = "c.pechour19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211306
payment_means : VISA
transmission_date : 20160224201306
payment_time : 211535
payment_date : 20160224
response_code : 00
payment_certificate : e86074d124f4
authorisation_id : 446486
currency_code : 978
card_number : 4978.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 : c.pechour19
order_id : 14148
customer_email : c.pechour19@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 = "14149" 
select * from cms_frontusers where identifiant = "b.filali29" 
 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 = "14149" 
 select * from cotisations where identifiant = "b.filali29" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 212302
payment_means : VISA
transmission_date : 20160224202302
payment_time : 212429
payment_date : 20160224
response_code : 00
payment_certificate : 76dfa7550156
authorisation_id : 265366
currency_code : 978
card_number : 4970.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 : b.filali29
order_id : 14149
customer_email : b.filali29@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 = "14152" 
select * from cms_frontusers where identifiant = "g.brulon21" 
 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 = "14152" 
 select * from cotisations where identifiant = "g.brulon21" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 215455
payment_means : VISA
transmission_date : 20160224205455
payment_time : 215640
payment_date : 20160224
response_code : 00
payment_certificate : c5ea0521a295
authorisation_id : 259717
currency_code : 978
card_number : 4970.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 : g.brulon21
order_id : 14152
customer_email : g.brulon21@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 = "14153" 
select * from cms_frontusers where identifiant = "m.spellat26" 
 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 = "14153" 
 select * from cotisations where identifiant = "j.divoux22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 215926
payment_means : VISA
transmission_date : 20160224205926
payment_time : 220323
payment_date : 20160224
response_code : 00
payment_certificate : 5a5ea7e6a9d1
authorisation_id : 659568
currency_code : 978
card_number : 4970.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.spellat26
order_id : 14153
customer_email : m.spellat26@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 = "14154" 
select * from cms_frontusers where identifiant = "l.turgne14" 
 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 = "14154" 
 select * from cotisations where identifiant = "l.turgne14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 224415
payment_means : MASTERCARD
transmission_date : 20160224214415
payment_time : 224613
payment_date : 20160224
response_code : 00
payment_certificate : dc385dd34d50
authorisation_id : 414265
currency_code : 978
card_number : 5131.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 : l.turgne14
order_id : 14154
customer_email : l.turgne14@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 : 
-------------------------------------------