where api
outer join to know if someone is there or not