select * from cotisations_commande where id = "11317" 
select * from cms_frontusers where identifiant = "r.goffinet10" 
 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 = "11317" 
 select * from cotisations where identifiant = "r.goffinet10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 010704
payment_means : MASTERCARD
transmission_date : 20151222000704
payment_time : 010904
payment_date : 20151222
response_code : 00
payment_certificate : 6724c37a0b3c
authorisation_id : 876933
currency_code : 978
card_number : 5132.97
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.goffinet10
order_id : 11317
customer_email : r.goffinet10@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 = "11318" 
select * from cms_frontusers where identifiant = "v.dailly11" 
 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 = "11318" 
 select * from cotisations where identifiant = "v.dailly11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 075530
payment_means : MASTERCARD
transmission_date : 20151222065530
payment_time : 080455
payment_date : 20151222
response_code : 00
payment_certificate : 8ababc160ab6
authorisation_id : 551585
currency_code : 978
card_number : 5136.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 : v.dailly11
order_id : 11318
customer_email : v.dailly11@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 : 201601
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11319" 
select * from cms_frontusers where identifiant = "d.normand09" 
 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 = "11319" 
 select * from cotisations where identifiant = "d.normand09" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 080652
payment_means : MASTERCARD
transmission_date : 20151222070652
payment_time : 080846
payment_date : 20151222
response_code : 00
payment_certificate : 9ace388fa33a
authorisation_id : 420532
currency_code : 978
card_number : 5341.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 : d.normand09
order_id : 11319
customer_email : d.normand09@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 = "11320" 
select * from cms_frontusers where identifiant = "x.jacquot24" 
 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 = "11320" 
 select * from cotisations where identifiant = "x.jacquot24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 10000
transaction_id : 080835
payment_means : VISA
transmission_date : 20151222070835
payment_time : 081113
payment_date : 20151222
response_code : 00
payment_certificate : 27e1564e7f12
authorisation_id : 020442
currency_code : 978
card_number : 4950.67
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.jacquot24
order_id : 11320
customer_email : x.jacquot24@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 090352
payment_means : VISA
transmission_date : 20151222080352
payment_time : 080705
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 
cvv_flag : 
cvv_response_code : 
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : jm.roy10
order_id : 11321
customer_email : jm.roy10@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : SSL
statement_reference : 
card_validity : 
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 : 095346
payment_means : MASTERCARD
transmission_date : 20151222085346
payment_time : 100206
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5137.43
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 : r.james28
order_id : 11323
customer_email : r.james28@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 : 201704
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11323" 
select * from cms_frontusers where identifiant = "r.james28" 
 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 = "11323" 
 select * from cotisations where identifiant = "r.james28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100211
payment_means : MASTERCARD
transmission_date : 20151222090211
payment_time : 100632
payment_date : 20151222
response_code : 00
payment_certificate : b6c88bbdf79c
authorisation_id : 230383
currency_code : 978
card_number : 5136.61
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.james28
order_id : 11323
customer_email : r.james28@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 : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11324" 
select * from cms_frontusers where identifiant = "m.desantis22" 
 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 = "11324" 
 select * from cotisations where identifiant = "m.desantis22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 101825
payment_means : MASTERCARD
transmission_date : 20151222091825
payment_time : 102158
payment_date : 20151222
response_code : 00
payment_certificate : 8c3d3899f14b
authorisation_id : 978816
currency_code : 978
card_number : 5131.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 : m.desantis22
order_id : 11324
customer_email : m.desantis22@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 = "11325" 
select * from cms_frontusers where identifiant = "da.martelmorin05" 
 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 = "11325" 
 select * from cotisations where identifiant = "da.martelmorin05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 103631
payment_means : MASTERCARD
transmission_date : 20151222093631
payment_time : 103828
payment_date : 20151222
response_code : 00
payment_certificate : 76838b12ccf9
authorisation_id : 319399
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 : da.martelmorin05
order_id : 11325
customer_email : da.martelmorin05@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 : 201602
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11327" 
select * from cms_frontusers where identifiant = "b.sauve03" 
 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 = "11327" 
 select * from cotisations where identifiant = "p.leblond10" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "b.sauve03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 105126
payment_means : MASTERCARD
transmission_date : 20151222095126
payment_time : 105834
payment_date : 20151222
response_code : 00
payment_certificate : 4f7ba38f639f
authorisation_id : 502759
currency_code : 978
card_number : 5132.67
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.sauve03
order_id : 11327
customer_email : b.sauve03@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 114421
payment_means : VISA
transmission_date : 20151222104421
payment_time : 114520
payment_date : 20151222
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4556.32
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 57
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : j.lambou21
order_id : 11328
customer_email : j.lambou21@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 = "11329" 
select * from cms_frontusers where identifiant = "v.montagner06" 
 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 = "11329" 
 select * from cotisations where identifiant = "v.montagner06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 114623
