postgresql7.1 SELECT dca.community_id, dca.community_key as section_identifier, dca.community_key as section_key, dca.pretty_name, dc.course_name, des.course_id, des.section_id, dca.active_start_date, des.date_time_start, dca.active_end_date, des.date_time_end FROM cr_items ci, dotlrn_catalog dc, dotlrn_ecommerce_section des, dotlrn_communities_all dca WHERE ci.live_revision = dc.course_id and des.course_id = ci.item_id and dca.community_id = des.community_id [template::list::orderby_clause -name sections_list -orderby]