procedure to take most viewed products?

USE [saudiphone]
GO
/***** Object:  StoredProcedure [dbo].[Product_LookUp_MostViewedProductList]    Script Date: 6/28/2018 2:10:16 PM *****/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo].[Product_LookUp_MostViewedProductList]
as
begin

select   Distinct Top (8) mv.ProductID, p.ProductTitle,p.Photo,p.MinPrice
,(select count(*) from RecentViewedProducts m where m.ProductId=mv.ProductId) as TotalCount from RecentViewedProducts mv
join Product p on p.ProductID = mv.ProductId 
ORDER BY TotalCount DESC

end