SELECT 
	umbracoNode.id,
	umbracoNode.text,
	haygroveMemberElectricity.* 
FROM haygroveMemberElectricity
INNER JOIN umbracoNode ON umbracoNode.id = haygroveMemberElectricity.GridSourcedConventionalElectricityCountryId;