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

Iron Tavern Oil Lamp 10" - Dark Blue

This Iron Tavern Oil Lamp 10" - Dark Blue is an authentic marine ship lamp. Handcrafted from cast iron creating an authentic tavern lamp, as was often used in the 19th century to assist in lighting dim or dark areas. This ship lantern is true to the original design of period lamps. Our boat lantern is fully functional and simply needs oil to omit light.