SELECT c.SALEDAY,c.SALEDATE,c.LOTNUMBER,c.LOTSALETIME,d.AUCTIONID,d.NUMBEROFSALEDAYS,d.AUCTIONSTARTTIMEZONE,
CASE WHEN d.SALENAME IS NULL
THEN CASE WHEN d.SALETYPE = 'Video Sale' THEN 'SLA Video Auction' ELSE CASE WHEN d.SALETYPE = 'Stampede Internet Sale' THEN 'SLA Internet Auction' ELSE '' END END ELSE
d.SALENAME END AS NAME
FROM SLACONTRACT as c
JOIN AUCTIONDATE d ON c.SALEDATE = d.SALEDATE
WHERE c.LOTNUMBER != ''
AND c.SALEDATE = (SELECT MIN(SALEDATE) FROM slacontract WHERE SALETYPE NOT IN ('','Country Page','Private Treaty') AND SALEDATE > dateAdd(day,-1,getDate()) )
AND c.LOTNUMBER != 'NULL'
AND c.LOTSALEORDER is not NULL
AND d.CATALOGRELEASED = 1
AND d.ISDAIRY != 1
AND c.SALETYPE = d.SALETYPE
ORDER BY SALEDAY ASC, LOTSALEORDER ASC
