Zeug

select distinct a.obj_id as obj_id 
  from obj_date a 
  join obj_date b on a.obj_id = b.obj_id
    where a.field_id = 8 
      and b.field_id = 7
      and a.obj_type=-17
      and (a.date_value >= '04.10.2007' or b.date_value >= '04.10.2007')
      and (
        (b.date_value >= '04.10.2007' and b.date_value <= DATEADD("d",4,'04.10.2007'))
        or
        (a.date_value >= '04.10.2007' and a.date_value <= DATEADD("d",4,'04.10.2007'))
      )
union
select i.obj_id from obj_int i 
  join obj_date d on i.obj_id = d.obj_id
  where i.int_value = 1 
   and i.obj_type = -17
   and d.obj_type = -17
   and i.version_id = 0
   and d.version_id = 0
   and i.field_id = 5
   and d.field_id in (7,8)
   and d.date_value >= '04.10.2007'