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