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('1977', '2216', '2223', '2226')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') CANNING TOOLS AND ACCESSORIES - CANNING JARS & SUPPLIES - FREEZING, CANNING/BOTTLING EQUIP - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

CANNING TOOLS AND ACCESSORIES


View as Grid List

8 Items

per page
Set Descending Direction
  1. GULFWAX HOUSEHOLD PARAFFIN WAX Call for Price
    3714425/3714433/GULFWAX Learn More
  2. JAR & BOTTLE VISE Call for Price
    5648 JAR/BOTTLE VISE Learn More
  3. 7 FUNCTION CANNING KIT Call for Price
    9995 7 FUNC CANNING KIT Learn More
  4. JAR LIFTER Call for Price
    5645 JAR LIFTER Learn More
  5. 5 PC CANNING SET Call for Price
    5250 CANNING SET Learn More
  6. WIRE TWIST TIE Call for Price
    LG50000 WIRE TWIST TIE Learn More
  7. 4PC BAG CLIPS SET Call for Price
    K0111 PLST BAG CLIPS (ST 4) Learn More
  8. WAGES HOME CANNING GUIDE Call for Price
    0103J4255 HOME CANNING GUID Learn More
View as Grid List

8 Items

per page
Set Descending Direction