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

Redfish Replica 42"

This stylish Redish Replica 42" fish mount is the perfect nautical or beach decor for any home, office, restaurant, or bar. Handcrafted Nautical Decor replicates each mounted fish by hand, using an actual fish as the template, and airbrushes each to resemble that particular species' distinct color patterns. Each replica's overall length is determined by measuring from the tip of the mouth, along the lateral line to the fork in the tail, then running the distance from the fork to the end of the longest tail length. True nautical classics, mounted fish are both excellent additions to any collection and unique conversation pieces in their own right.