postgresql7.1
SELECT r.item_id as assessment_id, s.session_id, s.percent_score,
to_char(s.completed_datetime, :format) as completed_datetime,
p.first_names || ' ' || p.last_name AS subject_name,
r.title AS assessment_name, s.subject_id
FROM as_sessions s, cr_revisions r, persons p
WHERE s.assessment_id = r.revision_id
AND s.subject_id = p.person_id
AND s.subject_id = :subject_id
AND r.item_id = :assessment_id
ORDER BY s.completed_datetime desc, s.creation_datetime desc
SELECT r.item_id as assessment_id, s.session_id, s.percent_score,
to_char(s.completed_datetime, :format) as completed_datetime,
p.first_names || ' ' || p.last_name AS subject_name,
r.title AS assessment_name, s.subject_id
FROM as_sessions s, cr_revisions r, persons p
WHERE s.assessment_id = r.revision_id
AND s.subject_id = p.person_id
AND r.item_id = :assessment_id
ORDER BY s.completed_datetime desc, s.creation_datetime desc