1.1 --- a/app/main/member/show_tab.lua	Sat Feb 05 18:45:04 2011 +0100
     1.2 +++ b/app/main/member/show_tab.lua	Sat Feb 05 19:47:35 2011 +0100
     1.3 @@ -44,6 +44,7 @@
     1.4    end
     1.5  
     1.6    local broken_delegations = Delegation:new_selector()
     1.7 +    :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
     1.8      :join("member", nil, "delegation.trustee_id = member.id")
     1.9      :add_where{"delegation.truster_id = ?", member.id}
    1.10      :add_where{"member.active = 'f' OR (member.last_login_public IS NULL OR age(member.last_login) > ?::interval)", config.delegation_warning_time }