SELECT
ITEMS.LOGICALREF,ITEMS.CODE,ITEMS.NAME,
(SELECT SUM(ONHAND) FROM LV_215_01_GNTOTST GNTOT WHERE GNTOT.INVENNO<>'-1' AND GNTOT.STOCKREF=ITEMS.LOGICALREF) AS 'STOKMIKTARI',
(SELECT TOP 1 DATE_ FROM LG_215_01_STLINE ST1 WHERE ST1.TRCODE IN ('1') ORDER BY ST1.DATE_ DESC) AS 'SONGIRISTARIHI'
FROM LG_215_ITEMS ITEMS
WHERE ITEMS.LOGICALREF IN (SELECT STOCKREF FROM LV_215_01_GNTOTST GNTOT WHERE GNTOT.ONHAND>'0')
AND ITEMS.LOGICALREF NOT IN (SELECT STOCKREF FROM LG_215_01_STLINE STLINE WHERE STLINE.TRCODE IN ('7','8'))