select * from cotisations_commande where id = "17323" 
select * from cms_frontusers where identifiant = "a.chibout26" 
 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 = "17323" 
 select * from cotisations where identifiant = "a.chibout26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 083645
payment_means : MASTERCARD
transmission_date : 20161203073645
payment_time : 083757
payment_date : 20161203
response_code : 00
payment_certificate : 46dbe193052c
authorisation_id : 956618
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 : a.chibout26
order_id : 17323
customer_email : a.chibout26@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 = "17324" 
select * from cms_frontusers where identifiant = "l.veyssiere02" 
 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 = "17324" 
 select * from cotisations where identifiant = "l.veyssiere02" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 083844
payment_means : VISA
transmission_date : 20161203073844
payment_time : 084114
payment_date : 20161203
response_code : 00
payment_certificate : 2cf381acd494
authorisation_id : 347439
currency_code : 978
card_number : 4970.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 : l.veyssiere02
order_id : 17324
customer_email : l.veyssiere02@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 = "17325" 
select * from cms_frontusers where identifiant = "c.ruiz12" 
 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 = "17325" 
 select * from cotisations where identifiant = "c.ruiz12" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 084720
payment_means : VISA
transmission_date : 20161203074720
payment_time : 085018
payment_date : 20161203
response_code : 00
payment_certificate : 12318d6ba475
authorisation_id : 564661
currency_code : 978
card_number : 4979.21
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.ruiz12
order_id : 17325
customer_email : c.ruiz12@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 = "17326" 
select * from cms_frontusers where identifiant = "c.dronne10" 
 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 = "17326" 
 select * from cotisations where identifiant = "c.dronne10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 084733
payment_means : MASTERCARD
transmission_date : 20161203074733
payment_time : 085113
payment_date : 20161203
response_code : 00
payment_certificate : c8d037529393
authorisation_id : 666363
currency_code : 978
card_number : 5341.96
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.dronne10
order_id : 17326
customer_email : c.dronne10@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 = "17327" 
select * from cms_frontusers where identifiant = "t.courteille21" 
 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 = "17327" 
 select * from cotisations where identifiant = "c.courteille11" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 085750
payment_means : MASTERCARD
transmission_date : 20161203075750
payment_time : 085929
payment_date : 20161203
response_code : 00
payment_certificate : 4fdcf444446f
authorisation_id : 861196
currency_code : 978
card_number : 5138.09
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.courteille21
order_id : 17327
customer_email : t.courteille21@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 091630
payment_means : MASTERCARD
transmission_date : 20161203081630
payment_time : 091803
payment_date : 20161203
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.09
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 : s.darvesblanc21
order_id : 17328
customer_email : s.darvesblanc21@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 = "17329" 
select * from cms_frontusers where identifiant = "p.bonnifait28" 
 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 = "17329" 
 select * from cotisations where identifiant = "p.bonnifait28" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 092000
payment_means : VISA
transmission_date : 20161203082000
payment_time : 092652
payment_date : 20161203
response_code : 00
payment_certificate : 5a4c083cd5c7
authorisation_id : 332144
currency_code : 978
card_number : 4976.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 : p.bonnifait28
order_id : 17329
customer_email : p.bonnifait28@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 = "17330" 
select * from cms_frontusers where identifiant = "jc.blaison16" 
 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 = "17330" 
 select * from cotisations where identifiant = "jc.blaison16" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 101718
payment_means : VISA
transmission_date : 20161203091718
payment_time : 101928
payment_date : 20161203
response_code : 00
payment_certificate : 0a069826c493
authorisation_id : 734081
currency_code : 978
card_number : 4975.26
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 : jc.blaison16
order_id : 17330
customer_email : jc.blaison16@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 = "17331" 
select * from cms_frontusers where identifiant = "c.fouquet23" 
 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 = "17331" 
 select * from cotisations where identifiant = "c.fouquet23" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 102622
payment_means : VISA
transmission_date : 20161203092622
payment_time : 102933
payment_date : 20161203
response_code : 00
payment_certificate : 19e3e13d3779
authorisation_id : 255645
currency_code : 978
card_number : 4978.27
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.fouquet23
order_id : 17331
customer_email : c.fouquet23@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 : 201905
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17334" 
select * from cms_frontusers where identifiant = "l.bernard27" 
 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 = "17334" 
 select * from cotisations where identifiant = "l.bernard27" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104924
payment_means : MASTERCARD
transmission_date : 20161203094924
payment_time : 105150
payment_date : 20161203
response_code : 00
payment_certificate : 9d90b1106c03
authorisation_id : 256556
currency_code : 978
card_number : 5131.92
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : l.bernard27
order_id : 17334
customer_email : l.bernard27@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 = "17337" 
select * from cms_frontusers where identifiant = "p.blateau10" 
 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 = "17337" 
 select * from cotisations where identifiant = "g.dijon21" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 110446
