SELECT
ITEMS.CODE AS 'Kod',
ITEMS.NAME AS 'Ürün Adı',
CASE WHEN ISNULL(ALIS.AMOUNT,0)<>0 THEN
ISNULL(ALIS.AMOUNT,0)
WHEN ISNULL(ALIS2.AMOUNT,0)<>0 THEN
ISNULL(ALIS2.AMOUNT,0)
WHEN ISNULL(ALIS3.AMOUNT,0)<>0 THEN
ISNULL(ALIS3.AMOUNT,0)
ELSE 0 END AS 'Miktar',
CASE WHEN ISNULL(ALIS.[Kdv Hariç Adet Fiyatı],0)<>0 THEN
ISNULL(ALIS.[Kdv Hariç Adet Fiyatı],0)
WHEN ISNULL(ALIS2.[Kdv Hariç Adet Fiyatı],0)<>0 THEN
ISNULL(ALIS2.[Kdv Hariç Adet Fiyatı],0)
WHEN ISNULL(ALIS3.[Kdv Hariç Adet Fiyatı],0)<>0 THEN
ISNULL(ALIS3.[Kdv Hariç Adet Fiyatı],0) END AS [Kdv Hariç Adet Fiyatı]
FROM LG_002_ITEMS ITEMS
OUTER APPLY (SELECT TOP 1
STLINE.STOCKREF,STLINE.AMOUNT,CAST(ISNULL((STLINE.VATMATRAH/STLINE.AMOUNT)/STLINE.UINFO2,0) AS decimal(18,2)) AS 'Kdv Hariç Adet Fiyatı'
FROM LG_002_11_STLINE STLINE WHERE (STLINE.STOCKREF = ITEMS.LOGICALREF) AND (STLINE.VATMATRAH>0) and
(STLINE.DATE_ BETWEEN CONVERT(DATETIME,'01.01.2018',104) AND CONVERT(DATETIME,'31.12.2018',104)) AND
(STLINE.LINETYPE NOT IN (2,3,4)) and STLINE.TRCODE IN (1) ORDER BY STLINE.DATE_ DESC,STLINE.FTIME DESC
) AS ALIS
OUTER APPLY (SELECT TOP 1
STLINE.STOCKREF,STLINE.AMOUNT,CAST(ISNULL((STLINE.VATMATRAH/STLINE.AMOUNT)/STLINE.UINFO2,0) AS decimal(18,2)) AS 'Kdv Hariç Adet Fiyatı'
FROM LG_002_10_STLINE STLINE WHERE (STLINE.STOCKREF = ITEMS.LOGICALREF) AND (STLINE.VATMATRAH>0) and
(STLINE.DATE_ BETWEEN CONVERT(DATETIME,'01.01.2017',104) AND CONVERT(DATETIME,'31.12.2017',104)) AND
(STLINE.LINETYPE NOT IN (2,3,4)) and STLINE.TRCODE IN (1) ORDER BY STLINE.DATE_ DESC,STLINE.FTIME DESC
) AS ALIS2
OUTER APPLY (SELECT TOP 1
STLINE.STOCKREF,STLINE.AMOUNT,CAST(ISNULL((STLINE.VATMATRAH/STLINE.AMOUNT)/STLINE.UINFO2,0) AS decimal(18,2)) AS 'Kdv Hariç Adet Fiyatı'
FROM LG_002_09_STLINE STLINE WHERE (STLINE.STOCKREF = ITEMS.LOGICALREF) AND (STLINE.VATMATRAH>0) and
(STLINE.DATE_ BETWEEN CONVERT(DATETIME,'01.01.2016',104) AND CONVERT(DATETIME,'31.12.2016',104)) AND
(STLINE.LINETYPE NOT IN (2,3,4)) and STLINE.TRCODE IN (1) ORDER BY STLINE.DATE_ DESC,STLINE.FTIME DESC
) AS ALIS3
WHERE ITEMS.ACTIVE=0
ORDER BY ITEMS.NAME