Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH deleted AS (
- DELETE from users_liked_restaurants
- WHERE users_liked_restaurants.user_id = 1
- AND users_liked_restaurants.restaurant_id = 2
- RETURNING restaurant_id
- )
- SELECT restaurants.restaurant_id,
- restaurants.title
- FROM restaurants
- LEFT JOIN users_liked_restaurants
- ON users_liked_restaurants.restaurant_id = restaurants.restaurant_id
- WHERE users_liked_restaurants.user_id = 1
- AND NOT EXISTS (
- SELECT 1 FROM deleted
- WHERE deleted.restaurent_id = restaurants.restaurant_id
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement