/* 1) SlaytResimleri -> LOGICALREF bazinda Resim2..Resim7 pivot view */
CREATE   VIEW dbo.vItemSlideImages
AS
WITH img AS (
    SELECT
        SR.LOGICALREF,
        Url = CONCAT('https://slide.universaloto.com/uploads/', SR.IMGNAME),
        rn  = ROW_NUMBER() OVER (PARTITION BY SR.LOGICALREF ORDER BY SR.REF)
    FROM dbo.SlaytResimleri AS SR
    WHERE SR.IMGNAME IS NOT NULL
      AND LTRIM(RTRIM(SR.IMGNAME)) <> ''
)
SELECT
    LOGICALREF,
    CAST(MAX(CASE WHEN rn = 1 THEN Url END) AS NVARCHAR(500)) AS Resim2,
    CAST(MAX(CASE WHEN rn = 2 THEN Url END) AS NVARCHAR(500)) AS Resim3,
    CAST(MAX(CASE WHEN rn = 3 THEN Url END) AS NVARCHAR(500)) AS Resim4,
    CAST(MAX(CASE WHEN rn = 4 THEN Url END) AS NVARCHAR(500)) AS Resim5,
    CAST(MAX(CASE WHEN rn = 5 THEN Url END) AS NVARCHAR(500)) AS Resim6,
    CAST(MAX(CASE WHEN rn = 6 THEN Url END) AS NVARCHAR(500)) AS Resim7
FROM img
GROUP BY LOGICALREF;