Retrieve element attribute recorded values

SELECT eh.Path + eh.Name + ea.Path + ea.Name Path, r.*
FROM NuGreen.Asset.vElementHierarchy eh
INNER JOIN NuGreen.Asset.vElementVersion ev ON ev.ID = eh.ElementVersionID
INNER JOIN NuGreen.Asset.vElementAttribute ea ON ea.ElementVersionID = ev.ID
INNER JOIN NuGreen.Data.Archive r ON r.ElementAttributeID = ea.ID
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'
AND eh.Effective <= N'*' /*query date*/
AND eh.Ineffective > N'*' /*query date*/
AND eh.Name LIKE N'B-%'
AND ea.Name LIKE N'%Flow'