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#