postgresql7.4
SELECT g.grade_set_id, g.live_revision_id
FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_grade_set g
WHERE u.uos_id = :uos_id
AND i.item_id = u.uos_id
AND r.uos_revision_id = i.live_revision
AND g.parent_uos_id = :uos_id
SELECT t.type_id, grade_rev.description
FROM cc_uos_grade_type t LEFT OUTER JOIN
(SELECT g.grade_type_id, g.description
FROM cc_uos_grade_map map, cc_uos_grade g
WHERE map.revision_id = :live_revision_id
AND map.grade_id = g.grade_id) AS grade_rev
ON (t.type_id = grade_rev.grade_type_id)
ORDER BY t.upper_bound DESC