SELECT 
     [MemberId]
    ,[FertilizerTypeId]
    ,(SELECT umbracoNode.text FROM umbracoNode WHERE umbracoNode.id = [haygroveMemberFertilizer].[FertilizerTypeId]) AS fertiliserName
    ,[PlaceId]
    ,umbracoNode.text AS region
    ,[FertilizerValue]
    ,[Month]
    ,[Year]
    ,[LevelId]
    ,[haygroveMemberFertilizer].[Id]
    ,[DateUpdated]
    ,[DateDeleted]
FROM [haygroveMemberFertilizer]
INNER JOIN umbracoNode ON umbracoNode.id = haygroveMemberFertilizer.PlaceId
WHERE (SELECT umbracoNode.text FROM umbracoNode WHERE umbracoNode.id = [haygroveMemberFertilizer].[FertilizerTypeId]) IS NOT NULL
AND [LevelId] IN ([[UMBRACO LEVEL ID]])
ORDER BY fertiliserName ASC