select * from cotisations_commande where id = "12944" 
select * from cms_frontusers where identifiant = "e.brondel05" 
 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 = "12944" 
 select * from cotisations where identifiant = "g.lacan31" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 070009
payment_means : VISA
transmission_date : 20160119060009
payment_time : 071109
payment_date : 20160119
response_code : 00
payment_certificate : c9eda1629cce
authorisation_id : 531252
currency_code : 978
card_number : 4972.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 : e.brondel05
order_id : 12944
customer_email : e.brondel05@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201710
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12945" 
select * from cms_frontusers where identifiant = "f.martin17" 
 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 = "12945" 
 select * from cotisations where identifiant = "f.martin17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 080603
payment_means : VISA
transmission_date : 20160119070603
payment_time : 081030
payment_date : 20160119
response_code : 00
payment_certificate : 18b63de3488d
authorisation_id : 037407
currency_code : 978
card_number : 4284.84
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.martin17
order_id : 12945
customer_email : f.martin17@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12946" 
select * from cms_frontusers where identifiant = "m.gendreau05" 
 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 = "12946" 
 select * from cotisations where identifiant = "m.gendreau05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 085712
payment_means : MASTERCARD
transmission_date : 20160119075712
payment_time : 085820
payment_date : 20160119
response_code : 00
payment_certificate : d93e2c85e3d4
authorisation_id : 768155
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 : m.gendreau05
order_id : 12946
customer_email : m.gendreau05@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 = "12948" 
select * from cms_frontusers where identifiant = "r.delabrosse24" 
 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 = "12948" 
 select * from cotisations where identifiant = "r.delabrosse24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 130125
payment_means : VISA
transmission_date : 20160119120125
payment_time : 130221
payment_date : 20160119
response_code : 00
payment_certificate : e8c5aa1c37e5
authorisation_id : 231429
currency_code : 978
card_number : 4970.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 : r.delabrosse24
order_id : 12948
customer_email : r.delabrosse24@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 : 201702
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 : 135229
payment_means : MASTERCARD
transmission_date : 20160119125229
payment_time : 135400
payment_date : 20160119
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5134.10
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.bahuon24
order_id : 12949
customer_email : l.bahuon24@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 : 201601
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12950" 
select * from cms_frontusers where identifiant = "p.rebillard03" 
 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 = "12950" 
 select * from cotisations where identifiant = "p.rebillard03" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 141013
payment_means : VISA
transmission_date : 20160119131013
payment_time : 141211
payment_date : 20160119
response_code : 00
payment_certificate : 7833e14a6057
authorisation_id : 733162
currency_code : 978
card_number : 4975.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 : p.rebillard03
order_id : 12950
customer_email : p.rebillard03@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 = "12951" 
select * from cms_frontusers where identifiant = "a.jung14" 
 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 = "12951" 
 select * from cotisations where identifiant = "a.jung14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 144102
payment_means : VISA
transmission_date : 20160119134102
payment_time : 144509
payment_date : 20160119
response_code : 00
payment_certificate : 2222edbc2290
authorisation_id : 424319
currency_code : 978
card_number : 4977.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 : a.jung14
order_id : 12951
customer_email : a.jung14@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 = "12952" 
select * from cms_frontusers where identifiant = "g.goy20" 
 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 = "12952" 
 select * from cotisations where identifiant = "jr.gallet24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 144641
payment_means : MASTERCARD
transmission_date : 20160119134641
payment_time : 144839
payment_date : 20160119
response_code : 00
payment_certificate : 25c097a5c907
authorisation_id : 772666
currency_code : 978
card_number : 5131.70
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.goy20
order_id : 12952
customer_email : g.goy20@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 = "12953" 
select * from cms_frontusers where identifiant = "c.boquet19" 
 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 = "12953" 
 select * from cotisations where identifiant = "c.boquet19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 152555
payment_means : VISA
transmission_date : 20160119142555
payment_time : 152846
payment_date : 20160119
response_code : 00
payment_certificate : f0f37eb25632
authorisation_id : 313111
currency_code : 978
card_number : 4975.08
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.boquet19
order_id : 12953
customer_email : c.boquet19@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 : 4000
transaction_id : 153759
payment_means : CB
transmission_date : 20160119143759
payment_time : 153918
payment_date : 20160119
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.10
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 41
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : a.demond16
order_id : 12954
customer_email : a.demond16@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_ERROR
statement_reference : 
card_validity : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12958" 
select * from cms_frontusers where identifiant = "a.ludwig16" 
 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 = "12958" 
 select * from cotisations where identifiant = "a.ludwig16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 175139
