FROM dbo.GEN_tblAssemblies AS Assemblies2 INNER JOIN
dbo.GEN_tblRanks AS r ON Assemblies2.RankGUID = r.RankGUID INNER JOIN
dbo.GEN_tblBuildStrategies AS bs ON r.BuildStrategyGUID = bs.BuildStrategyGUID LEFT OUTER JOIN
dbo.GEN_tblAssemblies AS B ON B.LeftValue =
(SELECT MAX(LeftValue) AS Expr1
FROM dbo.GEN_tblAssemblies AS S
WHERE (Assemblies2.LeftValue > LeftValue) AND (Assemblies2.LeftValue < RightValue)) LEFT OUTER JOIN
dbo.GEN_tblAssemblies AS Assemblies1 ON Assemblies1.LeftValue BETWEEN Assemblies2.LeftValue AND Assemblies2.RightValue LEFT OUTER JOIN