postgresql7.1 select b.forum_id, b.short_name, site_node__url(sn.node_id) as url, acs_object__name(sn.object_id) as bboard_name from bboard_forums b left join site_nodes sn on (sn.object_id = b.bboard_id), site_nodes sn, apm_packages apm where sn.parent_id = :node_id and sn.object_id = apm.package_id and apm.package_key = 'bboard' order by lower(bboard_name)