Executing listAuction test AuctionID=3 Item Hillside home ItemID=3 Description Million dollar view, great sunsets. 5 bedroom, 3 bathroom home. Graphic file name=images/house.jpg Lowest price=500000.0 Seller's name is Bruce Martin Belinda Ruta bid 210000.0 Bruce Martin bid 300000.0 Chato P\u00e9rez bid 325000.0 Margaret Martin bid 375000.0 Francis Martin bid 400000.0 Mark Smith bid 450000.0 Mamoru Kondo bid 500000.0 Oscar Leon bid 520000.0 Petra Hernandez bid 540000.0 Ian Walker bid 600000.0 Julio Regalado bid 610000.0 Jens Pedersen bid 680000.0 Nadia Papaconstantino bid 710000.0 Craig Vieregg bid 800000.0 20295294 |0|0|statement||SELECT DISTINCT t1.LOW_PRICE, t1.AUCTION_ID, t1.ITEM, t1.SELLER, t0.GRAPHIC_FILENAME, t0.ITEM_ID, t0.DESCRIPTION, t0.ITEM_NAME, t2.AMOUNT, t2.BID_ID, t2.VERSION, t2.MAX_AMOUNT, t2.BUYER, t2.AUCTION, t3.USER_ID FROM AUCTION_USER t3, BID t2, AUCTION t1, ITEM t0 WHERE ((t1.AUCTION_ID = '3') AND (((t0.ITEM_ID (+) = t1.ITEM) AND (t2.AUCTION (+) = t1.AUCTION_ID)) AND (t3.USER_ID (+) = t2.BUYER))) 20295294 |0|0|commit||