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

Ceramic Red Lighthouse Tower Bell 8"

The Ceramic Red Lighthouse Tower Bell 8" is the perfect blend of nautical and lighthouse decor. Put this lighthouse tower bell up on your wall as it greets your visitors with a nautical appeal and provides a beautiful aesthetic. Designed for anyone with a lighthouse affinity.