PHP Warning:  pg_query(): Query failed: ERREUR:  syntaxe en entrée invalide pour l'entier : « 24/0 » in /home/servers/scripts/export_auto/modanoo/script_export_fichier_kalifoo.php on line 256
PHP Warning:  pg_fetch_row() expects parameter 1 to be resource, boolean given in /home/servers/scripts/export_auto/modanoo/script_export_fichier_kalifoo.php on line 260
wc: /var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-09.csv: Aucun fichier ou dossier de ce type
Impossible d'obtenir le statut de /var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-09.csv : Aucun fichier ou dossier de ce type
/var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-09.csv : impossible d'attacher le fichier.


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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-16 00:00:00'
and coregistration_affichage_campagne_affilie 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;
PHP Warning:  pg_query(): Query failed: ERREUR:  syntaxe en entrée invalide pour l'entier : « 15/0 » in /home/servers/scripts/export_auto/modanoo/script_export_fichier_kalifoo.php on line 255
PHP Warning:  pg_fetch_row() expects parameter 1 to be resource, boolean given in /home/servers/scripts/export_auto/modanoo/script_export_fichier_kalifoo.php on line 259
wc: /var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-16.csv: Aucun fichier ou dossier de ce type
Impossible d'obtenir le statut de /var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-16.csv : Aucun fichier ou dossier de ce type
/var/scripts/export_auto/modanoo/modanoo_kalifoo_2012-01-16.csv : impossible d'attacher le fichier.



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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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 00:00:00' 
and coregistration_affichage_date < '2012-01-23 00:00:00'
and coregistration_affichage_campagne_affilie 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;
PHP Parse error:  syntax error, unexpected T_VARIABLE in /home/servers/scripts/export_auto/modanoo/script_export_fichier_kalifoo.php on line 254