Limit SQL query by users

[ZiNgA BuRgA]

???
You mean limit the number of results the above query can return for each distinct uid?  No other limits whatsoever?
Basically, you want the latest things for each user?

If it's one uid, it can be done (use GROUP BY clause).  More than one is a difficult thing to accommodate with SQL.
http://stackoverflow.com/questions/15376...http://stackoverflow.com/questions/1537606/mysql-group-by-with-top-n-number-of (see 2nd answer)