CREATE VIEW dbo.KONTEYNER_SATIR_LISTESI
AS
SELECT        FIS.FICHENO, FIS.DATE_, KNT.DURUM AS DURUM, DATEDIFF(DAY, FIS.DATE_, GETDATE()) AS GUN, KUL.KULLANICI, FIS.GENEXP, ISNULL
                             ((SELECT        COUNT(*) AS Expr1
                                 FROM            dbo.FICHE_LINES
                                 WHERE        (KONTEYNERREF = FIS.REF)), 0) AS KALEM, ISNULL
                             ((SELECT        COUNT(DISTINCT COMPANYREF) AS Expr1
                                 FROM            dbo.FICHE_LINES AS FICHE_LINES_1
                                 WHERE        (KONTEYNERREF = FIS.REF)), 0) AS FIRMA, ISNULL(STT.TPL, 0) AS TOPLAM, FIS.CBM, FIS.REF
FROM            dbo.KONTEYNER AS FIS LEFT OUTER JOIN
                         dbo.KULLANICILAR AS KUL ON KUL.REF = FIS.USERREF LEFT OUTER JOIN
                         dbo.KONTEYNER_STATUS AS KNT ON KNT.REF = FIS.STATUS LEFT OUTER JOIN
                         dbo.KONTEYNER_TOPLAM_TUTARLAR AS STT ON STT.KONTEYNERREF = FIS.REF