**distinct count of activities.id** | activities.accountid | deals.id | users.id | users.name

select ac.id activityid, d.id as dealid, u.name, a.id as accountid
  from accounts a
  left join activities ac
    on a.id = t.accountid
  join users u
    on u.id = t.ownerid
  left join deals d
    on a.id = o.accountid and o.ownerid = t.ownerid
where u.name = 'John'


Accounts
id |

Activities
id | accountid | userid

Deals
id | accountid | userid

Users
id | name