Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- friendship_id request_from request_to friendship_status
- 1 111248 111249 1
- 2 111209 111249 1
- 3 111209 111248 0
- 11 111209 111259 1
- 5 111252 111209 1
- 12 111261 111209 1
- SELECT * FROM users_status WHERE userid = "$userid"
- OR userid in (SELECT request_to FROM friendships where request_from = "$userid" AND friendship_status = 1)
- OR userid in (SELECT request_from FROM friendships where request_to = "$userid" AND friendship_status = 1)
- PENDING_FRIENDSHIPS(request_from, request_to)
- FRIENDSHIPS(request_from, request_to)
- select * from friendships
- where $currentUser = request_from OR $currentUser = request_to
- select request_from from friendships
- where request_to = $currentUser
- UNION
- select request_to from friendships
- where request_from = $currentUser
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement