postgresql7.4 select et.task_name, et.number_of_members, et.due_date, et.weight, et.online_p, et.late_submit_p, et.requires_grade_p, et.description, et.title as task_title, et.data as task_data, ets.title as solution_title, ets.data as solution_data, eg.grade_plural_name, eg.weight as grade_weight, ets.revision_id from evaluation_grades eg, evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) where et.task_id = :task_id and et.grade_id = eg.grade_id