Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. WITH deleted AS (
  2. DELETE from users_liked_restaurants
  3. WHERE users_liked_restaurants.user_id = 1
  4. AND users_liked_restaurants.restaurant_id = 2
  5. RETURNING restaurant_id
  6. )
  7. SELECT restaurants.restaurant_id,
  8. restaurants.title
  9. FROM restaurants
  10. LEFT JOIN users_liked_restaurants
  11. ON users_liked_restaurants.restaurant_id = restaurants.restaurant_id
  12. WHERE users_liked_restaurants.user_id = 1
  13. AND NOT EXISTS (
  14. SELECT 1 FROM deleted
  15. WHERE deleted.restaurent_id = restaurants.restaurant_id
  16. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement