# HG changeset patch
# User bsw
# Date 1330262400 -3600
# Node ID 12a578e75f3e7289d92be0826e5b759f7ca94bd8
# Parent  22e4e26717acd46bfd6c4993a56b3ee109d0a5b8
Added missing join on clause for delegations selection

diff -r 22e4e26717ac -r 12a578e75f3e app/main/unit/show.lua
--- a/app/main/unit/show.lua	Sun Feb 26 14:15:27 2012 +0100
+++ b/app/main/unit/show.lua	Sun Feb 26 14:20:00 2012 +0100
@@ -39,9 +39,9 @@
 
 local delegations_selector = Delegation:new_selector()
   :join("member", "truster", "truster.id = delegation.truster_id AND truster.active")
-  :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.voting_right")
+  :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.unit_id = delegation.unit_id AND truster_privilege.voting_right")
   :join("member", "trustee", "trustee.id = delegation.trustee_id AND truster.active")
-  :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.voting_right")
+  :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.unit_id = delegation.unit_id AND trustee_privilege.voting_right")
   :add_where{ "delegation.unit_id = ?", unit.id }
 
 local issues_selector = Issue:new_selector()