select 
  e 
from 
  Product as e 
  left outer join e.productCharacteristicValueList as join_0 
  left outer join join_0.characteristicValue as join_1 
  left outer join join_1.id as join_2 
where 
  (
    (
      (
        e.id = : alias_1 
        or e.id = : alias_2 
        or e.id = : alias_3 
        or upper(e.name) like upper(: alias_4) escape '|'
      )
    ) 
    and e.organization in (
      '102D0E6D37DA46C3BABA6DFF3708F341', 
      '14B1927026BE471E9B85FE699BCA61C2', 
      '4399136852B145BD96CC2A6CE0800C68', 
      'D270A5AC50874F8BA67A88EE977F8E3B', 
      '0', '3B187EC130A549A7A9388F8060EF156D', 
      '65C1C46FB1D04CBD98CBD4167CCFE600', 
      '687AD71263F94A31B85A3CC9942FF7ED', 
      '67839EEFA49E44AC969BD60093FCC899', 
      'B5DE96143D6642228E3B9DEC69886A47', 
      'CCAAD77DA7994401A9657F04AEB6342E', 
      'DF86640764AA4492AB6D4CA2D432B8D4', 
      '01AD882EFC8545ACA6455E2F6FD51EE9', 
      'BF129721D9FB4EB0819509934153E972', 
      'E2A8087A81F54203969C6AED1AABBC72'
    )
  ) 
  and e.client.id in (: _dal_readableClients_dal_) 
  and e.active = 'Y' 
order by 
  e.searchKey, 
  e.id