CREATE DEFINER=CURRENT_USER PROCEDURE `GetCourseIDBySessionID`(IN i_session_id INT)
BEGIN
	SELECT pr.related_item_id FROM inno_lci_2_podsrel pr WHERE pr.related_pod_id = (SELECT GETPODTYPEID('slci_course')) AND pr.pod_id = GETPODTYPEID('slci_course_session') AND pr.item_id = i_session_id;
END