postgresql7.1
SELECT owner_id FROM dotfolios WHERE node_id = :node_id
SELECT username FROM users WHERE user_id = :owner_id
SELECT live_revision as revision_id, item_id
FROM acs_rels a, cr_items c
WHERE a.object_id_two = c.item_id
AND a.object_id_one = :owner_id
AND a.rel_type = 'user_portrait_rel'
SELECT last_name || ', ' || first_names AS adviser_name,
user_id AS adviser_id
FROM dotfolio_users WHERE type = 'adviser'
SELECT dotfolio__adviser_p (:user_id)
SELECT site_node__url(d.node_id) AS url
FROM dotfolio_users du LEFT OUTER JOIN dotfolios d
ON du.user_id = d.owner_id
WHERE du.user_id = :user_id
SELECT user_id FROM dotfolio_users WHERE username = :username
SELECT rel_id
FROM dotfolio_users
WHERE user_id = :user_id
SELECT type
FROM dotfolio_users
WHERE user_id = :user_id