payment_means : MASTERCARD
transmission_date : 20160119165139
payment_time : 175402
payment_date : 20160119
response_code : 00
payment_certificate : f58992ec9e04
authorisation_id : 118963
currency_code : 978
card_number : 5132.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 : a.ludwig16
order_id : 12958
customer_email : a.ludwig16@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201610
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12961" 
select * from cms_frontusers where identifiant = "s.dasilva13" 
 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 = "12961" 
 select * from cotisations where identifiant = "s.dasilva13" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 175252
payment_means : VISA
transmission_date : 20160119165252
payment_time : 175426
payment_date : 20160119
response_code : 00
payment_certificate : 67a61a574da7
authorisation_id : 251425
currency_code : 978
card_number : 4978.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 : s.dasilva13
order_id : 12961
customer_email : s.dasilva13@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 = "12959" 
select * from cms_frontusers where identifiant = "y.couliou24" 
 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 = "12959" 
 select * from cotisations where identifiant = "y.couliou24" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "y.couliou24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 175219
payment_means : VISA
transmission_date : 20160119165219
payment_time : 175509
payment_date : 20160119
response_code : 00
payment_certificate : 97efaa41e98d
authorisation_id : 781661
currency_code : 978
card_number : 4533.08
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.couliou24
order_id : 12959
customer_email : y.couliou24@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 : 175230
payment_means : MASTERCARD
transmission_date : 20160119165230
payment_time : 175546
payment_date : 20160119
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.65
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 : m.charlier26
order_id : 12960
customer_email : m.charlier26@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 : 201712
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12962" 
select * from cms_frontusers where identifiant = "g.cadoret15" 
 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 = "12962" 
 select * from cotisations where identifiant = "g.cadoret15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 175939
payment_means : VISA
transmission_date : 20160119165939
payment_time : 180231
payment_date : 20160119
response_code : 00
payment_certificate : 469cfa014b60
authorisation_id : 143668
currency_code : 978
card_number : 4976.91
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.cadoret15
order_id : 12962
customer_email : g.cadoret15@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 = "12965" 
select * from cms_frontusers where identifiant = "f.choletais05" 
 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 = "12965" 
 select * from cotisations where identifiant = "j.bories17" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 181816
payment_means : VISA
transmission_date : 20160119171816
payment_time : 181941
payment_date : 20160119
response_code : 00
payment_certificate : 21d1a5b20c0a
authorisation_id : 546302
currency_code : 978
card_number : 4975.14
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.choletais05
order_id : 12965
customer_email : f.choletais05@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 = "12966" 
select * from cms_frontusers where identifiant = "c.favere25" 
 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 = "12966" 
 select * from cotisations where identifiant = "c.favere25" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 182148
payment_means : VISA
transmission_date : 20160119172148
payment_time : 182327
payment_date : 20160119
response_code : 00
payment_certificate : b03483d6e430
authorisation_id : 133826
currency_code : 978
card_number : 4978.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.favere25
order_id : 12966
customer_email : c.favere25@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 = "12967" 
select * from cms_frontusers where identifiant = "f.gomez27" 
 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 = "12967" 
 select * from cotisations where identifiant = "p.turgot30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182213
payment_means : MASTERCARD
transmission_date : 20160119172213
payment_time : 182441
payment_date : 20160119
response_code : 00
payment_certificate : b8b9ed7c8489
authorisation_id : 522114
currency_code : 978
card_number : 5135.00
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.gomez27
order_id : 12967
customer_email : f.gomez27@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 = "12969" 
select * from cms_frontusers where identifiant = "m.gabillon20" 
 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 = "12969" 
 select * from cotisations where identifiant = "m.gabillon20" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 183048
