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