payment_means : MASTERCARD
transmission_date : 20151222104623
payment_time : 115012
payment_date : 20151222
response_code : 00
payment_certificate : 4797365e4c98
authorisation_id : 200222
currency_code : 978
card_number : 5132.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 : v.montagner06
order_id : 11329
customer_email : v.montagner06@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 122246
payment_means : VISA
transmission_date : 20151222112246
payment_time : 123716
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4561.53
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 : da.martelmorin05
order_id : 11330
customer_email : da.martelmorin05@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 : 201802
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11332" 
select * from cms_frontusers where identifiant = "v.bonnet04" 
 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 = "11332" 
 select * from cotisations where identifiant = "f.soudy13" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 131122
payment_means : VISA
transmission_date : 20151222121122
payment_time : 131331
payment_date : 20151222
response_code : 00
payment_certificate : 29624bade73f
authorisation_id : 555162
currency_code : 978
card_number : 4974.47
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 : v.bonnet04
order_id : 11332
customer_email : v.bonnet04@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 = "11333" 
select * from cms_frontusers where identifiant = "da.martelmorin05" 
 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 = "11333" 
 select * from cotisations where identifiant = "a.quenel19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 133748
payment_means : VISA
transmission_date : 20151222123748
payment_time : 134005
payment_date : 20151222
response_code : 00
payment_certificate : 743d916cca2a
authorisation_id : 263194
currency_code : 978
card_number : 4561.53
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 : da.martelmorin05
order_id : 11333
customer_email : da.martelmorin05@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 = "11334" 
select * from cms_frontusers where identifiant = "m.gillardin21" 
 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 = "11334" 
 select * from cotisations where identifiant = "p.bruyas22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 142239
payment_means : VISA
transmission_date : 20151222132239
payment_time : 142629
payment_date : 20151222
response_code : 00
payment_certificate : 3d989269f333
authorisation_id : 166707
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 : m.gillardin21
order_id : 11334
customer_email : m.gillardin21@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 = "11335" 
select * from cms_frontusers where identifiant = "g.villefeu16" 
 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 = "11335" 
 select * from cotisations where identifiant = "g.villefeu16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 150119
payment_means : VISA
transmission_date : 20151222140119
payment_time : 150250
payment_date : 20151222
response_code : 00
payment_certificate : 7e5fd2f5b595
authorisation_id : 500516
currency_code : 978
card_number : 4974.03
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.villefeu16
order_id : 11335
customer_email : g.villefeu16@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 = "11336" 
select * from cms_frontusers where identifiant = "q.stiquel12" 
 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 = "11336" 
 select * from cotisations where identifiant = "q.stiquel12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 160317
payment_means : MASTERCARD
transmission_date : 20151222150317
payment_time : 160952
payment_date : 20151222
response_code : 00
payment_certificate : c76a4757a01d
authorisation_id : 634500
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 : q.stiquel12
order_id : 11336
customer_email : q.stiquel12@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 = "11337" 
select * from cms_frontusers where identifiant = "r.masson06" 
 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 = "11337" 
 select * from cotisations where identifiant = "r.masson06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 160909
payment_means : MASTERCARD
transmission_date : 20151222150909
payment_time : 161050
payment_date : 20151222
response_code : 00
payment_certificate : e47340e71a57
authorisation_id : 429648
currency_code : 978
card_number : 5131.51
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.masson06
order_id : 11337
customer_email : r.masson06@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 161808
payment_means : VISA
transmission_date : 20151222151808
payment_time : 162352
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4972.78
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 : p.gohard28
order_id : 11338
customer_email : p.gohard28@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11339" 
select * from cms_frontusers where identifiant = "s.houdayer20" 
 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 = "11339" 
 select * from cotisations where identifiant = "s.houdayer20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 162817
payment_means : VISA
transmission_date : 20151222152817
payment_time : 163006
payment_date : 20151222
response_code : 00
payment_certificate : dece22211151
authorisation_id : 243505
currency_code : 978
card_number : 4977.95
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 : s.houdayer20
order_id : 11339
customer_email : s.houdayer20@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 = "11340" 
select * from cms_frontusers where identifiant = "n.roy20" 
 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 = "11340" 
 select * from cotisations where identifiant = "n.roy20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 163108
