SQLite Query Optimization: Using Uncorrelated Subqueries to Skip Correlated Subqueries for Performance Gains

Skipping expensive per-row subqueries to speed up my average query ~17%.