SELECT dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID, "МО" AS Показатель, IIf([ShopCount]>0,[ShopCount],0) AS Данные
FROM (dbo_Товары INNER JOIN dbo_TempTovar6 ON dbo_Товары.Код = dbo_TempTovar6.TovarKod) LEFT JOIN Act_MO_Before ON (dbo_TempTovar6.DateMe = Act_MO_Before.DateMe) AND (dbo_TempTovar6.TovarKod = Act_MO_Before.TovarKod) AND (dbo_TempTovar6.Number = Act_MO_Before.Номер)
GROUP BY dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID, "МО", IIf([ShopCount]>0,[ShopCount],0)
ORDER BY dbo_TempTovar6.Number, dbo_TempTovar6.ID


UNION ALL

SELECT dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID, "P" AS Показатель, IIf(Sum([Summ])>0,Round(Sum([Summ])/Sum([Sale]),2),0) AS Данные
FROM dbo_Источники_магазинов_РЦ INNER JOIN (dbo_Товары INNER JOIN ((dbo_TempTovar6 INNER JOIN dbo_SalesALL ON (dbo_TempTovar6.DateMe = dbo_SalesALL.Date) AND (dbo_TempTovar6.TovarKod = dbo_SalesALL.TovarKod)) INNER JOIN FilterRC ON dbo_TempTovar6.Place = FilterRC.Place) ON dbo_Товары.Код = dbo_SalesALL.TovarKod) ON (dbo_Источники_магазинов_РЦ.Магазин = dbo_SalesALL.ShopKod) AND (dbo_Источники_магазинов_РЦ.Источник_поставки_РЦ = FilterRC.РЦ)
GROUP BY dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID
ORDER BY dbo_TempTovar6.Number, dbo_TempTovar6.ID


UNION ALL 

SELECT dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID, "SU" AS Показатель, Sum(dbo_SalesALL.Sale) AS Данные
FROM dbo_Источники_магазинов_РЦ INNER JOIN (dbo_Товары INNER JOIN ((dbo_TempTovar6 INNER JOIN dbo_SalesALL ON (dbo_TempTovar6.TovarKod = dbo_SalesALL.TovarKod) AND (dbo_TempTovar6.DateMe = dbo_SalesALL.Date)) INNER JOIN FilterRC ON dbo_TempTovar6.Place = FilterRC.Place) ON dbo_Товары.Код = dbo_SalesALL.TovarKod) ON (dbo_Источники_магазинов_РЦ.Магазин = dbo_SalesALL.ShopKod) AND (dbo_Источники_магазинов_РЦ.Источник_поставки_РЦ = FilterRC.РЦ)
GROUP BY dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID
HAVING (((Sum(dbo_SalesALL.Sale))>=0))
ORDER BY dbo_TempTovar6.Number, dbo_TempTovar6.ID


UNION ALL SELECT dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID, "C" AS Показатель, Nz(Count([dbo_SalesALL].[ShopKod]),0) AS Данные
FROM dbo_Источники_магазинов_РЦ INNER JOIN (dbo_Товары INNER JOIN ((dbo_TempTovar6 INNER JOIN dbo_SalesALL ON (dbo_TempTovar6.TovarKod = dbo_SalesALL.TovarKod) AND (dbo_TempTovar6.DateMe = dbo_SalesALL.Date)) INNER JOIN FilterRC ON dbo_TempTovar6.Place = FilterRC.Place) ON dbo_Товары.Код = dbo_SalesALL.TovarKod) ON (dbo_Источники_магазинов_РЦ.Источник_поставки_РЦ = FilterRC.РЦ) AND (dbo_Источники_магазинов_РЦ.Магазин = dbo_SalesALL.ShopKod)
GROUP BY dbo_TempTovar6.Number, dbo_Товары.Наименование, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, dbo_TempTovar6.ID
ORDER BY dbo_TempTovar6.Number, dbo_TempTovar6.ID;

SELECT dbo_TempTovar6.Number AS Номер, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe, Count(dbo_BI_Small_Rest.Shop_Number) AS ShopCount
FROM ((dbo_TempTovar6 INNER JOIN dbo_BI_Small_Rest ON (dbo_TempTovar6.DateMe = dbo_BI_Small_Rest.Day_Date) AND (dbo_TempTovar6.TovarKod = dbo_BI_Small_Rest.Product_Id)) INNER JOIN FilterRC ON dbo_TempTovar6.Place = FilterRC.Place) INNER JOIN dbo_Источники_магазинов_РЦ ON (FilterRC.РЦ = dbo_Источники_магазинов_РЦ.Источник_поставки_РЦ) AND (dbo_BI_Small_Rest.Shop_Number = dbo_Источники_магазинов_РЦ.Магазин)
WHERE (((dbo_BI_Small_Rest.Resp_Unit) Not Like "*Допродажа*"))
GROUP BY dbo_TempTovar6.Number, dbo_TempTovar6.TovarKod, dbo_TempTovar6.DateMe
ORDER BY dbo_TempTovar6.Number;