payment_means : MASTERCARD
transmission_date : 20151222153108
payment_time : 163355
payment_date : 20151222
response_code : 00
payment_certificate : 2e9ffe68666c
authorisation_id : 444466
currency_code : 978
card_number : 5132.56
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.roy20
order_id : 11340
customer_email : n.roy20@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 : 201512
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11341" 
select * from cms_frontusers where identifiant = "c.mouchoux21" 
 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 = "11341" 
 select * from cotisations where identifiant = "c.mouchoux21" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 171820
payment_means : MASTERCARD
transmission_date : 20151222161820
payment_time : 171949
payment_date : 20151222
response_code : 00
payment_certificate : 21f84838c12d
authorisation_id : 842623
currency_code : 978
card_number : 5131.66
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.mouchoux21
order_id : 11341
customer_email : c.mouchoux21@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 174945
payment_means : MASTERCARD
transmission_date : 20151222164945
payment_time : 175053
payment_date : 20151222
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.08
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : jj.rabouan04
order_id : 11342
customer_email : jj.rabouan04@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 175109
payment_means : MASTERCARD
transmission_date : 20151222165109
payment_time : 175219
payment_date : 20151222
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.08
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : jj.rabouan04
order_id : 11342
customer_email : jj.rabouan04@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "11342" 
select * from cms_frontusers where identifiant = "jj.rabouan04" 
 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 = "11342" 
 select * from cotisations where identifiant = "jj.rabouan04" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 175226
payment_means : MASTERCARD
transmission_date : 20151222165226
payment_time : 175357
payment_date : 20151222
response_code : 00
payment_certificate : 459eaaeac472
authorisation_id : 958264
currency_code : 978
card_number : 5137.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 : jj.rabouan04
order_id : 11342
customer_email : jj.rabouan04@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 = "11343" 
select * from cms_frontusers where identifiant = "j.vuidel10" 
 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 = "11343" 
 select * from cotisations where identifiant = "j.vuidel10" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "n.arun25" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "a.schmitt11" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "c.mousist30" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "a.ruffio03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 40000
transaction_id : 180816
payment_means : MASTERCARD
transmission_date : 20151222170816
payment_time : 181039
payment_date : 20151222
response_code : 00
payment_certificate : 0e6a44ad6f9b
authorisation_id : 156733
currency_code : 978
card_number : 5131.25
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.vuidel10
order_id : 11343
customer_email : j.vuidel10@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 : 201805
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11344" 
select * from cms_frontusers where identifiant = "p.guilbaud27" 
 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 = "11344" 
 select * from cotisations where identifiant = "p.guilbaud27" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181245
payment_means : VISA
transmission_date : 20151222171245
payment_time : 183021
payment_date : 20151222
response_code : 00
payment_certificate : b088e81dbc8c
authorisation_id : 561277
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 : p.guilbaud27
order_id : 11344
customer_email : p.guilbaud27@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 = "11347" 
select * from cms_frontusers where identifiant = "v.asnar24" 
 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 = "11347" 
 select * from cotisations where identifiant = "v.asnar24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 183728
payment_means : VISA
transmission_date : 20151222173728
payment_time : 183922
payment_date : 20151222
response_code : 00
payment_certificate : 6cb439f29ad0
authorisation_id : 922504
currency_code : 978
card_number : 4978.72
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 : v.asnar24
order_id : 11347
customer_email : v.asnar24@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 = "11346" 
select * from cms_frontusers where identifiant = "p.dupin04" 
 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 = "11346" 
 select * from cotisations where identifiant = "p.dupin04" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183723
payment_means : MASTERCARD
transmission_date : 20151222173723
payment_time : 184034
payment_date : 20151222
response_code : 00
payment_certificate : 360a25ca7775
authorisation_id : 630746
currency_code : 978
card_number : 5131.25
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.dupin04
order_id : 11346
customer_email : p.dupin04@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 : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11348" 
select * from cms_frontusers where identifiant = "b.duclos15" 
 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 = "11348" 
 select * from cotisations where identifiant = "b.duclos15" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 185148
payment_means : MASTERCARD
transmission_date : 20151222175148
payment_time : 185345
payment_date : 20151222
response_code : 00
payment_certificate : 46a1e96ab27d
authorisation_id : 658335
currency_code : 978
card_number : 5131.76
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.duclos15
order_id : 11348
customer_email : b.duclos15@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 = "11349" 
select * from cms_frontusers where identifiant = "q.marnas20" 
 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 = "11349" 
 select * from cotisations where identifiant = "q.marnas20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190017
