Configurable reports block (plugin)

Hi there,

I want to count the # of views users of two specific roles in their courses, but the count seems to grab the # of users in that role and not the page hits. Can you see where I'm going wrong?

/*
Name:
Course and Unit page hits by enrolled students and teachers.

Description:
Counts the number of times a course page is hit by enrolled students and teachers.
*/

select
    lsl.courseid,
    c.fullname course,
    lsl.action,
    lsl.target,
    count(lsl.id) hits,
    (select count(lsl.id) from mdl_role_assignments ra where ra.contextid = ct.id and ra.roleid = 5) studenthits
    (select count(lsl.id) from mdl_role_assignments ra where ra.contextid = ct.id and ra.roleid = 9) spnethits
from mdl_logstore_standard_log lsl
    join mdl_course c on c.id = lsl.courseid
        and c.id != 1
    join mdl_context ct on ct.instanceid = c.id
        and ct.contextlevel = 50
where lsl.action = 'viewed'
	and lsl.target = 'course'
group by lsl.courseid