DECLARE @BusinessTemplateID INT = 215
DECLARE @SourceGroupID INT = 4772

SELECT    *
FROM      tblCommunities
WHERE     @SourceGroupID = [tblCommunities].[groupid]
          AND ( IsDeleted = 0 OR IsDeleted IS NULL)
    AND CommunityID IN (
        SELECT CommunityID
        FROM tblBusinessTemplateCommunity
        WHERE BusinessTemplateID = @BusinessTemplateID
    )