payment_means : MASTERCARD
transmission_date : 20161203100446
payment_time : 110616
payment_date : 20161203
response_code : 00
payment_certificate : 52bea3f2abf4
authorisation_id : 689984
currency_code : 978
card_number : 5131.90
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.blateau10
order_id : 17337
customer_email : p.blateau10@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 : 201911
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17338" 
select * from cms_frontusers where identifiant = "p.blateau10" 
 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 = "17338" 
 select * from cotisations where identifiant = "p.triconnet10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 110750
payment_means : MASTERCARD
transmission_date : 20161203100750
payment_time : 110850
payment_date : 20161203
response_code : 00
payment_certificate : cf257423fa1c
authorisation_id : 607166
currency_code : 978
card_number : 5131.90
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.blateau10
order_id : 17338
customer_email : p.blateau10@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 : 201911
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17339" 
select * from cms_frontusers where identifiant = "p.blateau10" 
 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 = "17339" 
 select * from cotisations where identifiant = "g.triconnet12" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 111857
payment_means : MASTERCARD
transmission_date : 20161203101857
payment_time : 111957
payment_date : 20161203
response_code : 00
payment_certificate : 8ba4080004e4
authorisation_id : 104266
currency_code : 978
card_number : 5131.90
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.blateau10
order_id : 17339
customer_email : p.blateau10@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 : 201911
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17342" 
select * from cms_frontusers where identifiant = "p.blateau10" 
 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 = "17342" 
 select * from cotisations where identifiant = "p.blateau10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 113503
payment_means : MASTERCARD
transmission_date : 20161203103503
payment_time : 113556
payment_date : 20161203
response_code : 00
payment_certificate : 872b0d49542d
authorisation_id : 303389
currency_code : 978
card_number : 5131.90
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.blateau10
order_id : 17342
customer_email : p.blateau10@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 : 201911
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17343" 
select * from cms_frontusers where identifiant = "a.lozie12" 
 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 = "17343" 
 select * from cotisations where identifiant = "a.lozie12" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 115940
payment_means : MASTERCARD
transmission_date : 20161203105940
payment_time : 120145
payment_date : 20161203
response_code : 00
payment_certificate : 01ff45ff9abc
authorisation_id : 975534
currency_code : 978
card_number : 5132.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 : a.lozie12
order_id : 17343
customer_email : a.lozie12@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 = "17345" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17345" 
 select * from cotisations where identifiant = "n.gede25" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120537
payment_means : VISA
transmission_date : 20161203110537
payment_time : 120639
payment_date : 20161203
response_code : 00
payment_certificate : 0def532d3682
authorisation_id : 152640
currency_code : 978
card_number : 4975.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 : s.diaz02
order_id : 17345
customer_email : s.diaz02@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 = "17346" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17346" 
 select * from cotisations where identifiant = "n.marchand26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120759
payment_means : MASTERCARD
transmission_date : 20161203110759
payment_time : 120855
payment_date : 20161203
response_code : 00
payment_certificate : a81f14db4cd4
authorisation_id : 814141
currency_code : 978
card_number : 5137.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 : s.diaz02
order_id : 17346
customer_email : s.diaz02@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 : 201911
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17347" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17347" 
 select * from cotisations where identifiant = "f.bodier04" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "f.bodier04" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 120946
payment_means : MASTERCARD
transmission_date : 20161203110946
payment_time : 121055
payment_date : 20161203
response_code : 00
payment_certificate : 16b456e79eac
authorisation_id : 496730
currency_code : 978
card_number : 5137.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 : s.diaz02
order_id : 17347
customer_email : s.diaz02@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 : 201904
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17348" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17348" 
 select * from cotisations where identifiant = "o.birchler09" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 121140
payment_means : MASTERCARD
transmission_date : 20161203111140
payment_time : 121247
payment_date : 20161203
response_code : 00
payment_certificate : 7f4b6f5f973c
authorisation_id : 490119
currency_code : 978
card_number : 5137.46
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : s.diaz02
order_id : 17348
customer_email : s.diaz02@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 = "17349" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17349" 
 select * from cotisations where identifiant = "r.lepine28" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 121318
payment_means : MASTERCARD
transmission_date : 20161203111318
payment_time : 121437
payment_date : 20161203
response_code : 00
payment_certificate : 1fba20bdbf14
authorisation_id : 346873
currency_code : 978
card_number : 5131.81
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.diaz02
order_id : 17349
customer_email : s.diaz02@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 : 201910
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17350" 
select * from cms_frontusers where identifiant = "s.diaz02" 
 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 = "17350" 
 select * from cotisations where identifiant = "a.devauchelle01" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 121550
