SELECT b.LOT_NR, r.FIRSTNAME || ' ' || r.SURNAME AS WINNER_NAME, r.EMAIL, r.CELL_NR, b.BID_AMOUNT AS WINNING_BID, a.ANI_ID, a.QTY_STRAWS, SUBSTR(a.KI_CODE, -3) AS BREED, CASE TO_CHAR(a.KI_CENTRE_PAR_ID) WHEN '1' THEN 'Ramsem' WHEN '2' THEN 'Geneco' ELSE 'Unknown' END AS STATION FROM ruan.GSA_BIDS b JOIN ruan.GSA_REGISTER r ON b.USR_ID = r.ID JOIN ruan.GSA_AUCTIONS_ANIMAL a ON b.AUCTION_ID = a.FK_AUCTION_ID AND b.LOT_NR = a.LOT_NR WHERE b.AUCTION_ID = 'GSA-251127111809' AND b.BID_AMOUNT = ( SELECT MAX(BID_AMOUNT) FROM ruan.GSA_BIDS WHERE AUCTION_ID = 'GSA-251127111809' AND LOT_NR = b.LOT_NR ) ORDER BY b.LOT_NR ASC

AUCTION 2

Ended on: 28-NOV-25

Total Lots Sold: 2

Winner
RICUS KRAUSE

Winning Bid: R410.00

Total Bids: 5

Winner
MARTIN PIEK

Winning Bid: R110.00

Total Bids: 1