Emaze Auction: Lot Winners - All All Lot Winners in Category:
#categoryID# - #categoryName#
 Order by:
name (+) name (-) open time (+) open time (-) close time (+) close time (-) time created (+) time created (-) last edited (+) last edited (-)
Name Opens Closes Created (ID) Last edited
+   - +   - +   - +   - +   -
SELECT Lot.lotID, Lot.lotName, Lot.lotStatus, Bid.bidPrice, Bid.bidQuantityWin, Bid.userID, Member.email, Member.firstName, Member.lastName FROM (Bid INNER JOIN Lot ON Bid.lotID = Lot.lotID) INNER JOIN Member ON Bid.userID = Member.userID WHERE Bid.bidWin = 1 AND Lot.categoryID = #categoryID# ORDER BY Lot.#order#
ID Lot Name Bid # Total User Status
#lotID# #lotName# #LSCurrencyFormat(bidPrice,"local")# #bidQuantityWin# #LSCurrencyFormat(bidPrice * bidQuantityWin,"local")# #firstName# #lastName# #lotStatus#