Unknown column 'z.deadline_expedice' in 'field list' : UPDATE
					prefix_zbozi AS z,
					prefix_dostupnosti AS d
				SET
					z.skladem = d.dostupnost,
					z.dostupnost_seznam = d.exporty,
					z.deadline_expedice = d.deadline_expedice,
					z.presun_odberne_misto = d.presun_odberne_misto,
					z.aktivni = IF (d.aktivni!='', d.aktivni, z.aktivni),
					z.zakazat_nakup = IF (d.zakazat_nakup!='', d.zakazat_nakup, z.zakazat_nakup),
					z.zakazat_export = IF (d.zakazat_export!='', d.zakazat_export, z.zakazat_export)
				WHERE
                    
					z.id_obchodu='3919'
					AND
					d.id_obchodu='3919'

					AND
					z.sklad >= d.sklad_od
					AND
					z.sklad <= d.sklad_do

					AND
					z.sklad_dodavatel >= d.dodavatel_sklad_od
					AND
					z.sklad_dodavatel <= d.dodavatel_sklad_do

					AND (
						( d.nakupni_cena_od = 0 AND d.nakupni_cena_do = 0 )
						OR
						( z.cena_nakupni >= d.nakupni_cena_od AND z.cena_nakupni <= d.nakupni_cena_do )
					)

					AND
					z.dostupnosti_podle_skladu='y'
					AND
					
					( d.dodavatel=z.dodavatel OR d.dodavatel IS NULL OR d.dodavatel='' )
					AND
					( d.vyrobce=z.vyrobce OR d.vyrobce IS NULL OR d.vyrobce='' )
        
					 AND z.id='8996470709922'