Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT *, max(post_date) FROM posts
  2. WHERE user_id IN ($matches)
  3. GROUP BY user_id
  4. ORDER BY post_date DESC
  5.  
  6. SELECT p.*
  7. FROM posts p
  8. JOIN(
  9. SELECT user_id , max(post_date) post_date
  10. FROM posts
  11. GROUP BY user_id
  12. ) pp
  13. USING(user_id,post_date)
  14. WHERE pp.user_id IN ($matches) /* i assume here you have user ids like IN (1,2,3)*/
  15. ORDER BY p.post_date DESC
  16.  
  17. "SELECT *, max(post_date) FROM posts
  18. WHERE user_id IN (".implode(',',$matches).")
  19. GROUP BY user_id
  20. ORDER BY post_date DESC "
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement