Hi,
I use Hibernate with JBoss Cache.
I have entities like below, All i want is to retrieve Last 20 messages posted by User's Friends.
UserEntity (Long id) FriendEntity (Long id, User user, Friend friend) MessageEntity(Long id, User owner, String message, Timestamp created);
(select * from messages where owner = 1 order by created DESC LIMIT 20) UNION ALL (select * from messages where owner = 2 order by created DESC LIMIT 20) UNION ALL (select * from messages where owner = 3 order by created DESC LIMIT 20) ... 997 more ... ORDER BY CREATED DESC LIMIT 20