Assignment summary wont display on Oracle

ORA-00905: missing keyword

SELECT COUNT(s.userid)

FROM m_assign_submission s

JOIN(SELECT DISTINCT eu2_u.id

FROM m_user eu2_u

JOIN m_role_assignments eu2_ra3 ON (eu2_ra3.userid = eu2_u.id AND eu2_ra3.roleid IN (5) AND eu2_ra3.contextid IN (1,3,21,1027))

JOIN m_user_enrolments eu2_ue ON eu2_ue.userid = eu2_u.id

JOIN m_enrol eu2_e ON (eu2_e.id = eu2_ue.enrolid AND eu2_e.courseid = :o_eu2_courseid)

WHERE eu2_u.deleted = 0 AND eu2_u.id <> :o_eu2_guestid) AS e ON e.id = s.userid

WHERE

s.assignment = :o_assignid AND

s.timemodified IS NOT NULL AND

s.status = :o_submissionstatus

[array (

'o_eu2_courseid' => '2',

'o_eu2_guestid' => '1',

'o_assignid' => '1',

'o_submissionstatus' => 'draft',

)]