SELECT DISTINCT user_id
FROM enter t1
WHERE NOT EXISTS ( SELECT NULL
FROM enter t2
WHERE enter_source = 'web'
AND t1.user_id = t2.user_id )
AND EXISTS ( SELECT NULL
FROM enter t3
WHERE enter_source IN ('ios', 'android')
AND t1.user_id = t3.user_id );