Guest User

Untitled

a guest
May 23rd, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. SELECT mt.id FROM maps_tiles mt
  2. WHERE mt.map_id=1
  3.             AND (mt.x BETWEEN 10 AND 16)
  4.             AND (mt.y BETWEEN 17 AND 23)
  5. AND mt.id NOT IN
  6. (SELECT mt.id
  7.             FROM users_tiles ut RIGHT JOIN maps_tiles mt ON ut.tile_id=mt.id
  8.             WHERE mt.map_id=1 AND (ut.user_id=1)
  9.             AND (mt.x BETWEEN 10 AND 16)
  10.             AND (mt.y BETWEEN 17 AND 23))
Add Comment
Please, Sign In to add comment