g address is preferred *******
LEFT OUTER JOIN [section] se WITH (NOLOCK) ON se.sectionID =
(SELECT TOP 1 x.sectionID FROM [section] x WITH (NOLOCK)
INNER JOIN roster r ON r.sectionID = x.sectionID AND r.trialID = x.trial
l T ON SH.trialID = T.trialID AND active = 1
JOIN SectionPlacement SecP ON SecP.sectionID = SH.sectionID AND SecP.trialID = SH.trialID
JOIN Term ON Term.termID = SecP.termID AND Term.startDate <