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

Rustic Cast Iron Sitting Mermaid 13"

This Rustic Cast Iron Sitting Mermaid 13" is the perfect addition for any beach themed home. Handcrafted from cast iron, this rustic mermaid is durable, and decorative. If you are looking for unique beach coastal decor, use this mermaid to show visitors your affinity for sea-life and beach decor.