payment_means : MASTERCARD
transmission_date : 20160119173048
payment_time : 183225
payment_date : 20160119
response_code : 00
payment_certificate : 81746b74749f
authorisation_id : 523232
currency_code : 978
card_number : 5136.84
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.gabillon20
order_id : 12969
customer_email : m.gabillon20@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 : 182646
payment_means : VISA
transmission_date : 20160119172646
payment_time : 183402
payment_date : 20160119
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.67
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 : m.autret06
order_id : 12968
customer_email : m.autret06@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 : 201602
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12970" 
select * from cms_frontusers where identifiant = "a.chalendar12" 
 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 = "12970" 
 select * from cotisations where identifiant = "a.chalendar12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 183732
payment_means : VISA
transmission_date : 20160119173732
payment_time : 184053
payment_date : 20160119
response_code : 00
payment_certificate : c4deebd98467
authorisation_id : 151408
currency_code : 978
card_number : 4970.84
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.chalendar12
order_id : 12970
customer_email : a.chalendar12@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201710
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12971" 
select * from cms_frontusers where identifiant = "a.haro16" 
 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 = "12971" 
 select * from cotisations where identifiant = "a.haro16" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 184608
payment_means : MASTERCARD
transmission_date : 20160119174608
payment_time : 184752
payment_date : 20160119
response_code : 00
payment_certificate : a2e9932317a5
authorisation_id : 822260
currency_code : 978
card_number : 5132.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 : a.haro16
order_id : 12971
customer_email : a.haro16@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 : 201706
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12972" 
select * from cms_frontusers where identifiant = "d.pekkip11" 
 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 = "12972" 
 select * from cotisations where identifiant = "d.pekkip11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 190418
payment_means : MASTERCARD
transmission_date : 20160119180418
payment_time : 190624
payment_date : 20160119
response_code : 00
payment_certificate : eb02a1aeff0e
authorisation_id : 388993
currency_code : 978
card_number : 5132.79
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : d.pekkip11
order_id : 12972
customer_email : d.pekkip11@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 = "12973" 
select * from cms_frontusers where identifiant = "l.talon07" 
 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 = "12973" 
 select * from cotisations where identifiant = "l.talon07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 192635
payment_means : MASTERCARD
transmission_date : 20160119182635
payment_time : 192806
payment_date : 20160119
response_code : 00
payment_certificate : ef11399b8633
authorisation_id : 624630
currency_code : 978
card_number : 5131.54
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.talon07
order_id : 12973
customer_email : l.talon07@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 = "12974" 
select * from cms_frontusers where identifiant = "n.coutant30" 
 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 = "12974" 
 select * from cotisations where identifiant = "n.coutant30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 193213
payment_means : MASTERCARD
transmission_date : 20160119183213
payment_time : 193446
payment_date : 20160119
response_code : 00
payment_certificate : 50ef870c6fc9
authorisation_id : 214351
currency_code : 978
card_number : 5136.24
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.coutant30
order_id : 12974
customer_email : n.coutant30@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 = "12975" 
select * from cms_frontusers where identifiant = "h.besseiche04" 
 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 = "12975" 
 select * from cotisations where identifiant = "h.besseiche04" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 200752
payment_means : MASTERCARD
transmission_date : 20160119190752
payment_time : 201056
payment_date : 20160119
response_code : 00
payment_certificate : 5a5a3980be86
authorisation_id : 098583
currency_code : 978
card_number : 5132.89
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : h.besseiche04
order_id : 12975
customer_email : h.besseiche04@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201603
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12976" 
select * from cms_frontusers where identifiant = "c.loesacksioe12" 
 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 = "12976" 
 select * from cotisations where identifiant = "c.loesacksioe12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201501
payment_means : VISA
transmission_date : 20160119191501
payment_time : 201723
payment_date : 20160119
response_code : 00
payment_certificate : ba21dd70386e
authorisation_id : 494634
currency_code : 978
card_number : 4974.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 : c.loesacksioe12
order_id : 12976
customer_email : c.loesacksioe12@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 : 201706
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12977" 
select * from cms_frontusers where identifiant = "c.logiez08" 
 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 = "12977" 
 select * from cotisations where identifiant = "c.logiez08" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202629
payment_means : VISA
transmission_date : 20160119192629
payment_time : 202751
payment_date : 20160119
response_code : 00
payment_certificate : 8446a76e570b
authorisation_id : 933579
currency_code : 978
card_number : 4974.35
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : c.logiez08
order_id : 12977
customer_email : c.logiez08@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 = "12978" 
select * from cms_frontusers where identifiant = "p.poitiers24" 
 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 = "12978" 
 select * from cotisations where identifiant = "p.poitiers24" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204651
