SELECT t1.contest_id, c.hacker_id, c.name, t1.st_submissions1, t1.sta_submissions1, t1.st_views1, t1.stu_views1 FROM (SELECT c.contest_id, SUM(t.st_views) st_views1, SUM(t.stu_views) stu_views1, SUM(t.st_submissions) st_submissions1, SUM(t.sta_submissions) sta_submissions1 FROM (SELECT v.college_id, v.st_views, v.stu_views, s.st_submissions, s.sta_submissions FROM (SELECT c.college_id, SUM(v.total_views) st_views, SUM(v.total_unique_views) stu_views FROM challenges c, view_stats v WHERE c.challenge_id = v.challenge_id GROUP BY c.college_id) v, (SELECT c.college_id, SUM(s.total_submissions) st_submissions, SUM(s.total_accepted_submissions) sta_submissions FROM challenges c, submission_stats s WHERE c.challenge_id = s.challenge_id GROUP BY c.college_id) s WHERE v.college_id=s.college_id AND (v.st_views<>0 OR v.stu_views<>0 OR s.st_submissions<>0 OR s.sta_submissions<>0)) t, colleges c WHERE t.college_id=c.college_id GROUP BY c.contest_id) t1, contests c WHERE t1.contest_id = c.contest_id ORDER BY t1.contest_id;