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

Board this exquisitely crafted tall ship model of Captain Kidd's Black Falcon pirate ship and sail into high seas adventure. This model tall ship is a worthy flagship for the commodore of a pirate fleet, and will impress all who look upon her with her fine craftsmanship and unrelenting detail while filling you with the spirit of high seas adventure. Let this masterful Black Falcon pirate tall model ship set her sails from a place of distinction in any home, office, or meeting room as you heave to and prepare to be boarded.

Extensive research of original plans, historical drawings, paintings, and actual photographs ensures the highest possible accuracy

WARNING: This product can expose you to chemicals including Formaldehyde, and Styrene, which are known to the State of California to cause cancer, and Chromium and Toluene, which are known to the State of California to cause birth defects or other reproductive harm. For more information go to www.P65Warnings.ca.gov