payment_means : MASTERCARD
transmission_date : 20160119194651
payment_time : 204934
payment_date : 20160119
response_code : 00
payment_certificate : 750d3cea3995
authorisation_id : 495451
currency_code : 978
card_number : 5137.01
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : p.poitiers24
order_id : 12978
customer_email : p.poitiers24@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 = "12980" 
select * from cms_frontusers where identifiant = "m.bardie30" 
 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 = "12980" 
 select * from cotisations where identifiant = "m.bardie30" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 205112
payment_means : MASTERCARD
transmission_date : 20160119195112
payment_time : 205434
payment_date : 20160119
response_code : 00
payment_certificate : cff6b6abd935
authorisation_id : 452713
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 : m.bardie30
order_id : 12980
customer_email : m.bardie30@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 = "12981" 
select * from cms_frontusers where identifiant = "l.dewaele07" 
 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 = "12981" 
 select * from cotisations where identifiant = "l.dewaele07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 205234
payment_means : VISA
transmission_date : 20160119195234
payment_time : 205552
payment_date : 20160119
response_code : 00
payment_certificate : 8b1de17b2a22
authorisation_id : 622136
currency_code : 978
card_number : 4562.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 : l.dewaele07
order_id : 12981
customer_email : l.dewaele07@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 = "12982" 
select * from cms_frontusers where identifiant = "l.szczuczynski13" 
 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 = "12982" 
 select * from cotisations where identifiant = "g.treille02" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 205457
payment_means : VISA
transmission_date : 20160119195457
payment_time : 205634
payment_date : 20160119
response_code : 00
payment_certificate : 25ebcd2ddfdc
authorisation_id : 233721
currency_code : 978
card_number : 4970.07
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : l.szczuczynski13
order_id : 12982
customer_email : l.szczuczynski13@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 : 4000
transaction_id : 210209
payment_means : VISA
transmission_date : 20160119200209
payment_time : 210512
payment_date : 20160119
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.49
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : g.arnal19
order_id : 12984
customer_email : g.arnal19@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 : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12985" 
select * from cms_frontusers where identifiant = "l.lafosse15" 
 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 = "12985" 
 select * from cotisations where identifiant = "l.lafosse15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 210320
payment_means : MASTERCARD
transmission_date : 20160119200320
payment_time : 210541
payment_date : 20160119
response_code : 00
payment_certificate : a12a83649f04
authorisation_id : 180299
currency_code : 978
card_number : 5131.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 : l.lafosse15
order_id : 12985
customer_email : l.lafosse15@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 : 201706
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 : 210529
payment_means : VISA
transmission_date : 20160119200529
payment_time : 200630
payment_date : 20160119
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 : g.arnal19
order_id : 12984
customer_email : g.arnal19@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "12987" 
select * from cms_frontusers where identifiant = "j.berthod14" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "12987" 
 select * from cotisations where identifiant = "j.berthod14" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 210453
payment_means : VISA
transmission_date : 20160119200453
payment_time : 210641
payment_date : 20160119
response_code : 00
payment_certificate : 1c3d0614bcf6
authorisation_id : 201356
currency_code : 978
card_number : 4150.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 : j.berthod14
order_id : 12987
customer_email : j.berthod14@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12988" 
select * from cms_frontusers where identifiant = "a.lefort05" 
 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 = "12988" 
 select * from cotisations where identifiant = "a.lefort05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 210813
payment_means : MASTERCARD
transmission_date : 20160119200813
payment_time : 210951
payment_date : 20160119
response_code : 00
payment_certificate : df1219ce0de4
authorisation_id : 621174
currency_code : 978
card_number : 5131.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 : a.lefort05
order_id : 12988
customer_email : a.lefort05@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 = "12989" 
select * from cms_frontusers where identifiant = "j.berthod14" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "12989" 
 select * from cotisations where identifiant = "e.mendiburu05" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211333
