select * from cotisations_commande where id = "7423" 
select * from cms_frontusers where identifiant = "f.dandoy11" 
 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 = "7423" 
 select * from cotisations where identifiant = "f.dandoy11" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "f.dandoy11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 104837
payment_means : MASTERCARD
transmission_date : 20150918084837
payment_time : 105033
payment_date : 20150918
response_code : 00
payment_certificate : b053ab006ff4
authorisation_id : 948695
currency_code : 978
card_number : 5131.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 : f.dandoy11
order_id : 7423
customer_email : f.dandoy11@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201509
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "7424" 
select * from cms_frontusers where identifiant = "t.baudet17" 
 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 = "7424" 
 select * from cotisations where identifiant = "t.baudet17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 115853
payment_means : VISA
transmission_date : 20150918095853
payment_time : 120215
payment_date : 20150918
response_code : 00
payment_certificate : 26205cf6e0e9
authorisation_id : 636810
currency_code : 978
card_number : 4970.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 : t.baudet17
order_id : 7424
customer_email : t.baudet17@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 141054
payment_means : MASTERCARD
transmission_date : 20150918121054
payment_time : 141146
payment_date : 20150918
response_code : 12
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.59
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 12
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.dumont09
order_id : 7425
customer_email : t.dumont09@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_ATTEMPT
statement_reference : 
card_validity : 201606
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 : 153720
payment_means : MASTERCARD
transmission_date : 20150918133720
payment_time : 153906
payment_date : 20150918
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5294.98
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 : e.charra06
order_id : 7426
customer_email : e.charra06@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 : 201703
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "7427" 
select * from cms_frontusers where identifiant = "e.charra06" 
 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 = "7427" 
 select * from cotisations where identifiant = "e.charra06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153942
payment_means : MASTERCARD
transmission_date : 20150918133942
payment_time : 154102
payment_date : 20150918
response_code : 00
payment_certificate : cb5c3f004a6a
authorisation_id : 411161
currency_code : 978
card_number : 5131.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 : e.charra06
order_id : 7427
customer_email : e.charra06@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201710
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 162225
payment_means : MASTERCARD
transmission_date : 20150918142225
payment_time : 163651
payment_date : 20150918
response_code : 12
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5136.60
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 12
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.dumas20
order_id : 7428
customer_email : t.dumas20@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_ATTEMPT
statement_reference : 
card_validity : 201609
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "7432" 
select * from cms_frontusers where identifiant = "r.vanrenterghem30" 
 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 = "7432" 
 select * from cotisations where identifiant = "r.vanrenterghem30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201128
payment_means : VISA
transmission_date : 20150918181128
payment_time : 201449
payment_date : 20150918
response_code : 00
payment_certificate : c4b1f0a39931
authorisation_id : 502432
currency_code : 978
card_number : 4562.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 : r.vanrenterghem30
order_id : 7432
customer_email : r.vanrenterghem30@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 = "7433" 
select * from cms_frontusers where identifiant = "jb.girard21" 
 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 = "7433" 
 select * from cotisations where identifiant = "jb.girard21" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 204610
payment_means : VISA
transmission_date : 20150918184610
payment_time : 204728
payment_date : 20150918
response_code : 00
payment_certificate : 2f43ca895a39
authorisation_id : 455472
currency_code : 978
card_number : 4975.17
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : jb.girard21
order_id : 7433
customer_email : jb.girard21@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 204954
payment_means : CB
transmission_date : 20150918184954
payment_time : 205315
payment_date : 20150918
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.39
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 : l.goudier06
order_id : 7434
customer_email : l.goudier06@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 : 201610
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------