monolighter

(
  select *
  from `entity`
  where
      `id` = 1 
  and `subid` not in (3, 2, 1) 
  
) union all (
  select *
  from `entity`