Thing is, I have no control over how the query gets generated. Each subquery (or project) is calculating one of 9 columns.
If you want to try running the query, here's the database https://www.spiritualselftransformation.com/misc/NaturalGroundingVideos.zip Here's the query https://www.spiritualselftransformation.com/misc/LinqSQLiteError.txt I'm running against SQLite that comes with NuGet package: System.Data.SQLite (x86/x64) v1.0.97.0 Etienne
