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('1460', '1511', '1513', '1531')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LAWN MOWER SEATS AND ACCESSORIES - TRACTOR & MOWER REPL. PARTS - LAWN & GARDEN TRACTORS - LAWN AND GARDEN
  1. See Detail

LAWN MOWER SEATS AND ACCESSORIES


View as Grid List

2 Items

per page
Set Descending Direction
  1. DELUXE MOWER COVER Call for Price
    334510 DELUXE MOWER COVER Learn More
  2. TRACTOR SEAT COVER Call for Price
    334550 LWN TRACTOR SEAT COV Learn More
View as Grid List

2 Items

per page
Set Descending Direction