select * from cotisations_commande where id = "5779" 
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 = "5779" 
 select * from cotisations where identifiant = "b.debouck20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 082006
payment_means : VISA
transmission_date : 20150125072006
payment_time : 082814
payment_date : 20150125
response_code : 00
payment_certificate : da37bcad6c50
authorisation_id : 385594
currency_code : 978
card_number : 4970.64
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 : 5779
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 : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5780" 
select * from cms_frontusers where identifiant = "g.collin25" 
 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 = "5780" 
 select * from cotisations where identifiant = "j.navail02" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 083744
payment_means : MASTERCARD
transmission_date : 20150125073744
payment_time : 083908
payment_date : 20150125
response_code : 00
payment_certificate : 8a19cd06309e
authorisation_id : 326125
currency_code : 978
card_number : 5131.79
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.collin25
order_id : 5780
customer_email : g.collin25@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 : 201603
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5781" 
select * from cms_frontusers where identifiant = "g.collin25" 
 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 = "5781" 
 select * from cotisations where identifiant = "g.mainard01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 084400
payment_means : MASTERCARD
transmission_date : 20150125074400
payment_time : 084519
payment_date : 20150125
response_code : 00
payment_certificate : 10af75f17db6
authorisation_id : 445517
currency_code : 978
card_number : 5131.79
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.collin25
order_id : 5781
customer_email : g.collin25@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 : 201603
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 : 095831
payment_means : MASTERCARD
transmission_date : 20150125085831
payment_time : 100524
payment_date : 20150125
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.85
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 : j.auzeral29
order_id : 5783
customer_email : j.auzeral29@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 : 201501
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5785" 
select * from cms_frontusers where identifiant = "n.horneck23" 
 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 = "5785" 
 select * from cotisations where identifiant = "n.horneck23" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100927
payment_means : VISA
transmission_date : 20150125090927
payment_time : 101146
payment_date : 20150125
response_code : 00
payment_certificate : 04834e690e95
authorisation_id : 639891
currency_code : 978
card_number : 4978.73
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.horneck23
order_id : 5785
customer_email : n.horneck23@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 = "5786" 
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 = "5786" 
 select * from cotisations where identifiant = "a.lopezmoscoso09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 102850
payment_means : MASTERCARD
transmission_date : 20150125092850
payment_time : 103212
payment_date : 20150125
response_code : 00
payment_certificate : 10dbd833aa9b
authorisation_id : 442089
currency_code : 978
card_number : 5131.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 : 5786
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 : 201503
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5787" 
select * from cms_frontusers where identifiant = "c.boulanger04" 
 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 = "5787" 
 select * from cotisations where identifiant = "c.boulanger04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 103021
payment_means : VISA
transmission_date : 20150125093021
payment_time : 103319
payment_date : 20150125
response_code : 00
payment_certificate : f0bd3b7a0d1b
authorisation_id : 281222
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 : c.boulanger04
order_id : 5787
customer_email : c.boulanger04@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 : 201506
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5788" 
select * from cms_frontusers where identifiant = "jf.lecorre10" 
 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 = "5788" 
 select * from cotisations where identifiant = "jf.lecorre10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104856
payment_means : MASTERCARD
transmission_date : 20150125094856
payment_time : 104959
payment_date : 20150125
response_code : 00
payment_certificate : 8e5dd07fb35b
authorisation_id : 256569
currency_code : 978
card_number : 5137.34
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 : jf.lecorre10
order_id : 5788
customer_email : jf.lecorre10@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_ERROR
statement_reference : 
card_validity : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5789" 
select * from cms_frontusers where identifiant = "jf.lecorre10" 
 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 = "5789" 
 select * from cotisations where identifiant = "a.romer01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 105338
payment_means : MASTERCARD
transmission_date : 20150125095338
payment_time : 105523
payment_date : 20150125
response_code : 00
payment_certificate : 46247d45591d
authorisation_id : 881159
currency_code : 978
card_number : 5137.34
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 : jf.lecorre10
order_id : 5789
customer_email : jf.lecorre10@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 : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5790" 
select * from cms_frontusers where identifiant = "j.perras06" 
 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 = "5790" 
 select * from cotisations where identifiant = "j.perras06" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 113255
payment_means : VISA
transmission_date : 20150125103255
payment_time : 113409
payment_date : 20150125
response_code : 00
payment_certificate : dc68e28a4ad2
authorisation_id : 592670
currency_code : 978
card_number : 4975.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 : j.perras06
order_id : 5790
customer_email : j.perras06@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 : 201509
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 : 115823
payment_means : MASTERCARD
transmission_date : 20150125105823
payment_time : 120219
payment_date : 20150125
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.90
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 : f.dezest16
order_id : 5791
customer_email : f.dezest16@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 : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5792" 
select * from cms_frontusers where identifiant = "h.carreau16" 
 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 = "5792" 
 select * from cotisations where identifiant = "b.guillaume09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120500
payment_means : VISA
transmission_date : 20150125110500
payment_time : 121413
payment_date : 20150125
response_code : 00
payment_certificate : 3a26b9a9c682
authorisation_id : 065922
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 : h.carreau16
order_id : 5792
customer_email : h.carreau16@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 = "5793" 
select * from cms_frontusers where identifiant = "b.verot27" 
 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 = "5793" 
 select * from cotisations where identifiant = "g.denuiziere28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 122132
