2: select PRODUCTS.PRODUCT_ID from PRODUCTS join PRODUCT_BRIDGE on PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID join CATEGORY_BRIDGE on CATEGORY_BRIDGE.CATEGORY_ID=PRODUCT_BRIDGE.CATEGORY_ID join PRODUCT_CATEGORIES on PRODUCT_CATEGORIES.PRODUCT_CATEGORY_ID=CATEGORY_BRIDGE.CATEGORY_ID where PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' and CATEGORY_BRIDGE.SUPER_ID='362' order by PRODUCT_BRIDGE.ORDER ASC

Antique Copper Handle Magnifier Key Chain 4"

This nautical-themed key chain is both adorable and functional, featuring an antique copper monocle/magnifying glass key fob. Crafted with an antique copper finish, this key chain is as beautiful as it is durable and functional with a knurled knob that allows you to easily and securely add or remove keys from the ring. These wonderful key chains make ideal gifts for all.