Fulltext results:
- Superset @campus:data:query
- 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.sectio... D ORDER BY CASE WHEN c.homeroom = 1 OR x.homeroomsection = 1 THEN 0 ELSE 1 END, pd.seq) LEFT OUTER JOIN ro