Columns from outer reference are not projected correctly in Outer Apply

[smitpatel]

 public class Program
    {
        public static async Task Main(string[] args)
        {
            using (var db = new MyContext())
            {
                // Recreate database
                db.Database.EnsureDeleted();
                db.Database.EnsureCreated();

                // Seed database


                db.SaveChanges();
            }

            using (var db = new MyContext())
            {
                // Run queries
                var query = db.Blogs
                    .Select(b => new
                    {
                        Posts = b.Posts
                            .OrderBy(a => a.Ordering)
                            .Take(1)
                            .Select(p => new
                        {
                            Title = p.Id == p.Blog.Id ? "A" : "B"
                        }).ToList()
                    }).FirstOrDefault();
            }
            Console.WriteLine("Program finished.");
        }
    }


    public class MyContext : DbContext
    {
        private static ILoggerFactory ContextLoggerFactory
            => LoggerFactory.Create(b =>
            {
                b
                .AddConsole()
                .AddFilter("", LogLevel.Debug);
            });

        // Declare DBSets
        public DbSet<Blog> Blogs { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            // Select 1 provider
            optionsBuilder
                .UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=_ModelApp;Trusted_Connection=True;Connect Timeout=5;ConnectRetryCount=0")
                //.UseSqlite("filename=_modelApp.db")
                //.UseInMemoryDatabase(databaseName: "_modelApp")
                //.UseCosmos("https://localhost:8081", @"C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==", "_ModelApp")
                .EnableSensitiveDataLogging()
                .UseLoggerFactory(ContextLoggerFactory);
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            // Configure model
        }
    }

    public class Blog
    {
        public int Id { get; set; }

        public List<Post> Posts { get; set; }
    }

    public class Post
    {
        public int Id { get; set; }
        public int Ordering { get; set; }
        public int BlogId { get; set; }
        public Blog Blog { get; set; }
    }

Generated SQL

      SELECT [t].[Id], [t1].[Title], [t1].[Id], [t1].[Id0]
      FROM (
          SELECT TOP(1) [b].[Id]
          FROM [Blogs] AS [b]
      ) AS [t]
      OUTER APPLY (
          SELECT CASE
              WHEN [t].[Id] = [b0].[Id] THEN N'A'
              ELSE N'B'
          END AS [Title], [t].[Id], [b0].[Id] AS [Id0], [t].[Ordering] -- [t].[Ordering] is not projected in [t] (outer)
          FROM (
              SELECT TOP(1) [p].[Id], [p].[BlogId], [p].[Ordering]
              FROM [Post] AS [p]
              WHERE [t].[Id] = [p].[BlogId]
              ORDER BY [p].[Ordering]
          ) AS [t0]
          INNER JOIN [Blogs] AS [b0] ON [t].[BlogId] = [b0].[Id]
      ) AS [t1]
      ORDER BY [t].[Id], [t1].[Ordering], [t1].[Id], [t1].[Id0]

This demonstrates #22222 also.