eLearning Home   > Reading Rooms  New Roomi School  


Select Grade: 
Show report for Unit:  
Query failed: SELECT a.participant_id AS member_id, b.first_name, b.last_name, b.designation_id, b.user_name, b.grade, b.school_id, b.other_school, sum(correct_flag) AS points, count(correct_flag) attempted FROM q_answer a RIGHT OUTER JOIN members b ON (a.participant_id = b.member_id) WHERE b.school_id = '1409' and create_date > DATE_SUB( CURDATE( ) , INTERVAL DAY ) GROUP BY a.participant_id, b.first_name, b.last_name, b.designation_id, b.user_name, b.grade, b.school_id, b.other_school ORDER BY points DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY a.participant_id, b.first_name, b.last_' at line 17