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', '3215', '3258')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') RUSTOLEUM AND ZINSSER EXTERIOR PRIMER PAINT - EXTERIOR PAINTS (NOT ROOF & FLOORS) - PAINTS - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

RUSTOLEUM AND ZINSSER EXTERIOR PRIMER PAINT


View as Grid List

9 Items

per page
Set Descending Direction
  1. PROFESSIONAL ALUMINUM PRIMER
    $14.09 /QT
    8781 QT ALUMINUM PRIMER Learn More
  2. COVER STAIN OIL BASED PRIMER SEALER
    $9.25 /QT
    03504 QT COVER-STAIN PRIMER Learn More
  3. PLASTIC PRIMER
    $16.05 /QT
    213517 QT PLASTIC PRIMER WH Learn More
  4. MAGNETIC PRIMER
    $28.85 /QT
    247596 QT MAGNETIC PRIMER Learn More
  5. COVER STAIN¨ OIL BASED PRIMER SEALER
    $5.89 /EA
    03608 13OZ COVERSTAIN PRIMER Learn More
  6. COVER STAIN OIL BASED PRIMER SEALER
    $24.95 /GA
    03501 GAL COVER-STAIN PRIMER Learn More
  7. HIGH HIDE COVER STAIN OIL BASE PRIMER SEALER
    $30.59 /GA
    03551 GAL HH C.STAIN PRIMER Learn More
  8. BULLS EYE 1-2-3 DEEP TINT WATER-BASE PRIMER-SEALER
    $30.59 /GA
    02031 GAL DEEP TINT PRIMER Learn More
  9. HIGH HIDE COVER STAIN OIL BASE PRIMER SEALER
    $10.39 /QT
    03554 QT HH C.STAIN PRIMER Learn More
View as Grid List

9 Items

per page
Set Descending Direction