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

From handheld Brass Spyglasses to magnificent Brass Astro Telescopes, Handcrafted Nautical Décor invites you to explore our fabulous collection and find the perfect instrument for you. Invented in the 1600s, the telescope was a tool of rare power and import, drastically changing the course of human civilization. Whether for actual use aboard a ship, to gaze up at the stars from your balcony, or perhaps as sophisticated nautical décor in the office, each of these telescopes is a true delight.

[CATEGORY_FOOTER] =>

From handheld Brass Spyglasses to magnificent Brass Astro Telescopes, Handcrafted Nautical Décor invites you to explore our fabulous collection and find the perfect instrument for you. Invented in the 1600s, the telescope was a tool of rare power and import, drastically changing the course of human civilization. Whether for actual use aboard a ship, to gaze up at the stars from your balcony, or perhaps as sophisticated nautical décor in the office, each of these telescopes is a true delight.

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='463' 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 Brass Telescopes & Spyglasses Models

Brass Telescopes & Spyglass Models

From handheld Brass Spyglasses to magnificent Brass Astro Telescopes, Handcrafted Nautical Décor invites you to explore our fabulous collection and find the perfect instrument for you. Invented in the 1600s, the telescope was a tool of rare power and import, drastically changing the course of human civilization. Whether for actual use aboard a ship, to gaze up at the stars from your balcony, or perhaps as sophisticated nautical décor in the office, each of these telescopes is a true delight.