SELECT TOP 30 * FROM Classics where ZippoProductNumber NOT IN (SELECT TOP 45 ZippoProductNumber FROM Classics ORDER BY DisplayOrderInClass ASC) ORDER BY DisplayOrderInClass ASC