CREATE VIEW dbo.WEBAPI_DGN630026S
AS
SELECT        ITM.LOGICALREF AS Ref, ITM.EXPCTGNO AS Barkod, dbo.modelNumber(ITM.LOGICALREF) AS ModelKodu, ITM.SPECODE4 AS Marka, '' AS Katagori, 'TRY' AS ParaBirimi, 
                         dbo.RepOzel(dbo.InitCap({ fn CONCAT({ fn CONCAT(dbo.RepLhRh(ITM.NAME), ' ') }, dbo.RepLhRh(ITM.NAME3)) })) AS UrunAdi, '' AS UrunAciklamasi, TLF.TL * 1.20 AS PiyasaSatisFiyati, TLF.TL * 1.20 AS TrendyolSatisFiyati, 
                         CASE WHEN (GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED) > 10 THEN 10 ELSE ISNULL((GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED), 0) END AS UrunStokAdedi, ITM.CODE AS StokKodu, 20 AS KDVOrani, '' AS Desi, 
                         { fn CONCAT({ fn CONCAT('https://universaloto.com/foto/photos/', dbo.formatNumber(ITM.LOGICALREF)) }, '.jpg') } AS Gorsel1, '' AS Gorsel2, '' AS Gorsel3, '' AS Gorsel4, '' AS Gorsel5, '' AS Gorsel6, '' AS Gorsel7, '' AS Gorsel8, 
                         '' AS SevkiyatSuresi, '' AS SevkiyatTipi, dbo.AracModelleri({ fn CONCAT({ fn CONCAT(ITM.SPECODE2, ' ') }, ISNULL(MAM.KAT1, '')) }) AS AracMarkaModel
FROM            dbo.LG_011_ITEMS AS ITM LEFT OUTER JOIN
                         dbo.LV_011_08_GNTOTST AS GNT ON GNT.STOCKREF = ITM.LOGICALREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.UNI_TL_FIYAT AS TLF ON TLF.CARDREF = ITM.LOGICALREF LEFT OUTER JOIN
                         dbo.MALZEME_ARAC_MODELLERI AS MAM ON MAM.LOGREF = ITM.LOGICALREF
WHERE        (ITM.ACTIVE = 0) AND (TLF.TL IS NOT NULL)