Select Count(SL.ID) from StoreCardMenuItemLinks SL left join StoreCards SC on (SL.StoreCard_ID = SC.ID) where (SL.StoreMenuItem_ID = SC.StoreMenuItem_ID) AND ((SL.StoreMenuItem_ID = :StoreMenuItem_ID) or ((:WithChildren = 'A') AND (SL.StoreMenuItem_ID in (Select SM2.ID from SYS$StoreMenu2 SM2 where Superior_ID = :StoreMenuItem_ID))))
Generated by ABRA Software a.s. 27.10.2021 16:34:11