Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.id
- FROM PROFILE p
- WHERE EXISTS (SELECT 1
- FROM photo ph
- WHERE ph.profile_id = p.id
- HAVING Count(DISTINCT image_id) > 3)
- AND NOT EXISTS (SELECT 1
- FROM used u
- WHERE u.service_id = 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement