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

This Green Japanese Glass Ball Fishing Float With White Netting Decoration 10" is a perfect piece of beach wall art. Gorgeous whether in your home or office, enjoy the charming inner warmth of this buoy float as lights play through the green glass ball. Perfectly contrasting the glass float is the authentic fishing rope netting which holds the float in place. Mesmerizing and enchanting, enjoy the historic wonder and brilliant style of this nautical glass float each and every day.