Třídová akce

Kód:

2

Tělo:

Select 
  SL.ID 
from 
  StoreCardMenuItemLinks SL 
where
  ( 
    (SL.StoreMenuItem_ID = :StoreMenuItem_ID) OR 
    (
      (:WithChildren = 'A') AND (SL.StoreMenuItem_ID IN (Select SM2.ID from SYS$StoreMenu2 SM2 where SM2.Superior_ID = :StoreMenuItem_ID))
    )
  ) and 
  (SL.StoreCard_ID IN (Select SC.ID from StoreCards SC where SC.Hidden='N'))

Generated by ABRA Software a.s. 27.10.2021 16:34:11