select eg.grade_plural_name, eg.weight as grade_weight, eg.grade_item_id, eg.comments as grade_comments from evaluation_gradesi eg where grade_id = :grade_id select et.task_item_id, et.task_name, et.weight as task_weight, et.requires_grade_p, et.task_id, et.points, coalesce(et.relative_weight,0) as relative_weight, cri.live_revision from evaluation_tasksi et, cr_items cri where et.grade_item_id = :grade_item_id and (cri.live_revision = et.task_id or cri.latest_revision = et.task_id) and cri.item_id = et.task_item_id order by task_name