[CODE=SQL] SELECT TOP 10 @MaxBlockID = MAX(BlockID), @MinBlockID = MIN(BlockID) SELECT BlockID FROM forum_msgs WHERE board_name = 'java' AND BlockLayerID = 0 AND BlockID < @PagedBlockID ORDER BY BlockID DESC SELECT * FROM forum_msgs WHERE board_name = 'java' AND @MinBlockID <= BlockID AND BlockID <= @MaxBlockID ORDER BY BlockID DESC, BlockOrderID [/CODE]