postgresql7.1
select dotlrn_clubs_full.*, v.n_members
from dotlrn_clubs_full left outer join
(select dotlrn_clubs_full.club_id, count(1) as n_members
from dotlrn_clubs_full, dotlrn_member_rels_approved
where dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id
group by dotlrn_clubs_full.club_id) v
on dotlrn_clubs_full.club_id = v.club_id
where 1 = 1
[template::list::page_where_clause -and -name "clubs" -key "dotlrn_clubs_full.club_id"]
[template::list::orderby_clause -orderby -name "clubs"]
select dotlrn_clubs_full.*, v.n_members
from dotlrn_clubs_full left outer join
(select dotlrn_clubs_full.club_id, count(1) as n_members
from dotlrn_clubs_full, dotlrn_member_rels_approved
where dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id
group by dotlrn_clubs_full.club_id) v
on dotlrn_clubs_full.club_id = v.club_id
where 1 = 1
[template::list::orderby_clause -orderby -name "clubs"]