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', '2217', '2221')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') VACUUM SEAL BAGS AND KITS - FREEZING CONTAINERS & SUPPLIES - FREEZING, CANNING/BOTTLING EQUIP - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

VACUUM SEAL BAGS AND KITS


View as Grid List

6 Items

per page
Set Descending Direction
  1. VAC SEALER BAGS ROLL Call for Price
    300011W VAC SEALER BAGS RL Learn More
  2. VAC SEALER BAGS ROLL 3 PACK Call for Price
    300201W VAC SEALER BAGS 3PK Learn More
  3. VAC SEALER BAGS Call for Price
    300102W VAC SEALER BAGS Learn More
  4. VAC SEALER BAGS Call for Price
    300101W VAC SEALER BAGS Learn More
  5. HARVEST GUARD VAC SEALER Call for Price
    651001W HARVEST VAC SEALER Learn More
  6. PROFESSIONAL VAC SEALER Call for Price
    650501W PROFF VAC SEALER Learn More
View as Grid List

6 Items

per page
Set Descending Direction