USP_DATALIST_TASKGROUPTASKS

                    CREATE procedure dbo.USP_DATALIST_TASKGROUPTASKS
                    (
                    @SiteTasksGroup bit
                    )
                    as
                        set nocount on;

                        select t.Name, t.ParentID, t.Seq, t.Guid, t.SiteTasksGroup, t.ID, t.OverridingGuid
                        from dbo.ApplicationTasks t
                        left join dbo.INSTALLEDPRODUCTLIST ipl
                        on ipl.ID = t.Flag
                        where (ipl.ID is not null or t.Flag is null) and SiteTasksGroup = @SiteTasksGroup
                order by t.Seq