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

More Products Like This One

Antique Copper Ship Wheel Christmas Ornament 5"

Gather 'round and celebrate the holidays with this Antique Copper Ship Wheel Christmas Tree Ornament 5". Perfectly combining the warmth of the holiday season and the nautical sea-faring lifestyle, this anchor decoration lights up any tree and adds the final nautical touch your Christmas needs. This nautical themed ship wheel Christmas tree ornament easily hangs and is sure to stand out on this year's Christmas tree.

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