Emaze Auction: Delete Lot
You have chosen to delete lot #lotID#:
#lotName#

Are you sure you want to delete this lot?
If yes, click the button below. Otherwise, simply back up to the previous page.

SELECT Count(lotID) AS checkCount FROM Lot WHERE lotImage = '#lotImage#' OR lotImageThumbnail = '#lotImage#' SELECT Count(lotID) AS checkCount FROM Lot WHERE lotImage = '#lotImageThumbnail#' OR lotImageThumbnail = '#lotImageThumbnail#' DELETE FROM Lot WHERE lotID = #Form.lotID# DELETE FROM Bid WHERE lotID = #Form.lotID# DELETE FROM LotWatch WHERE lotID = #Form.lotID# DELETE FROM PrivateLotUser WHERE lotID = #Form.lotID# UPDATE Category SET categoryLotCount = categoryLotCount - 1 WHERE categoryID = #Form.categoryID# SELECT categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #Form.categoryID# UPDATE Category SET categorySubLotCount = categorySubLotCount - 1 WHERE categoryID = #getCatID.categoryID1# OR categoryID = #getCatID.categoryID2# OR categoryID = #getCatID.categoryID3# OR categoryID = #getCatID.categoryID4#

Lot #Form.lotID# deleted.

Image #lotImageFile# deleted from lotimage directory since it was not being used by any other lots.
 Image #lotImageFileThumbnail# deleted from lotimage directory since it was not being used by any other lots.