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` = 100) WHERE (`e`.`entity_id` IN('3213', '3214', '3385', '3387')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') CALIFORNIA PROGRESS GRAY SEAL COLORANT - TINTING COLORS - PAINTS - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

CALIFORNIA PROGRESS GRAY SEAL COLORANT


View as Grid List

12 items

Page
per page
Set Descending Direction
  1. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7900 AXX COLORANT EXT YEL Learn More
  2. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7925 F COLORANT RED IRON OX Learn More
  3. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7950 SG COLORANT MED YEL Learn More
  4. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7915 D COLORANT THALO GREEN Learn More
  5. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7955 M COLORANT MAGENTA Learn More
  6. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7905 B COLORANT LAMP BLACK Learn More
  7. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7930 I COLORANT BRN IRON OX Learn More
  8. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7935 COLORANT WHITE Learn More
  9. CUSTOM COLOR COLORANTS
    $44.29 /QT
    7920 E COLORANT THALO BLUE Learn More
View as Grid List

12 items

Page
per page
Set Descending Direction