payment_means : MASTERCARD
transmission_date : 20151222180017
payment_time : 190222
payment_date : 20151222
response_code : 00
payment_certificate : 4e012b90edae
authorisation_id : 368116
currency_code : 978
card_number : 5131.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 : q.marnas20
order_id : 11349
customer_email : q.marnas20@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 = "11350" 
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 = "11350" 
 select * from cotisations where identifiant = "a.haudebert12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190921
payment_means : VISA
transmission_date : 20151222180921
payment_time : 191147
payment_date : 20151222
response_code : 00
payment_certificate : 250f53af001d
authorisation_id : 412232
currency_code : 978
card_number : 4978.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 : b.seres21
order_id : 11350
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 : 201609
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11351" 
select * from cms_frontusers where identifiant = "q.marnas20" 
 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 = "11351" 
 select * from cotisations where identifiant = "p.padey07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 192205
payment_means : MASTERCARD
transmission_date : 20151222182205
payment_time : 192424
payment_date : 20151222
response_code : 00
payment_certificate : e49d667e4110
authorisation_id : 750943
currency_code : 978
card_number : 5365.40
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 : q.marnas20
order_id : 11351
customer_email : q.marnas20@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 : 201909
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11352" 
select * from cms_frontusers where identifiant = "p.lefebvre06" 
 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 = "11352" 
 select * from cotisations where identifiant = "p.fournier25" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 193658
payment_means : VISA
transmission_date : 20151222183658
payment_time : 193820
payment_date : 20151222
response_code : 00
payment_certificate : 2335c3d22c43
authorisation_id : 457324
currency_code : 978
card_number : 4533.49
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.lefebvre06
order_id : 11352
customer_email : p.lefebvre06@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11353" 
select * from cms_frontusers where identifiant = "p.lefebvre06" 
 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 = "11353" 
 select * from cotisations where identifiant = "jm.barthelemy28" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 193941
payment_means : VISA
transmission_date : 20151222183941
payment_time : 194055
payment_date : 20151222
response_code : 00
payment_certificate : cfb9ee75ec52
authorisation_id : 529172
currency_code : 978
card_number : 4533.49
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.lefebvre06
order_id : 11353
customer_email : p.lefebvre06@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11355" 
select * from cms_frontusers where identifiant = "p.lefebvre06" 
 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 = "11355" 
 select * from cotisations where identifiant = "y.rebeyrat24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 194149
payment_means : VISA
transmission_date : 20151222184149
payment_time : 194256
payment_date : 20151222
response_code : 00
payment_certificate : c2651d40b8f1
authorisation_id : 324206
currency_code : 978
card_number : 4533.49
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.lefebvre06
order_id : 11355
customer_email : p.lefebvre06@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11356" 
select * from cms_frontusers where identifiant = "p.lefebvre06" 
 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 = "11356" 
 select * from cotisations where identifiant = "c.piraux03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 194350
payment_means : VISA
transmission_date : 20151222184350
payment_time : 194455
payment_date : 20151222
response_code : 00
payment_certificate : 99b566be9a46
authorisation_id : 941172
currency_code : 978
card_number : 4533.49
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.lefebvre06
order_id : 11356
customer_email : p.lefebvre06@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11354" 
select * from cms_frontusers where identifiant = "j.clin10" 
 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 = "11354" 
 select * from cotisations where identifiant = "j.clin10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 193942
payment_means : VISA
transmission_date : 20151222183942
payment_time : 194558
payment_date : 20151222
response_code : 00
payment_certificate : dc68ba89a36b
authorisation_id : 942476
currency_code : 978
card_number : 4978.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 : j.clin10
order_id : 11354
customer_email : j.clin10@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 = "11357" 
select * from cms_frontusers where identifiant = "p.lefebvre06" 
 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 = "11357" 
 select * from cotisations where identifiant = "p.balme18" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "p.balme18" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 194618
payment_means : VISA
transmission_date : 20151222184618
payment_time : 194720
payment_date : 20151222
response_code : 00
payment_certificate : bf87bd3c9222
authorisation_id : 153519
currency_code : 978
card_number : 4533.49
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.lefebvre06
order_id : 11357
customer_email : p.lefebvre06@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 : 201811
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 : 16000
transaction_id : 194830
payment_means : VISA
transmission_date : 20151222184830
payment_time : 194938
payment_date : 20151222
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4533.49
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 02
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : p.lefebvre06
order_id : 11358
customer_email : p.lefebvre06@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 : 201811
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11359" 
select * from cms_frontusers where identifiant = "f.placier08" 
 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 = "11359" 
 select * from cotisations where identifiant = "y.lebeau20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 200236
