SQL Sorgu Varyantlı Satışlar

SELECT * FROM (SELECT DATE_ AS [TARİH],
(SELECT FICHENO FROM LG_215_01_STFICHE WHERE LOGICALREF=S.STFICHEREF)AS [FİŞ NO],
(SELECT CODE FROM LG_215_ITEMS WHERE LOGICALREF=S.STOCKREF ) AS [STOK KODU],
(SELECT NAME FROM LG_215_ITEMS WHERE LOGICALREF=S.STOCKREF ) AS [STOK AÇIKLAMASI],
(SELECT CODE FROM LG_215_VARIANT WHERE LOGICALREF=S.VARIANTREF)AS [VARYANT KODU],
(SELECT NAME FROM LG_215_VARIANT WHERE LOGICALREF=S.VARIANTREF)AS [VARYANT AÇIKLAMASI],
(SELECT CODE FROM LG_215_CLCARD WHERE LOGICALREF=S.CLIENTREF) AS [CARİ KODU],
(SELECT DEFINITION_ FROM LG_215_CLCARD WHERE LOGICALREF=S.CLIENTREF) AS [CARİ ÜNVANI],
(SELECT CODE FROM LG_215_PAYPLANS WHERE LOGICALREF=(SELECT PAYDEFREF FROM LG_215_01_STFICHE WHERE LOGICALREF=S.STFICHEREF))AS [VADE],
S.AMOUNT AS [MİKTAR],
ISNULL(CASE PRCURR WHEN 0 THEN S.PRICE END,0) AS [BİRİM FİYAT],
ISNULL(CASE WHEN PRCURR>0 THEN S.PRPRICE END,0) DOVIZLIBIRIMFIYAT,
   ROUND(CASE S.PRCURR
        WHEN 0 THEN 0
   ELSE
       CASE PRPRICE
            WHEN 0 THEN
                (SELECT REPORTRATE FROM LG_215_01_STFICHE WHERE LOGICALREF=S.STFICHEREF)
            ELSE
                PRICE/PRPRICE
            END
   END,4) AS [DÖVİZ KURU],
   CASE PRCURR WHEN 0 THEN 'TL' WHEN 20 THEN 'EURO' WHEN 1 THEN 'USD' END AS DOVIZTURU,
ISNULL(CASE WHEN PRCURR=0 THEN S.PRICE END,0) AS TL_TUTAR,
S.SOURCEINDEX AS AMBAR
FROM LG_215_01_STLINE S WHERE TRCODE=8 AND S.CANCELLED=0
AND (SELECT SPECODE5 FROM LG_215_CLCARD WHERE LOGICALREF=S.CLIENTREF)NOT IN('X','x')
) AS TABLOM