Update list_subscribers to match the previous implementation order regarding joins and conditions

Howorequested to merge
bugfix/community_list_subscribers into develop

Merge request reports