DB Tips

How to find user by device ID

Change X to know device ID:

select users.* from users join devices on (users.id = devices.user_id) where devices.id = X;