added join on membership status table