payment_means : MASTERCARD
transmission_date : 20150125112132
payment_time : 122247
payment_date : 20150125
response_code : 00
payment_certificate : ff8b858cdc86
authorisation_id : 342676
currency_code : 978
card_number : 5131.99
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.verot27
order_id : 5793
customer_email : b.verot27@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 : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5794" 
select * from cms_frontusers where identifiant = "b.verot27" 
 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 = "5794" 
 select * from cotisations where identifiant = "b.rozier12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 122403
payment_means : MASTERCARD
transmission_date : 20150125112403
payment_time : 122518
payment_date : 20150125
response_code : 00
payment_certificate : 1424128d4c4f
authorisation_id : 458635
currency_code : 978
card_number : 5131.99
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.verot27
order_id : 5794
customer_email : b.verot27@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 : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5795" 
select * from cms_frontusers where identifiant = "j.labate03" 
 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 = "5795" 
 select * from cotisations where identifiant = "j.labate03" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 133200
payment_means : VISA
transmission_date : 20150125123200
payment_time : 133430
payment_date : 20150125
response_code : 00
payment_certificate : 4db23efe31a5
authorisation_id : 633583
currency_code : 978
card_number : 4974.50
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.labate03
order_id : 5795
customer_email : j.labate03@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 : 201701
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5796" 
select * from cms_frontusers where identifiant = "o.collet25" 
 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 = "5796" 
 select * from cotisations where identifiant = "o.collet25" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 145017
payment_means : MASTERCARD
transmission_date : 20150125135017
payment_time : 145429
payment_date : 20150125
response_code : 00
payment_certificate : 166fcb7af522
authorisation_id : 509385
currency_code : 978
card_number : 5132.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 : o.collet25
order_id : 5796
customer_email : o.collet25@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 : 201502
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5797" 
select * from cms_frontusers where identifiant = "g.marechal07" 
 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 = "5797" 
 select * from cotisations where identifiant = "g.marechal07" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 145603
payment_means : MASTERCARD
transmission_date : 20150125135603
payment_time : 145832
payment_date : 20150125
response_code : 00
payment_certificate : d86775c88234
authorisation_id : 112650
currency_code : 978
card_number : 5131.87
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.marechal07
order_id : 5797
customer_email : g.marechal07@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 : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5798" 
select * from cms_frontusers where identifiant = "p.boulard28" 
 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 = "5798" 
 select * from cotisations where identifiant = "p.boulard28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 152622
payment_means : MASTERCARD
transmission_date : 20150125142622
payment_time : 152849
payment_date : 20150125
response_code : 00
payment_certificate : 98f8777bc36e
authorisation_id : 595201
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 : p.boulard28
order_id : 5798
customer_email : p.boulard28@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 = "5799" 
select * from cms_frontusers where identifiant = "p.marty12" 
 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 = "5799" 
 select * from cotisations where identifiant = "p.marty12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 180938
payment_means : VISA
transmission_date : 20150125170938
payment_time : 181134
payment_date : 20150125
response_code : 00
payment_certificate : d555c71828e8
authorisation_id : 943311
currency_code : 978
card_number : 4974.19
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.marty12
order_id : 5799
customer_email : p.marty12@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 : 201607
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5801" 
select * from cms_frontusers where identifiant = "j.berthod14" 
 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 = "5801" 
 select * from cotisations where identifiant = "p.goetz23" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181401
payment_means : VISA
transmission_date : 20150125171401
payment_time : 181717
payment_date : 20150125
response_code : 00
payment_certificate : d59bbe4f0741
authorisation_id : 446312
currency_code : 978
card_number : 4970.16
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.berthod14
order_id : 5801
customer_email : j.berthod14@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 : 201505
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5803" 
select * from cms_frontusers where identifiant = "j.berthod14" 
 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 = "5803" 
 select * from cotisations where identifiant = "e.devay18" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182023
payment_means : VISA
transmission_date : 20150125172023
payment_time : 182157
payment_date : 20150125
response_code : 00
payment_certificate : 32bc82ec9d05
authorisation_id : 494314
currency_code : 978
card_number : 4970.16
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.berthod14
order_id : 5803
customer_email : j.berthod14@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 : 201505
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "5807" 
select * from cms_frontusers where identifiant = "c.lemerre16" 
 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 = "5807" 
 select * from cotisations where identifiant = "c.lemerre16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183807
payment_means : VISA
transmission_date : 20150125173807
payment_time : 184119
payment_date : 20150125
response_code : 00
payment_certificate : d75d50dd9c0a
authorisation_id : 236712
currency_code : 978
card_number : 4970.35
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.lemerre16
order_id : 5807
customer_email : c.lemerre16@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 = "5806" 
select * from cms_frontusers where identifiant = "p.charpentier13" 
 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 = "5806" 
 select * from cotisations where identifiant = "p.charpentier13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183738
payment_means : VISA
transmission_date : 20150125173738
payment_time : 184347
payment_date : 20150125
response_code : 00
payment_certificate : 449f008921e6
authorisation_id : 151373
currency_code : 978
card_number : 4563.55
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.charpentier13
order_id : 5806
customer_email : p.charpentier13@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 : 201701
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------