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

More Products Like This One

Solid Brass Mess Sign 6"

Ideal for posting in a boat, boathouse, or any room in the home or office, this solid brass Mess Sign 6" clearly lets everyone know where their favorite room, the kitchen, is! Handcrafted from sailing's traditional brass, with stylish brass framing, this shining sign has a classy nautical appeal, with bold and clear lettering on a solid brass face.