select (select site_node__url(site_nodes.node_id) from site_nodes, acs_objects where site_nodes.object_id = forums.package_id and acs_objects.object_id = forums.forum_id) as url, forums.name, f_m.content, f_m.message_id, f_m.subject, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date, forums.forum_id as forum_id from forums_forums forums, acs_objects o, forums_messages f_m, dotlrn_communities com where o.object_id = f_m.message_id and f_m.forum_id=forums.forum_id and o.creation_user= :oneUser and com.community_id= :oneCom and apm_package__parent_id(forums.package_id) = com.package_id order by forums.name select (select site_node__url(site_nodes.node_id) from site_nodes, acs_objects where site_nodes.object_id = forums_forums.package_id and acs_objects.object_id = forums_forums.forum_id) as url, forums_forums.name, forums_messages.content, forums_messages.message_id, forums_messages.subject, to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date, forums_forums.forum_id as forum_id from forums_forums, acs_objects, forums_messages where acs_objects.object_id = forums_messages.message_id and forums_messages.forum_id=forums_forums.forum_id and acs_objects.creation_user= :oneUser order by forums_forums.name select distinct (select site_node__url(site_nodes.node_id) from site_nodes, acs_objects where site_nodes.object_id = forums_forums.package_id and acs_objects.object_id = forums_forums.forum_id) as url, forums_forums.name, forums_messages.content, forums_messages.message_id, forums_messages.subject, to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date, forums_forums.forum_id as forum_id from forums_forums, acs_objects, forums_messages, dotlrn_communities com where acs_objects.object_id = forums_messages.message_id and forums_messages.forum_id=forums_forums.forum_id and com.community_id= :oneCom and apm_package__parent_id(forums_forums.package_id) = com.package_id order by forums_forums.name select (select site_node__url(site_nodes.node_id) from site_nodes, acs_objects where site_nodes.object_id = forums_forums.package_id and acs_objects.object_id = forums_forums.forum_id) as url, forums_forums.name, forums_messages.content, forums_messages.message_id, forums_messages.subject, to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date, forums_forums.forum_id as forum_id from forums_forums, acs_objects, forums_messages where acs_objects.object_id = forums_messages.message_id and forums_messages.forum_id=forums_forums.forum_id order by forums_forums.name select first_names, last_name, email, to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS') as registration_date, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit from cc_users where user_id = :oneUser select f.community_key as key, f.community_id as id, f.pretty_name as pretty_name, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from dotlrn_communities_full f, acs_objects o where f.community_id= :oneCom and o.object_id= f.community_id