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

Oil-Rubbed Bronze Whistle Key Chain 5"

This nautical-themed key chain is both adorable and functional, featuring an oil rubbed bronze bosun's whistle (or "bosun's pipe") key fob. Crafted with a bronze 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.