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` = 1) WHERE (`e`.`entity_id` IN('242', '7', '254')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Gloves & Pogies at AS Watersports, Exeter. Buy online or in-store!
Welcome to AS Watersports
My Cart
 

Gloves & Pogies

View as Grid List

8 Items

per page
Set Descending Direction
  1. Crewsaver Short Finger Glove
    £23.00
  2. Crewsaver Tri-Season Glove
    £26.00
  3. Alder Matrix Glove
    £19.95
  4. Alder Enzo Glove
    £23.99
  5. Palm Grab Gloves
    £20.66
  6. Yak Open Palm Mitt
    £20.00
  7. Palm Current Mitts
    Special Price £35.96 Regular Price £39.95
  8. Palm Descent Mitts
    Special Price £26.96 Regular Price £29.95
View as Grid List

8 Items

per page
Set Descending Direction