Scene URL Concatenate Stiched Images

WITH UniqueImages AS (SELECT 
        a.Client,a.SessionUid,a.SceneUid,a.ImageRecognitionStatusRejectedText AS "Manual SubStatus",a.IrUserName AS "Username",a.CreatedOn,
        CONVERT(VARCHAR(8), a.PurityDateTime, 112) AS "PurityDateTime",a.ImageStoragePath,a.ImageName AS "AssetImageName",
        'https://portal.visioniot.net/SessionIRSurveyImages.ashx?' + 'in=' + a.ImageName + '&ImageStoragePath=' + b.ImageStoragePath AS "Image URL",
        ROW_NUMBER() OVER (PARTITION BY a.ImageName ORDER BY a.CreatedOn) AS RowNum 
    FROM vwAssetPurityList a
    INNER JOIN vwAssetPurityImageList b WITH (NOLOCK) ON a.AssetPurityId = b.AssetPurityId
    WHERE a.ClientId = '459'AND a.CreatedOn >= '2025-01-01' AND a.ImageRecognitionStatusRejectedText <> '')
SELECT 
    Client,SessionUid,SceneUid,"Manual SubStatus","Username",CreatedOn,"PurityDateTime",ImageStoragePath,AssetImageName,"Image URL"
FROM UniqueImages WHERE RowNum = 1 ORDER BY SessionUid ASC;

--------------------------------------------------