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` = '46') 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` = '46') AND (`at_is_active`.`store_id` = 90) WHERE (`e`.`entity_id` IN('1460', '1461', '1467')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') PRUNING AND FLORAL SHEARS - PRUNING & TRIMMING TOOLS - LAWN AND GARDEN
  1. See Detail

PRUNING AND FLORAL SHEARS


View as Grid List

20 items

Page
per page
Set Descending Direction
  1. DELUXE RATCHET PRUNER Call for Price
    LG3185 8" RACHET PRUNER Learn More
  2. KENYON BYPASS PRUNER Call for Price
    41403 KENYON BYPASS PRUNER Learn More
  3. FORGED CLASSIC BYPASS PRUNER Call for Price
    BP3160 FORGED CLASSIC BYPASS PRUNER Learn More
  4. BYPASS PRUNER Call for Price
    RB474A-B BYPASS PRUNER (BLUE) Learn More
  5. TRADITIONAL PRUNER Call for Price
    91095935J TRADI PRUNER Learn More
  6. ANVIL PRUNER Call for Price
    AP3110 ANVIL PRUNER Learn More
  7. RATCHET PRUNER Call for Price
    RP3230 RATCHET PRUNER Learn More
  8. SMOOTH ANVIL PRUNER Call for Price
    91156935 ANVIL PRUNER Learn More
  9. FORGED PRUNER Call for Price
    92756965J FORGED PRUNER Learn More
View as Grid List

20 items

Page
per page
Set Descending Direction