payment_means : MASTERCARD
transmission_date : 20161203111550
payment_time : 121734
payment_date : 20161203
response_code : 00
payment_certificate : 70d1540e64a8
authorisation_id : 713501
currency_code : 978
card_number : 5341.20
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : s.diaz02
order_id : 17350
customer_email : s.diaz02@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 = "17352" 
select * from cms_frontusers where identifiant = "jp.biet19" 
 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 = "17352" 
 select * from cotisations where identifiant = "jp.biet19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 125224
payment_means : MASTERCARD
transmission_date : 20161203115224
payment_time : 125847
payment_date : 20161203
response_code : 00
payment_certificate : 5af4d3cfbaf4
authorisation_id : 344538
currency_code : 978
card_number : 5137.52
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : jp.biet19
order_id : 17352
customer_email : jp.biet19@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 = "17353" 
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 = "17353" 
 select * from cotisations where identifiant = "v.asnar24" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 131859
payment_means : VISA
transmission_date : 20161203121859
payment_time : 132400
payment_date : 20161203
response_code : 00
payment_certificate : 0a1fa05b8a1d
authorisation_id : 972809
currency_code : 978
card_number : 4978.46
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : v.asnar24
order_id : 17353
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 : 201909
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17354" 
select * from cms_frontusers where identifiant = "j.jezequel06" 
 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 = "17354" 
 select * from cotisations where identifiant = "j.jezequel06" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 142826
payment_means : VISA
transmission_date : 20161203132826
payment_time : 142934
payment_date : 20161203
response_code : 00
payment_certificate : 8fe4c2be96c0
authorisation_id : 517473
currency_code : 978
card_number : 4970.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 : j.jezequel06
order_id : 17354
customer_email : j.jezequel06@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 = "17355" 
select * from cms_frontusers where identifiant = "j.raffard15" 
 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 = "17355" 
 select * from cotisations where identifiant = "j.raffard15" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 145011
payment_means : MASTERCARD
transmission_date : 20161203135011
payment_time : 145409
payment_date : 20161203
response_code : 00
payment_certificate : 99aafacc6411
authorisation_id : 455761
currency_code : 978
card_number : 5131.60
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.raffard15
order_id : 17355
customer_email : j.raffard15@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 = "17356" 
select * from cms_frontusers where identifiant = "m.rouanet19" 
 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 = "17356" 
 select * from cotisations where identifiant = "m.rouanet19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 150543
payment_means : VISA
transmission_date : 20161203140543
payment_time : 150720
payment_date : 20161203
response_code : 00
payment_certificate : 1048640ff3c4
authorisation_id : 782956
currency_code : 978
card_number : 4978.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 : m.rouanet19
order_id : 17356
customer_email : m.rouanet19@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 = "17357" 
select * from cms_frontusers where identifiant = "t.pointillart21" 
 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 = "17357" 
 select * from cotisations where identifiant = "t.pointillart21" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 152014
payment_means : VISA
transmission_date : 20161203142014
payment_time : 152150
payment_date : 20161203
response_code : 00
payment_certificate : 6c4d98187a54
authorisation_id : 042134
currency_code : 978
card_number : 4975.05
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.pointillart21
order_id : 17357
customer_email : t.pointillart21@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 = "17358" 
select * from cms_frontusers where identifiant = "a.bouder19" 
 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 = "17358" 
 select * from cotisations where identifiant = "a.bouder19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 155117
payment_means : MASTERCARD
transmission_date : 20161203145117
payment_time : 155427
payment_date : 20161203
response_code : 00
payment_certificate : 002c7506b8bc
authorisation_id : 466435
currency_code : 978
card_number : 5132.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.bouder19
order_id : 17358
customer_email : a.bouder19@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 = "17360" 
select * from cms_frontusers where identifiant = "a.roos14" 
 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 = "17360" 
 select * from cotisations where identifiant = "a.roos14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 161303
payment_means : MASTERCARD
transmission_date : 20161203151303
payment_time : 161429
payment_date : 20161203
response_code : 00
payment_certificate : 4b03c09329ab
authorisation_id : 141532
currency_code : 978
card_number : 5131.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 : a.roos14
order_id : 17360
customer_email : a.roos14@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201803
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17361" 
select * from cms_frontusers where identifiant = "l.fasan21" 
 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 = "17361" 
 select * from cotisations where identifiant = "l.fasan21" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 161355
payment_means : MASTERCARD
transmission_date : 20161203151355
payment_time : 161537
payment_date : 20161203
response_code : 00
payment_certificate : 88a5d101c9d1
authorisation_id : 112412
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 : l.fasan21
order_id : 17361
customer_email : l.fasan21@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 = "17362" 
select * from cms_frontusers where identifiant = "a.bouder19" 
 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 = "17362" 
 select * from cotisations where identifiant = "o.ducarouge20" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 163218
