SELECT Lot.lotID, Lot.lotName, Lot.categoryID, Lot.lotBold, Lot.lotType, Category.categoryName
FROM Category INNER JOIN Lot ON Category.categoryID = Lot.categoryID
WHERE Lot.lotCloseQueue = 1
AND Lot.lotFeaturedHomepage = 1
AND Lot.lotOpenDateTime BETWEEN #lotDateTime1# AND #lotDateTime2#
AND Lot.lotCloseDateTime BETWEEN #lotDateTime1# AND #lotDateTime2#
AND lotType = 0
AND lotType = -1
AND lotType = 1
AND Lot.categoryID = #categoryID#
ORDER BY Category.categoryName, Lot.lotType DESC, Lot.lotName
#lotsFeaturedNone#
#lotsOpeningTodayNone#
#lotsClosingTodayNone#
#lotsOpenNone#