A Database Error Occurred

Error Number: 1064

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 '' at line 40

SELECT a.* , at.activity_types_name , sds.school_district_services_name , u.first_name , u.last_name , CONCAT(u.first_name, " ", u.last_name) as consultant , u.email_address , atvs.activity_scopes_name , DATE_FORMAT(a.activity_date, "%M %d, %Y") as friendly_date , DATE_FORMAT(tr1.registration_close_date, "%M %d, %Y") as friendly_close_date , DATE_FORMAT(a.activity_date, "%m-%d-%Y") as form_activity_date , tr1.* , DATE_FORMAT(a.activity_date, "%M") as monthText , DATE_FORMAT(a.activity_date, "%d") as day , DATE_FORMAT(a.activity_date, "%m") as month , DATE_FORMAT(a.activity_date, "%Y") as year , IF(tr1.training_request_id IS NOT NULL OR tr2.training_request_id IS NOT NULL, 1, 0) as has_training_request , IF(tr1.duration, tr1.duration , IF(tr2.duration, tr2.duration, a.activity_hours)) as duration , IF(tr1.registration_close_date, IF(tr1.registration_close_date < CURDATE(), 1, 0), IF(tr2.registration_close_date, IF(tr2.registration_close_date < CURDATE(), 1, 0), IF(a.activity_date < CURDATE(), 1, 0))) as registration_closed , a.minimum_participants as minimum_participants , a.maximum_participants as maximum_participants , a.minimum_virtual_participants as minimum_virtual_participants , a.maximum_virtual_participants as maximum_virtual_participants , IF(a.parent_activity_id IS NOT NULL, (SELECT COUNT(*) FROM activities_participants ap WHERE ap.activity_id = a.parent_activity_id AND ap.is_virtual = 0), (SELECT COUNT(*) FROM activities_participants ap WHERE ap.activity_id = a.activity_id AND ap.is_virtual = 0)) as number_of_participants , IF(a.parent_activity_id IS NOT NULL, (SELECT COUNT(*) FROM activities_participants ap WHERE ap.activity_id = a.parent_activity_id AND ap.is_virtual = 1), (SELECT COUNT(*) FROM activities_participants ap WHERE ap.activity_id = a.activity_id AND ap.is_virtual = 1)) as number_of_virtual_participants FROM activities a JOIN users u ON a.user_id = u.user_id LEFT JOIN activities pa ON a.parent_activity_id = pa.activity_id LEFT JOIN activity_types at ON a.activity_types_id = at.activity_types_id LEFT JOIN school_district_services sds ON a.school_district_services_id = sds.school_district_services_id LEFT JOIN activity_scopes atvs ON a.activity_scopes_id = atvs.activity_scopes_id LEFT JOIN training_requests tr1 ON a.training_request_id = tr1.training_request_id LEFT JOIN training_requests tr2 ON pa.training_request_id = tr2.training_request_id WHERE a.activity_id =

Filename: models/Activity.php

Line Number: 268