SELECT a.id as app_id, a.name as app_name, count(q.id) as qcount, r.avg_time_spent as avg_time,
r.avg_score as avg_score, r.total_exams_taken
FROM linen_ex_apps a
LEFT JOIN linen_questions q ON q.ex_app_id = a.id
LEFT JOIN linen_ex_app_agg_results r
ON r.ex_app_id = a.id
WHERE a.active = 1
AND a.section_id = 32
GROUP BY a.id
LIMIT 0, 10