SELECT *
FROM [Item], [Category], [Bid]
WHERE [Item].[item_id] = [Bid].[item_id]
AND [Item].[category_id] = [Category].[category_id]
AND [Bid].[bid_id] = 
(
SELECT TOP 1 [QB].[bid_id] 
FROM [Bid] AS [QB]
WHERE [QB].[item_id] = [Item].[item_id] 
ORDER BY [QB].[bid_id] DESC
)
AND [Item].[item_id] IN
(
   SELECT [Item].[item_id]
   FROM [Item], [Bid]
   WHERE [Item].[item_id] = [Bid].[item_id]
   AND [Bid].[bidder_id] = ?
)