CREATE VIEW dbo.MALZEME_URETICI_KOD_LISTESI
AS
SELECT        CMPREF, REF, PRODUCERCODE,STS, SIRA
FROM            ((SELECT        CMP.REF AS CMPREF, ITM.REF, PRD.PRODUCERCODE,PRD.STS, ROW_NUMBER() OVER (PARTITION BY PRD.STOCKREF, PRD.STS
                            ORDER BY PRD.REF DESC) AS SIRA
FROM            [IHR].[dbo].[PRODUCERCODES] AS PRD LEFT JOIN
                         [IHR].[dbo].[ITEMS] AS ITM ON ITM.REF = PRD.STOCKREF LEFT JOIN
                         [IHR].[dbo].[COMPANIES] AS CMP ON CMP.REF = PRD.CLIENTREF)) QQ