SELECT a.* FROM forum_msgs a
INNER JOIN (
SELECT TOP 20 BlockID FROM forum_msgs
WHERE owner_board_name = 'java' AND BlockLayerID = 0 ORDER BY date_msg DESC
) b
ON a.BlockID = b.BlockID
ORDER BY BlockOrderID