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='466' order by PRODUCT_BRIDGE.ORDER ASC

Antique Gold Cast Iron Decorative Turtle Bottle Opener 4"

The Hampton Nautical Rustic Cast Iron Turtle Bottle Opener 4" is the perfect addition to any beach themed kitchen. This solid iron bottle opener will open even the most difficult of bottles with ease. This bottle opener is fully functional and a great gift for a coworker, classmate, friend, or family member.

Key Features:

Wonderful turtle decoration

Handcrafted from solid cast iron

Perfect for the true nautical enthusiast

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