SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('124', '127')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Opto-Mechanics - Clearance

Opto-Mechanics

4 Items

per page
Set Descending Direction

    No products found in this category.

    Part # Product Description Price In Stock QTYAdd to Cart
    53-2184-000 Compact Kinematic Mirror Mount, 1"

    $42.90

    $21.45

    Yes
    Part # Product Description Price In Stock QTYAdd to Cart
    53-3844-000 Co-Axial Swivel Clamp, Dual Half-Inch Posts

    $126.00

    $63.00

    Yes
    Part # Product Description Price In Stock QTYAdd to Cart
    53-2757-000 TopAdjust Mirror Mount, RMS Adapter

    $17.60

    $8.80

    Yes

4 Items

per page
Set Descending Direction
2025 Hyland Optical Technologies. EalingCatalog.com All Rights Reserved ©