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