3: SELECT PRODUCTS.PRODUCT_ID FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='41' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' GROUP BY PRODUCT_BRIDGE.PRODUCT_ID ORDER BY PRODUCT_BRIDGE.ORDER ASC

Ordered specifically by England’s King Charles I, the Sovereign of the Seas was destined to emerge as a picture perfect ship of war – both breathtaking to gaze upon and ferocious at sea. Launched in 1637, this 3-decked, first rate ship of the Royal Navy was lavished with gilded décor and carvings, and bristled with 102 guns made of solid bronze. Spectacularly recreated by Handcrafted Model Ships, these museum quality replicas exude every bit of the style and grace of the actual ship herself, from the delightful 14” model to the fabulous 39” Limited. Place this fabulous model ship above your mantel or in the office and enjoy her, as she is a true beauty to behold.

Ordered specifically by England’s King Charles I, the Sovereign of the Seas was destined to emerge as a picture perfect ship of war – both breathtaking to gaze upon and ferocious at sea. Launched in 1637, this 3-decked, first rate ship of the Royal Navy was lavished with gilded décor and carvings, and bristled with 102 guns made of solid bronze. Spectacularly recreated by Handcrafted Model Ships, these museum quality replicas exude every bit of the style and grace of the actual ship herself, from the delightful 14” model to the fabulous 39” Limited. Place this fabulous model ship above your mantel or in the office and enjoy her, as she is a true beauty to behold.

[CATEGORY_HEADER] =>

Ordered specifically by England’s King Charles I, the Sovereign of the Seas was destined to emerge as a picture perfect ship of war – both breathtaking to gaze upon and ferocious at sea. Launched in 1637, this 3-decked, first rate ship of the Royal Navy was lavished with gilded décor and carvings, and bristled with 102 guns made of solid bronze. Spectacularly recreated by Handcrafted Model Ships, these museum quality replicas exude every bit of the style and grace of the actual ship herself, from the delightful 14” model to the fabulous 39” Limited. Place this fabulous model ship above your mantel or in the office and enjoy her, as she is a true beauty to behold.

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='41' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' AND PRODUCTS.DISCONTINUED='' and PRODUCTS.ISDELETED='0' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC