SELECT v.code_vari ,v.libe_vari,c.surf ,ea.code_acti,a.libe_acti, p.code_unit_affi, c.dens_bass,ea.code_cult,c.libe_cult
	FROM elem_acti_produit ea, culture c,activite a , produit p, unite_affichage u, variete v
		WHERE ea.code_prod=p.code_prod and
				date_heur_debu>='20190701 00:00:00' and
				date_heur_debu<='20190731 23:59:59' and
				v.code_vari=c.code_vari and
				ea.code_cult=c.code_cult and
				ea.code_acti=a.code_acti and
				a.flag_reco='O'  and
				v.code_vari in ('CDP','CLOD','LUMI','ORAN','RUBIS','TGP','TORI',' ') and
				p.code_cate_prod in (1,2,3,4)
			group by v.code_vari,v.libe_vari,c.surf ,ea.code_acti,a.libe_acti, p.code_unit_affi, c.dens_bass,ea.code_cult,c.libe_cult