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