Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. SELECT * FROM
  2. (
  3. SELECT p.post_id, p.post_message, UNIX_TIMESTAMP(p.date_posted) as date_posted, u.username FROM posts p
  4. INNER JOIN friend_match fm
  5. ON p.poster_id = fm.friend1
  6. INNER JOIN user_info u
  7. ON u.account_id = p.poster_id
  8. WHERE fm.friend2 = $sessionid
  9.  
  10. UNION ALL
  11.  
  12. SELECT p.post_id, p.post_message, UNIX_TIMESTAMP(p.date_posted) as date_posted, u.username FROM posts p
  13. INNER JOIN user_info u
  14. ON u.account_id = p.poster_id
  15. WHERE p.poster_id = $sessionid
  16. )z
  17. ORDER BY post_id DESC LIMIT $page,$limit";
  18.  
  19. SELECT * FROM posts p
  20. inner join user_info u ON u.account_id = p.poster_id
  21. WHERE p.poster_id = $sessionid or p.poster_id IN
  22. (SELECT f.friend1 FROM friend_match f
  23. WHERE f.friend2 = $sessionid)
  24. ORDER BY post_id DESC LIMIT $page, $limit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement