Select
					MI.MarkupItemID
					,@FlowInstanceID
					,@ReviewCycle
					,@GroupName
					,U.UserID
					,M.MarkupName
					,MI.MarkupItemName
					,MI.MarkupItemText
					,@PartialURL + '/' + F.PublishURL + '/' + F.[FileName] + '.jpg'
					,@FullURL + '/ActiveXViewer.aspx?FileID=' + CAST(m.FileID AS varchar)
					,F.FileName
					,@PartialURL + '/' + F.PublishURL   + '/' + 'Markups' + '/' + 'MarkupItem' + MI.MarkupItemImage
					,@PartialURL + '/' + F.PublishURL   + '/' + 'Markups' + '/' + 'Thumb' + MI.MarkupItemImage
					,F.FileID
					,@FullURL + '/ActiveXViewer.aspx?FileID=' + CAST(m.FileID AS varchar) + '&MarkupID=' + CAST(m.MarkupID AS varchar)
					,'No'
					From MarkupItems MI
					Left Join Markups M on MI.MarkupID = M.MarkupID
					Left Join Users U on MI.UpdatedBy = U.UserID
					Left Join Files F on M.FileID = F.FileID
					Join Projects P on F.ProjectID = P.ProjectID
					WHERE
					MI.MarkupItemType = 'Changemark'
                    AND MI.MarkupItemImage <> ''
					AND U.Email = @Reviewer
					AND P.Name = @PermitNumber
					AND MI.MarkupItemID NOT IN (Select isnull(ChangeMarkID,0) from SelectedChangeMarks)