CREATE VIEW dbo.WEBAPI_Ayd420188i
AS
SELECT ITM.LOGICALREF AS Ref, ITM.CODE AS SicilKodu, dbo.RepOzel(dbo.InitCap({ fn CONCAT({ fn CONCAT({ fn CONCAT(ITM.SPECODE2, ' ') }, dbo.RepLhRh(ITM.NAME)) }, dbo.RepLhRh(ITM.NAME3)) })) AS SicilAdi, 
                  ISNULL(NULLIF (ITM.SPECODE2, ''), 'DIGER') AS Arac, ISNULL(NULLIF (ITM.STGRPCODE, ''), 'DIGER') AS UrunTipi, '' AS KampanyaFiyati, CASE WHEN (GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED) 
                  > 0 THEN 'VAR' ELSE 'YOK' END AS StokDurumu, TLF.TL * 0.85 * 1.2 AS ListeFiyati, TLF.TL * 1.15 AS MaliyetFiyati, TLF.TL AS Nakit, 'TL' AS Kur, CASE WHEN KR.LOGICALREF IS NULL 
                  THEN { fn CONCAT({ fn CONCAT('https://universaloto.com/foto/webp/', dbo.formatNumber(ITM.LOGICALREF)) }, '.webp') } ELSE '' END AS Resim, CASE WHEN (GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED) 
                  > 10 THEN 10 ELSE ISNULL((GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED), 0) END AS StokAdeti, ISNULL(NULLIF (ITM.GTIPCODE, ''), 'DIGER') AS Kategori, ITM.SPECODE4 AS Marka
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.KirikResimler AS KR ON KR.LOGICALREF = ITM.LOGICALREF
WHERE  (ITM.ACTIVE = 0) AND (TLF.TL IS NOT NULL)