1: 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='1153' AND PRODUCTS.WHOLESALE='1' order by PRODUCT_BRIDGE.ORDER ASC

Chrome Ship Wheel Compass Key Chain 5"

This nautical-themed key chain is both adorable and functional, featuring a ship helm wheel with compass key fob. Crafted from solid chrome, this key chain is as beautiful as it is durable and functional. A knurled knob allows you to easily and securely add or remove keys from the ring. These wonderful key chains make ideal gifts for friends, family, employees, clients, co-workers, and especially yourself.

Key Features:

Solid chrome keyring and body

Knurled knob makes changing keys easy and secure

Fully functional compass is in the shape of a ships wheel

Overall length is total of ring, chain, and symbol lengths

WARNING: This product can expose you to chemicals including Formaldehyde, and Styrene, which are known to the State of California to cause cancer, and Chromium and Toluene, which are known to the State of California to cause birth defects or other reproductive harm. For more information go to www.P65Warnings.ca.gov