AZTEK

Aztek provide some of the strongest and lightest scooter parts in the world. With such a strong focus on technology, Aztek hope to redefine freestyle skating, providing the highest quality parts at an affordable price point. Thanks to the use of high grade aluminium, all their parts are lightweight, but they maintain the maximum possible strength, meaning they’re perfect for any and every trick. If you’re looking for technical innovation, look no further than Aztek scooters. Aztek’s scooter wheels, headsets, handlebars and scooter decks are all highly innovative and designed for riders looking for big air and even bigger tricks. At SkateHut, our range of Aztek products includes everything from handlebars to scooter wheels, so you’re sure to find what you’re looking for when you shop with us. Why not take a look at the full Aztek range online today?

Loading...
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (98870, 99191, 99193, 99194, 99195, 101338, 101481, 101916, 102053, 102054, 102055, 102056, 102060, 102061, 102063, 102064, 102069, 102071, 102072, 102073, 102078, 102085, 102086, 102087))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,98870,99191,99193,99194,99195,101338,101481,101916,102053,102054,102055,102056,102060,102061,102063,102064,102069,102071,102072,102073,102078,102085,102086,102087)
Page