All pastes #424710 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-04-04 23:12 UTC
rendered paste body
SELECT *
FROM [SELECT *
FROM [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]. AS d1 LEFT JOIN Item AS t3 ON t3.item_id = d1.item_id]. AS d2 LEFT JOIN Bid AS t4 ON t4.Bid_id = d2.bid_id;