postgresql7.1
select dotlrn_community_types.community_type,
dotlrn_community_types.pretty_name,
dotlrn_community_types.description,
(select site_node__url(site_nodes.node_id)
from site_nodes
where site_nodes.object_id = dotlrn_community_types.package_id) as url
from dotlrn_community_types
where dotlrn_community_types.supertype = :community_type
order by dotlrn_community_types.pretty_name