Someone
public text v1 · immutableSELECT t1.item_id, Max(t2.bid_id) AS bid_id
FROM Item AS t1 LEFT JOIN Bid AS t2 ON t1.item_id = t2.item_id WHERE t1.seller_id = ?
GROUP BY t1.item_id;
SELECT t1.item_id, Max(t2.bid_id) AS bid_id
FROM Item AS t1 LEFT JOIN Bid AS t2 ON t1.item_id = t2.item_id WHERE t1.seller_id = ?
GROUP BY t1.item_id;