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