SELECT DISTINCT CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, cast(P_Desc1 as nvarchar(4000)) as P_Desc1, P_Name1, P_Type FROM (tblCactuShop1Categories c INNER JOIN tblCactuShop1ProductCategoryLink pcl ON c.CAT_ID = pcl.PCAT_CategoryID) INNER JOIN tblCactuShop1Products ON pcl.PCAT_ProductID = tblCactuShop1Products.P_ID WHERE P_Name1 <> '' AND P_Live = 'y' AND CAT_Live = 'y' AND CAT_ID=25 GROUP BY CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, cast(P_Desc1 as nvarchar(4000)) , P_Name1, P_Type ORDER BY P_Name1