select 'acceptés gmail' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@gmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés msn' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@msn.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés orange' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@orange.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés laposte' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@laposte.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés hotmail' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@hotmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés live' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@live.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés wanadoo' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés aol' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@aol.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés autres' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email not like '%@aol.%'
and coregistration_affichage_email not like '%@gmail.%'
and coregistration_affichage_email not like '%@hotmail.%'
and coregistration_affichage_email not like '%@laposte.%'
and coregistration_affichage_email not like '%@live.%'
and coregistration_affichage_email not like '%@msn.%'
and coregistration_affichage_email not like '%@orange.%'
and coregistration_affichage_email not like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés gmail', count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@gmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés msn' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@msn.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés orange' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@orange.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés laposte' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@laposte.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés hotmail' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@hotmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés live' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@live.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés wanadoo' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés aol' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@aol.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés autres' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email not like '%@aol.%'
and coregistration_affichage_email not like '%@gmail.%'
and coregistration_affichage_email not like '%@hotmail.%'
and coregistration_affichage_email not like '%@laposte.%'
and coregistration_affichage_email not like '%@live.%'
and coregistration_affichage_email not like '%@msn.%'
and coregistration_affichage_email not like '%@orange.%'
and coregistration_affichage_email not like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35;

select 'acceptés gmail' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@gmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés msn' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@msn.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés orange' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@orange.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés laposte' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@laposte.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés hotmail' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@hotmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés live' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@live.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés wanadoo' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés aol' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@aol.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'acceptés autres' as FAI, count(*) from
export_auto e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email not like '%@aol.%'
and coregistration_affichage_email not like '%@gmail.%'
and coregistration_affichage_email not like '%@hotmail.%'
and coregistration_affichage_email not like '%@laposte.%'
and coregistration_affichage_email not like '%@live.%'
and coregistration_affichage_email not like '%@msn.%'
and coregistration_affichage_email not like '%@orange.%'
and coregistration_affichage_email not like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés gmail', count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@gmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés msn' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@msn.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés orange' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@orange.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés laposte' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@laposte.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés hotmail' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@hotmail.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés live' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@live.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés wanadoo' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés aol' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email like '%@aol.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35
union
select 'rejetés autres' as FAI, count(*) from
export_auto_rejetes e
join coregistration_affichage c on c.coregistration_affichage_id = e.export_auto_rejetes_affichage
join coregistration co on co.coregistration_coregistration_affichage = c.coregistration_affichage_id
where coregistration_affichage_campagne_annonceur = 17
and coregistration_affichage_date > '2012-01-01' 
and coregistration_affichage_date < '2012-02-01'
and coregistration_affichage_campagne_affilie not in (8,9,10,11,12,13,14,15,28,29,30,31,32,33,34,35)
and coregistration_affichage_email not like '%@aol.%'
and coregistration_affichage_email not like '%@gmail.%'
and coregistration_affichage_email not like '%@hotmail.%'
and coregistration_affichage_email not like '%@laposte.%'
and coregistration_affichage_email not like '%@live.%'
and coregistration_affichage_email not like '%@msn.%'
and coregistration_affichage_email not like '%@orange.%'
and coregistration_affichage_email not like '%@wanadoo.%'
and coregistration_champ = 12
and (2011 - cast((substring(coregistration_valeur from 0 for 5)) as integer )) >= 35;