select 1 from evaluation_tasks where task_id = :task_id and due_date < current_date
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id
select task_item_id, task_name
from evaluation_tasks
where task_id = :task_id
select late_submit_p from evaluation_tasks where task_id = :task_id
select crr.title, crr.item_id
from evaluation_answers ea, cr_revisions crr
where ea.answer_id = :answer_id
and crr.revision_id = ea.answer_id