CREATE VIEW [dbo].[WEBAPI_SEN160130M_MIN] AS
SELECT
    ITM.LOGICALREF AS Ref,

    CASE
        WHEN ITM.CODE LIKE 'UN%' AND LEN(ITM.CODE) = 9 THEN
            CASE 
                WHEN ITM.PRODUCERCODE IS NOT NULL AND LTRIM(RTRIM(ITM.PRODUCERCODE)) <> '' THEN
                    CASE 
                        WHEN ITM.PRODUCERCODE LIKE '%/%' THEN
                            RIGHT(ITM.PRODUCERCODE, CHARINDEX('/', REVERSE(ITM.PRODUCERCODE)) - 1)
                        ELSE
                            ITM.PRODUCERCODE
                    END
                ELSE
                    ITM.CODE
            END
        ELSE
            CASE 
                WHEN 
                    (
                        CASE 
                            WHEN ITM.PRODUCERCODE LIKE '%/%' THEN
                                RIGHT(ITM.PRODUCERCODE, CHARINDEX('/', REVERSE(ITM.PRODUCERCODE)) - 1)
                            ELSE
                                ITM.PRODUCERCODE
                        END
                    ) LIKE 'UN%' 
                THEN CASE 
                            WHEN ITM.PRODUCERCODE LIKE '%/%' THEN
                                RIGHT(ITM.PRODUCERCODE, CHARINDEX('/', REVERSE(ITM.PRODUCERCODE)) - 1)
                            ELSE
                                ITM.PRODUCERCODE
                        END
                ELSE ITM.CODE
            END
    END AS SicilKodu


FROM dbo.LG_011_ITEMS AS ITM
LEFT JOIN dbo.UNI_TL_FIYAT AS TLF ON TLF.CARDREF = ITM.LOGICALREF

WHERE 
    ITM.ACTIVE = 0 
    AND TLF.TL IS NOT NULL