payment_means : MASTERCARD
transmission_date : 20161203153218
payment_time : 163848
payment_date : 20161203
response_code : 00
payment_certificate : b6416a5a2678
authorisation_id : 907272
currency_code : 978
card_number : 5132.29
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.bouder19
order_id : 17362
customer_email : a.bouder19@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 = "17363" 
select * from cms_frontusers where identifiant = "y.bourdet09" 
 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 = "17363" 
 select * from cotisations where identifiant = "y.bourdet09" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 170204
payment_means : VISA
transmission_date : 20161203160204
payment_time : 170335
payment_date : 20161203
response_code : 00
payment_certificate : 4d58638eaa90
authorisation_id : 179220
currency_code : 978
card_number : 4970.92
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : y.bourdet09
order_id : 17363
customer_email : y.bourdet09@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 = "17366" 
select * from cms_frontusers where identifiant = "jm.herbert17" 
 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 = "17366" 
 select * from cotisations where identifiant = "jm.herbert17" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183248
payment_means : MASTERCARD
transmission_date : 20161203173248
payment_time : 183756
payment_date : 20161203
response_code : 00
payment_certificate : 32f2cb8af9ca
authorisation_id : 321227
currency_code : 978
card_number : 5131.26
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 : jm.herbert17
order_id : 17366
customer_email : jm.herbert17@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 = "17367" 
select * from cms_frontusers where identifiant = "f.calin31" 
 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 = "17367" 
 select * from cotisations where identifiant = "a.bonnefoux08" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 185450
payment_means : MASTERCARD
transmission_date : 20161203175450
payment_time : 185707
payment_date : 20161203
response_code : 00
payment_certificate : fb34e1d93ef5
authorisation_id : 295759
currency_code : 978
card_number : 5294.83
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.calin31
order_id : 17367
customer_email : f.calin31@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 = "17368" 
select * from cms_frontusers where identifiant = "p.jarantowski25" 
 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 = "17368" 
 select * from cotisations where identifiant = "p.jarantowski25" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "n.betzen24" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "c.mignot09" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "m.pfeiffer27" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "p.olliet17" and annee = "2017" and montant <> 0 
 select * from cotisations where identifiant = "j.wolter17" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 48000
transaction_id : 185922
payment_means : MASTERCARD
transmission_date : 20161203175922
payment_time : 190117
payment_date : 20161203
response_code : 00
payment_certificate : d5952e0d2d90
authorisation_id : 631390
currency_code : 978
card_number : 5400.82
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.jarantowski25
order_id : 17368
customer_email : p.jarantowski25@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 : 201902
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17373" 
select * from cms_frontusers where identifiant = "m.charvet16" 
 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 = "17373" 
 select * from cotisations where identifiant = "m.charvet16" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 195246
payment_means : VISA
transmission_date : 20161203185246
payment_time : 195354
payment_date : 20161203
response_code : 00
payment_certificate : d6bcff78af36
authorisation_id : 329315
currency_code : 978
card_number : 4972.23
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : m.charvet16
order_id : 17373
customer_email : m.charvet16@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 = "17375" 
select * from cms_frontusers where identifiant = "f.etchebarne13" 
 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 = "17375" 
 select * from cotisations where identifiant = "f.etchebarne13" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204549
payment_means : MASTERCARD
transmission_date : 20161203194549
payment_time : 204745
payment_date : 20161203
response_code : 00
payment_certificate : 93a6a578f226
authorisation_id : 826357
currency_code : 978
card_number : 5137.22
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.etchebarne13
order_id : 17375
customer_email : f.etchebarne13@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17376" 
select * from cms_frontusers where identifiant = "f.etchebarne13" 
 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 = "17376" 
 select * from cotisations where identifiant = "m.grandidier27" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204902
payment_means : MASTERCARD
transmission_date : 20161203194902
payment_time : 205229
payment_date : 20161203
response_code : 00
payment_certificate : 49e4b828c016
authorisation_id : 581216
currency_code : 978
card_number : 5137.22
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.etchebarne13
order_id : 17376
customer_email : f.etchebarne13@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 205900
payment_means : VISA
transmission_date : 20161203195900
payment_time : 210238
payment_date : 20161203
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4562.67
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : j.piret26
order_id : 17377
customer_email : j.piret26@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "17378" 
select * from cms_frontusers where identifiant = "v.starikov04" 
 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 = "17378" 
 select * from cotisations where identifiant = "v.starikov04" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 221431
payment_means : VISA
transmission_date : 20161203211431
payment_time : 221615
payment_date : 20161203
response_code : 00
payment_certificate : 6088d3d9db36
authorisation_id : 754117
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 : v.starikov04
order_id : 17378
customer_email : v.starikov04@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 : 
-------------------------------------------