SELECT distinct  @a:=(if( (h.dateDebPeriode < h.dateFinPeriode and DATE_ADD(h.dateFinPeriode,INTERVAL 1 DAY) < DATE_SUB(dateReelle,INTERVAL 1
			HOUR))or(h.dateDebPeriode>DATE_SUB(dateReelle,INTERVAL 1 HOUR)),h.GMT_hivers,h.GMT_ete)) as dc1,
			@b:=(if( (h2.dateDebPeriode<h2.dateFinPeriode and DATE_ADD(h2.dateFinPeriode, INTERVAL 1 DAY)<DATE_SUB(dateReelle,INTERVAL 1
			HOUR))or(h2.dateDebPeriode>DATE_SUB(dateReelle,INTERVAL 1 HOUR)),h2.GMT_hivers,h2.GMT_ete)) as dc2,
			@c:=DATE_ADD(DATE_ADD(DATE_ADD(date_diffusion,INTERVAL if(heure_debutGMT<4,1,0) DAY), INTERVAL heure_debutGMT HOUR), INTERVAL minute_debutGMT MINUTE) as hP,
			DATE_ADD(DATE_SUB(@c,INTERVAL (60*ROUND(@b/100)+MOD(@b,100)) MINUTE),INTERVAL (60*ROUND(@a/100)+MOD(@a,100)) MINUTE) as hLoc,
			emissionFR.num_episode, generiqueFR.nb_episode, emissionFR.id_csa as id_csa, emissionFR.id_partenaire as 
			id_partenaire, emissionFR.titre as et1, emissionFR.description as ed1, generiqueFR.titre as gt1, 
			generiqueFR.description as gd1, themeGene.nom as themeG, themeEmi.nom as themeE, 
			generiqueFR.id_theme as TG, emissionFR.id_theme AS TE, emissionFR.id_FR, diffusion.id,
			emissionFR.bande_annonce aba, generiqueFR.bande_annonce gba, generiqueFR.id_FR gid_FR, 
			emissionFR.image eimage, generiqueFR.image gimage FROM (a_voir, diffusion, onlinefiche as emissionFR, horaires h, zone z, horaires h2, zone z2) 
				left join pays pays2 on z2.idPays=pays2.id inner join villes villes2 on villes2.idPays=pays2.id and villes2.idZone=z2.id
				LEFT JOIN onlinefiche as generiqueFR ON emissionFR.id_generique=generiqueFR.id_FR and generiqueFR.id_version='1' 
				 LEFT JOIN theme as themeGene ON generiqueFR.id_theme=themeGene.id 
			 	LEFT JOIN theme AS themeEmi ON emissionFR.id_theme = themeEmi.id WHERE a_voir.id_fiche=emissionFR.id_FR AND diffusion.id_fiche = emissionFR.id AND
			 z.idHoraire=h.id and z.id=73 and  
			villes2.id=474 and z2.idHoraire=h2.id and
			diffusion.id_signal= and emissionFR.id_version='1'
			AND dateReelle BETWEEN '2008-09-07 02:00:00' AND '2008-09-14 01:59:59'  
			AND dateReelle NOT BETWEEN '2008-09-07 02:00:00' AND '2008-09-08 01:59:59'  
			ORDER BY diffusion.dateReelle You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and emissionFR.id_version='1'
			AND dateReelle BETWEEN '2008-09-07 02:00:00' A' at line 19