knekrasov

select o.objectId from objects o
where not exists (
  select * from 
    object_category oc  
    join device_category dc on oc.categoryId = dc.deviceCat
    where dc.deviceId = 1 
      and o.objectId = oc.objectId
)