select distinct z.* from zakaznik z join rezervace r on r.idz = z.id join lod l on l.id = r.idl where l.barva = 'zelena';