SELECT TOP 30 * FROM Harley_Davidson2009 WHERE ZippoProductNumber NOT IN (SELECT TOP 0 ZippoProductNumber FROM Harley_Davidson2009 ORDER BY DisplayOrderInClass ASC) ORDER BY DisplayOrderInClass ASC