---------------------------------------
-- On sort les données a envoyer a cdiscount
---------------------------------------
/*
select 1 as 'Cdiscount', 0 as 'Ventes privées', 0 as 'Partenaire', 'Prospects_FLInteractive' as "Mode d'adhésion", date_format(now(), '%d/%m/%Y') as 'Date du prospect', 0 as 'Vérif NPAI', case when civilite = 'monsieur' then 'M.' when civilite = 'madame' then 'Mme' when civilite = 'mademoiselle' then 'Mlle' end as 'Civilité', nom as 'Nom', prenom as 'Prénom', case when date_naissance = '0000-00-00' then '01/01/1900' else date_format(date_naissance, '%d/%m/%Y') end as 'Date de naissance', replace(adresse, "\r", "") as 'adresse 1', '' as 'adresse 2', code_postal as 'CP', ville as 'Ville', email as 'Adresse mail', 0 as 'Numéro de téléphone', 0 as 'Numéro de mobile'
from joueur j

-- recup ds lignes de cette ope
inner join export_auto e on e.id_joueur = j.id and client = 'cdiscount' and operation_client = date_format(now(), '%d%m%Y') and etat = 0

where pays = 3
and length(code_postal) between 4 and 5 
and code_postal REGEXP ('[0-9]{4,5}')
and code_postal != ville;
*/


select 1 as 'Cdiscount', 0 as 'Ventes privées', 0 as 'Partenaire', 'Prospects_FLInteractive' as "Mode d'adhésion", date_format(now(), '%d/%m/%Y') as 'Date du prospect', 0 as 'Vérif NPAI', case when civilite = 'monsieur' then 'M.' when civilite = 'madame' then 'Mme' when civilite = 'mademoiselle' then 'Mlle' end as 'Civilité', nom as 'Nom', prenom as 'Prénom', '' as 'Date de naissance', '' as 'adresse 1', '' as 'adresse 2', '' as 'CP', '' as 'Ville', email as 'Adresse mail', 0 as 'Numéro de téléphone', 0 as 'Numéro de mobile'
from joueur j

-- recup ds lignes de cette ope
inner join export_auto e on e.id_joueur = j.id and client = 'cdiscount' and operation_client = date_format(now(), '%d%m%Y') and etat = 0

and nom != email
and prenom != email;