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('6295')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AUTOMOTIVE SUPPLIES
  1. See Detail

AUTOMOTIVE SUPPLIES


View as Grid List

468 items

Page
per page
Set Descending Direction
  1. STP OIL TREATMENT
    $5.55 /EA
    65148 STP OIL TREATMENT 15 Learn More
  2. BAR'S LEAK RADIATOR STOP LEAK
    $4.45 /EA
    BARS1196 LEAK RAD STOP11OZ Learn More
  3. BAR'S LEAKS ENGINE OIL STOP LEAK
    $3.95 /EA
    BARS1010 ENGINE OIL STOP Learn More
  4. BAR'S LEAKS LIQUID ALUMINUM
    $7.45 /EA
    BARS1420 LIQUID STOP 16.9 Learn More
  5. FUEL STABILIZER
    $8.95 /EA
    M5808/6 FUEL STABILIZER Learn More
  6. MARINE STABIL
    $11.35 /EA
    22239 8OZ STA-BIL MARINE Learn More
  7. MARINE STABIL
    $28.75 /EA
    22240 32OZ STA-BIL MARINE Learn More
  8. LIQUID FIRE QUICK STARTING FLUID
    $3.95 /EA
    M3911 LIQ FIRE START FLUID Learn More
  9. FUEL INJECTOR CLEANER
    $3.45 /EA
    M49-12 FUEL INJECTOR CLEANR Learn More
View as Grid List

468 items

Page
per page
Set Descending Direction