SELECT *
FROM 
(
    SELECT *
    FROM 
    (
        SELECT Item.item_id, Max(Bid.bid_id) AS bid_id
        FROM Item 
        LEFT JOIN Bid
        ON Item.item_id = Bid.item_id 
        WHERE Item.seller_id = ?
        GROUP BY Item.item_id
    ) AS Q1 
    LEFT JOIN Item AS t3 
    ON t3.item_id = Q1.item_id
) AS d2 
LEFT JOIN Bid AS t4 
ON t4.Bid_id = d2.bid_id