payment_means : VISA
transmission_date : 20151222190236
payment_time : 200504
payment_date : 20151222
response_code : 00
payment_certificate : 70f7f056f21a
authorisation_id : 037609
currency_code : 978
card_number : 4970.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 : f.placier08
order_id : 11359
customer_email : f.placier08@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 = "11360" 
select * from cms_frontusers where identifiant = "f.placier08" 
 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 = "11360" 
 select * from cotisations where identifiant = "r.desplanques12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 200832
payment_means : VISA
transmission_date : 20151222190832
payment_time : 201021
payment_date : 20151222
response_code : 00
payment_certificate : d354560a5f31
authorisation_id : 588104
currency_code : 978
card_number : 4970.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 : f.placier08
order_id : 11360
customer_email : f.placier08@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 = "11362" 
select * from cms_frontusers where identifiant = "m.dautin10" 
 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 = "11362" 
 select * from cotisations where identifiant = "m.dautin10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202053
payment_means : VISA
transmission_date : 20151222192053
payment_time : 202335
payment_date : 20151222
response_code : 00
payment_certificate : 35dd0ac1525b
authorisation_id : 868960
currency_code : 978
card_number : 4978.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 : m.dautin10
order_id : 11362
customer_email : m.dautin10@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 = "11363" 
select * from cms_frontusers where identifiant = "m.dautin10" 
 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 = "11363" 
 select * from cotisations where identifiant = "m.dautin10" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202415
payment_means : VISA
transmission_date : 20151222192415
payment_time : 202555
payment_date : 20151222
response_code : 00
payment_certificate : 5962d14a0292
authorisation_id : 875756
currency_code : 978
card_number : 4978.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 : m.dautin10
order_id : 11363
customer_email : m.dautin10@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 = "11361" 
select * from cms_frontusers where identifiant = "e.marchal03" 
 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 = "11361" 
 select * from cotisations where identifiant = "e.marchal03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 202034
payment_means : MASTERCARD
transmission_date : 20151222192034
payment_time : 204443
payment_date : 20151222
response_code : 00
payment_certificate : d1bd1485d3f4
authorisation_id : 351824
currency_code : 978
card_number : 5131.77
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 : e.marchal03
order_id : 11361
customer_email : e.marchal03@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 : 201806
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "11365" 
select * from cms_frontusers where identifiant = "l.baneti22" 
 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 = "11365" 
 select * from cotisations where identifiant = "l.baneti22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212430
payment_means : VISA
transmission_date : 20151222202430
payment_time : 212704
payment_date : 20151222
response_code : 00
payment_certificate : 091fe46bca18
authorisation_id : 234170
currency_code : 978
card_number : 4970.78
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.baneti22
order_id : 11365
customer_email : l.baneti22@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 = "11364" 
select * from cms_frontusers where identifiant = "v.bonnet04" 
 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 = "11364" 
 select * from cotisations where identifiant = "c.blanchet20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212045
payment_means : MASTERCARD
transmission_date : 20151222202045
payment_time : 213003
payment_date : 20151222
response_code : 00
payment_certificate : c86c821c5a47
authorisation_id : 467754
currency_code : 978
card_number : 5137.76
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 : v.bonnet04
order_id : 11364
customer_email : v.bonnet04@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 = "11366" 
select * from cms_frontusers where identifiant = "jf.desbois11" 
 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 = "11366" 
 select * from cotisations where identifiant = "jf.desbois11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214515
payment_means : VISA
transmission_date : 20151222204515
payment_time : 214659
payment_date : 20151222
response_code : 00
payment_certificate : ee05096de940
authorisation_id : 243254
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 : jf.desbois11
order_id : 11366
customer_email : jf.desbois11@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 = "11367" 
select * from cms_frontusers where identifiant = "d.moniot23" 
 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 = "11367" 
 select * from cotisations where identifiant = "d.moniot23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221313
payment_means : VISA
transmission_date : 20151222211313
payment_time : 221441
payment_date : 20151222
response_code : 00
payment_certificate : a6d5628742e0
authorisation_id : 661554
currency_code : 978
card_number : 4975.40
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.moniot23
order_id : 11367
customer_email : d.moniot23@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 231407
payment_means : MASTERCARD
transmission_date : 20151222221407
payment_time : 231909
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.81
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 : c.roirand30
order_id : 11368
customer_email : c.roirand30@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 232958
payment_means : MASTERCARD
transmission_date : 20151222222958
payment_time : 233558
payment_date : 20151222
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5133.97
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 : a.bouquet01
order_id : 11370
customer_email : a.bouquet01@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 : 201606
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------