• Hi

    I may be wrong, but I can't see a reason for this join

    left outer join v_GS_CCM_RECENTLY_USED_APPS d1

    on b1.ResourceID = d1.ResourceID

    and b1.GroupID = d1.GroupID