Socialise - remove nested query use self joins instead