payment_means : VISA
transmission_date : 20160119201333
payment_time : 211540
payment_date : 20160119
response_code : 00
payment_certificate : e69fbbd7804b
authorisation_id : 109151
currency_code : 978
card_number : 4150.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 : j.berthod14
order_id : 12989
customer_email : j.berthod14@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12990" 
select * from cms_frontusers where identifiant = "s.petit15" 
 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 = "12990" 
 select * from cotisations where identifiant = "s.petit15" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211928
payment_means : MASTERCARD
transmission_date : 20160119201928
payment_time : 212202
payment_date : 20160119
response_code : 00
payment_certificate : 157b14f514aa
authorisation_id : 464306
currency_code : 978
card_number : 5131.06
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : s.petit15
order_id : 12990
customer_email : s.petit15@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 = "12991" 
select * from cms_frontusers where identifiant = "m.gouedart19" 
 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 = "12991" 
 select * from cotisations where identifiant = "m.gouedart19" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 212201
payment_means : MASTERCARD
transmission_date : 20160119202201
payment_time : 212324
payment_date : 20160119
response_code : 00
payment_certificate : dae127ba0cbb
authorisation_id : 136243
currency_code : 978
card_number : 5131.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.gouedart19
order_id : 12991
customer_email : m.gouedart19@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 = "12993" 
select * from cms_frontusers where identifiant = "j.berthod14" 
 select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L
						left outer join cms_frontusers U on U.identifiant = L.identifiant
						where id_commande = "12993" 
 select * from cotisations where identifiant = "a.marulier26" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212348
payment_means : VISA
transmission_date : 20160119202348
payment_time : 212533
payment_date : 20160119
response_code : 00
payment_certificate : 3b45228b67b0
authorisation_id : 365395
currency_code : 978
card_number : 4150.89
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : j.berthod14
order_id : 12993
customer_email : j.berthod14@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12992" 
select * from cms_frontusers where identifiant = "m.kowalzyk11" 
 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 = "12992" 
 select * from cotisations where identifiant = "m.kowalzyk11" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212253
payment_means : MASTERCARD
transmission_date : 20160119202253
payment_time : 212634
payment_date : 20160119
response_code : 00
payment_certificate : ff00ba01f4f0
authorisation_id : 979656
currency_code : 978
card_number : 5136.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 : m.kowalzyk11
order_id : 12992
customer_email : m.kowalzyk11@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201610
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "12994" 
select * from cms_frontusers where identifiant = "gp.schwartz31" 
 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 = "12994" 
 select * from cotisations where identifiant = "gp.schwartz31" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 223838
payment_means : VISA
transmission_date : 20160119213838
payment_time : 224029
payment_date : 20160119
response_code : 00
payment_certificate : 66cc2cadddc4
authorisation_id : 563774
currency_code : 978
card_number : 4973.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 : gp.schwartz31
order_id : 12994
customer_email : gp.schwartz31@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 = "12995" 
select * from cms_frontusers where identifiant = "x.rocher23" 
 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 = "12995" 
 select * from cotisations where identifiant = "x.rocher23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 225117
payment_means : VISA
transmission_date : 20160119215117
payment_time : 225506
payment_date : 20160119
response_code : 00
payment_certificate : c7fb5a70e762
authorisation_id : 530956
currency_code : 978
card_number : 4977.43
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.rocher23
order_id : 12995
customer_email : x.rocher23@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 = "12996" 
select * from cms_frontusers where identifiant = "p.soula06" 
 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 = "12996" 
 select * from cotisations where identifiant = "p.soula06" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 225652
payment_means : VISA
transmission_date : 20160119215652
payment_time : 225828
payment_date : 20160119
response_code : 00
payment_certificate : 085a7d9aedfc
authorisation_id : 641522
currency_code : 978
card_number : 4970.62
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.soula06
order_id : 12996
customer_email : p.soula06@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 = "12997" 
select * from cms_frontusers where identifiant = "k.damour12" 
 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 = "12997" 
 select * from cotisations where identifiant = "k.damour12" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 231914
payment_means : MASTERCARD
transmission_date : 20160119221914
payment_time : 232231
payment_date : 20160119
response_code : 00
payment_certificate : 470a5ddd0b72
authorisation_id : 322666
currency_code : 978
card_number : 5136.57
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 : k.damour12
order_id : 12997
customer_email : k.damour12@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 : 
-------------------------------------------