SELECT TOP (50) MAX(UserVisit.LastVisit) AS MaxLastVisit, ProdTAB.ProdID, ProdTAB.ProdImageUpdatedOn, ProdTAB.ProdPackageID, ISNULL(ProdTitle, '(no title)') + CASE WHEN ISNULL(RTRIM(LTRIM(ProdSubTitle)), '') = '' THEN '' ELSE ' - ' + RTRIM(LTRIM(ProdSubTitle)) END as ProdTitle
FROM UserVisit INNER JOIN os_Prod_v ProdTAB ON dbo.CanConvertInt(REPLACE(UserVisit.PageQS, 'ProdID=', '')) = ProdTAB.ProdID
WHERE (UserVisit.PageName = 'ProdDetail.asp') AND UserVisit.UserID = 0 AND CHARINDEX('&', UserVisit.PageQS) = 0 GROUP BY ProdTAB.ProdID, ProdTAB.ProdImageUpdatedOn, ProdTAB.ProdPackageID, ISNULL(ProdTitle, '(no title)') + CASE WHEN ISNULL(RTRIM(LTRIM(ProdSubTitle)), '') = '' THEN '' ELSE ' - ' + RTRIM(LTRIM(ProdSubTitle)) END ORDER BY MaxLastVisit DESC