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 Belinda Ruta Bruce Martin bid 300000.0 Nadia Papaconstantino bid 710000.0 Belinda Ruta bid 210000.0 Petra Hernandez bid 540000.0 Jens Pedersen bid 680000.0 Francis Martin bid 400000.0 Julio Regalado bid 610000.0 Oscar Leon bid 520000.0 Margaret Martin bid 375000.0 Mark Smith bid 450000.0 Ian Walker bid 600000.0 Craig Vieregg bid 800000.0 Chato Pérez bid 325000.0 Mamoru Kondo bid 500000.0 -1133534024 |0|0|statement||SELECT WL0.AUCTION_ID, WL0.LOW_PRICE, WL0.ITEM, WL0.SELLER , WL1.ITEM_ID, WL1.DESCRIPTION, WL1.GRAPHIC_FILENAME, WL1.ITEM_NAME, WL0.ITEM , WL2.BID_ID, WL2.AMOUNT, WL2.MAX_AMOUNT, WL2.AUCTION, WL2.BUYER, WL2.AUCTION , WL3.USER_ID, WL2.BUYER , WL4.USER_ID, WL0.SELLER FROM AUCTION WL0 LEFT OUTER JOIN BID WL2 ON WL0.AUCTION_ID = WL2.AUCTION LEFT OUTER JOIN AUCTION_USER WL3 ON WL2.BUYER = WL3.USER_ID LEFT OUTER JOIN ITEM WL1 ON WL0.ITEM = WL1.ITEM_ID LEFT OUTER JOIN AUCTION_USER WL4 ON WL0.SELLER = WL4.USER_ID WHERE ( WL0.AUCTION_ID = '3' ) -1133534024 |0|0|commit||