Product images URL's

SELECT  
    'https://portal.visioniot.net/Controllers/ProductImagePreview.ashx?productId=' 
    + CAST(a.productid AS VARCHAR) 
    + '&storefileName=' + a.filename + '_' + CAST(a.ProductId AS VARCHAR) AS "Image URL",
    a.ProductId,
    b.SKU,
    b.Manufacturer,
    a.FacingName,
    a.Filename,
    a.ProductImageId,
    b.IsThumbnailImage
FROM vwProductImageList a WITH (NOLOCK)
INNER JOIN vwProductList b WITH (NOLOCK) 
    ON CAST(a.ProductId AS VARCHAR) = CAST(b.ProductId AS VARCHAR) 
WHERE b.clientid = '331' 
AND b.IsForeign = '0' order by a.ProductId asc, a.Filename asc

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