CREATE VIEW dbo.PLAS_LIST_TSI_WEB
AS
SELECT        TSI.PDEF, PL.SPECODE2, PL.CITY, PL.MANG, PL.COLOR_, PL.LAT, PL.LNG, PL.MANG_COLOR, ISNULL(TSI.TOPLAM, 0) AS TAH2023, ISNULL(TSI5.TOPLAM, 0) AS TAH2024, ISNULL(TSI3.TOPLAM, 0) AS SAT2023, ISNULL(TSI6.TOPLAM, 0) 
                         AS SAT2024, ISNULL(TSI4.TOPLAM, 0) AS IAD2023, ISNULL(TSI2.TOPLAM, 0) AS IAD2024, ISNULL(CDT.FRMASAY, 0) AS ISLEM2023, ISNULL(CDT2.FRMASAY, 0) AS ISLEM2024, ISNULL(CDT3.FRMASAY, 0) AS AKTIF
FROM            dbo.PLAS_LIST AS PL LEFT OUTER JOIN
                         dbo.CARI_DURUM_TSI AS CDT ON CDT.CITY = PL.CITY AND CDT.SPECODE2 = PL.SPECODE2 AND CDT.TUR = 1 AND CDT.YIL = 2023 LEFT OUTER JOIN
                         dbo.CARI_DURUM_TSI AS CDT2 ON CDT2.CITY = PL.CITY AND CDT2.SPECODE2 = PL.SPECODE2 AND CDT2.TUR = 1 AND CDT2.YIL = 2024 LEFT OUTER JOIN
                         dbo.CARI_DURUM_TSI AS CDT3 ON CDT3.CITY = PL.CITY AND CDT3.SPECODE2 = PL.SPECODE2 AND CDT3.TUR = 2 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI.CITY = PL.CITY AND TSI.YIL = 2023 AND TSI.TUR = 1 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI3 ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI3.CITY = PL.CITY AND TSI3.YIL = 2023 AND TSI3.TUR = 2 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI4 ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI4.CITY = PL.CITY AND TSI4.YIL = 2023 AND TSI4.TUR = 3 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI5 ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI5.CITY = PL.CITY AND TSI5.YIL = 2024 AND TSI5.TUR = 1 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI6 ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI6.CITY = PL.CITY AND TSI6.YIL = 2024 AND TSI6.TUR = 2 LEFT OUTER JOIN
                         dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB AS TSI2 ON REPLACE(TSI.PDEF,' WEB','') = PL.SPECODE2 AND TSI2.CITY = PL.CITY AND TSI2.YIL = 2024 AND TSI2.TUR = 3