Zippo - Product Category listing

SELECT TOP 30 * FROM Licensed_MPLs WHERE ZippoProductNumber NOT IN (SELECT TOP 0 ZippoProductNumber FROM Licensed_MPLs ORDER BY DisplayOrderInClass ASC) ORDER BY DisplayOrderInClass ASC Zippo - Product Category listing

select your country

No. 80000
Satin Silver™ MPL®

40-000266 Black MPL® Buy It Now	40-000268 Black MPL® Buy It Now	80003 Black MPL® Buy It Now	80000 Satin Silver™ MPL® Buy It Now	80 Black MPL® Buy It Now
40-000269 Black MPL® Buy It Now	40-000267 Black MPL® Buy It Now