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', '2257', '2275', '2282')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') GRAFFITI REMOVER - FABRIC & PAPER CLEANERS/CONDITIONERS - CLEANERS,SEALERS,WAXES,POLISHES - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

GRAFFITI REMOVER


View as Grid List

3 Items

per page
Set Descending Direction
  1. KRUD KUTTER GRAFITTI REMOVER Call for Price
    GR326 32OZ GRAFITTI REMOVER Learn More
  2. FABRIC SEAL Call for Price
    010502 11.5OZ FABRIC SEAL CL Learn More
  3. GRAFFITI REMOVER GEL Call for Price
    204249 32OZ GRAFFITI REMOVER Learn More
View as Grid List

3 Items

per page
Set Descending Direction