0
SELECT Tarih, Rota, dbo.fn_MesaiSuresi(1, Tarih, Rota) AS MesaiSuresi, dbo.fn_IsYoklugu(1, Tarih, Rota) AS IsYoklugu, dbo.fn_AyarSuresi(1, Tarih, Rota) AS AyarSuresi, dbo.fn_DurusSuresi(1, Tarih, Rota)
AS GenelDurus, dbo.fn_DonusSuresi(1, Tarih, Rota) AS BosaDonme, dbo.fn_ArizaSuresi(1, Tarih, Rota) AS ArizaSuresi, dbo.fn_UretimSuresi(1, Tarih, Rota) AS UretimSuresi,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 1)) AS Renk_1,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 2)) AS Renk_2,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 3)) AS Renk_3,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 4)) AS Renk_4,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 5)) AS Renk_5,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RenkSayilari AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota) AND (RenkSayisi = 0)) AS Baskisiz,
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo.vw_RotaryIsler AS renk1
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS Rotary,
(SELECT SUM(GelenLevha) AS Expr1
FROM dbo.vw_JDE_OrderDetail AS j
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS GelenLevha,
(SELECT SUM(BozukLevha) AS Expr1
FROM dbo.vw_JDE_OrderDetail AS j
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS BozukLevha,
(SELECT SUM(BozukKutu) AS Expr1
FROM dbo.vw_JDE_OrderDetail AS j
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS BozukKutu,
(SELECT SUM(SaglamKutu) AS Expr1
FROM dbo.vw_JDE_OrderDetail AS j
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS SaglamKutu,
(SELECT SUM(SiparisAdedi) AS Expr1
FROM dbo.vw_JDE_OrderDetail AS j
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) /
(SELECT COUNT(IsEmri) AS Expr1
FROM dbo. tblMakinaDetay AS tmd2
WHERE (Tarih = tmd. Tarih) AND (Rota = tmd. Rota)) AS OrtSiparis
FROM dbo. tblMakinaDetay AS tmd
GROUP BY Tarih, Rota
