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('6', '36')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ATLOW | Single Speed Simplicity
Toggle Nav
My Cart
Search
Advanced Search
  • Compare Products
  • Sign In

FORMED BY THE UK

FORMED BY THE UK

Menu
Account

ATLOW

SINGLE

SPEED

SIMPLICITY

ATLOW

As we adapt to the new normal you may find yourself searching for alternative means of transport.

The Atlow is a stylish bicycle in its simplest form. With its slender steel tubes, lightweight 28h wheels and single speed drivetrain, it is a practical, functional bike designed to provide hassle free cycling.

Atlow Video
Copyright © 2013-2017 Magento, Inc. All rights reserved.