postgresql7.4
SELECT s.assess_id, s.latest_revision_id
FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_assess s
WHERE u.uos_id = :uos_id
AND i.item_id = u.uos_id
AND r.uos_revision_id = i.latest_revision
AND s.parent_uos_id = :uos_id
SELECT a.method_id, a.name, a.description, a.weighting
FROM cc_uos_assess_method a, acs_objects o, cc_uos_assess_method_map m
WHERE o.package_id = :package_id
AND a.method_id = o.object_id
AND m.assess_revision_id = :latest_revision_id
AND a.method_id = m.method_id
[template::list::orderby_clause -orderby -name "methods"]