Invasion issue in coolers

select Convert(char(10),AP.CreatedOn,126)'Date',AP.ClientId,C.ClientName,AP.SessionUid,AP.SceneUid,AP.SceneId,APP.productId IRProductId,D.Product IRProductName,D.SKU IRSKUId,RESkuCode,D.RESKUDescription,
OrientationID,D.Type,D.SellingPackFrontFacings,I.ManufacturerName,count(APP.ProductId) as Facings_Count
from vwAssetPurityList AP with (nolock)
full outer join AssetPurityProduct APP with (nolock) on AP.AssetPurityId=APP.AssetPurityId
join Client C with (nolock) on AP.ClientId=C.Clientid
full outer join vwProductList D with (nolock) on APP.ProductID=D.ProductId
full outer join Product G with (nolock) on APP.IRManualProductId=G.ProductId
full outer join Brand H with (nolock) on D.BrandId=H.BrandId
full outer join Manufacturer I with (nolock) on H.ManufacturerId=I.ManufacturerId
full outer join Brand J with (nolock) on G.BrandId=J.BrandId
full outer join Manufacturer K with (nolock) on J.ManufacturerId=K.ManufacturerId
full outer join ProductCategory L with (nolock) on D.ProductCategoryId=L.ProductCategoryId
where AP.SessionUid = '70bd5672-1796-4b36-85eb-679c461d66c0' 
group by AP.CreatedOn,AP.ClientId,C.ClientName,AP.SessionUid,AP.SceneUid,AP.SceneId,APP.productId,D.Product,D.SKU,RESkuCode,D.RESKUDescription,
OrientationID,D.Type,D.SellingPackFrontFacings,I.ManufacturerName
order by AP.CreatedOn asc

--------------------------------------------------