Alex:

Column 'LBF.NodId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.