3: SELECT PRODUCTS.PRODUCT_ID FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='464' 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

Whether you wish to view the world from your ship with a Chrome Spyglass, or take in stars with a Chrome Astro Telescope, Handcrafted Nautical Décor welcomes you to find the perfect one for your home, office, or captain’s cabin. A nautical classic with a modern flare, these stunning chrome telescopes seamlessly blend sophistication and style. Each of these amazing telescopes is both a modern instrument and a beautiful work of art, a magnificent and instant classic that even a Royal Navy captain would consider piracy for, just to claim one as his own.

[CATEGORY_FOOTER] =>

Whether you wish to view the world from your ship with a Chrome Spyglass, or take in stars with a Chrome Astro Telescope, Handcrafted Nautical Décor welcomes you to find the perfect one for your home, office, or captain’s cabin. A nautical classic with a modern flare, these stunning chrome telescopes seamlessly blend sophistication and style. Each of these amazing telescopes is both a modern instrument and a beautiful work of art, a magnificent and instant classic that even a Royal Navy captain would consider piracy for, just to claim one as his own.

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

Similar to Chrome Telescopes & Spyglasses

Chrome Telescopes & Spyglasses

Whether you wish to view the world from your ship with a Chrome Spyglass, or take in stars with a Chrome Astro Telescope, Handcrafted Nautical Décor welcomes you to find the perfect one for your home, office, or captain’s cabin. A nautical classic with a modern flare, these stunning chrome telescopes seamlessly blend sophistication and style. Each of these amazing telescopes is both a modern instrument and a beautiful work of art, a magnificent and instant classic that even a Royal Navy captain would consider piracy for, just to claim one as his own.