Table User id, name
id, user_id, active
User can have multiple connections with active fields from 0 to 3
When I do left join I am getting all connection for each user. That is fine. What I am looking for is how to find users who has few connections but its missing number 1 in active so he has few connections active 0, one active 2 but no active 1.