ALIEN WORKSHOP

Reality Be Damned Alien Workshop was born Oct. 1990 from the concept of creating a different type of skateboard company. From inception, AWS’s approach has always been to operate on it’s own terms, allowing the deliberate isolation of it’s Ohio based HQ to inspire and influence it’s style and personality. The Alien Workshop team riders are as diverse and individualistic as the company’s identity. Rob Dyrdek was their first team rider and has been with the company since the first spark of ideas. Heath Kirchart, Grant Taylor, Omar Salazar, Dylan Rieder, Mikey Taylor, Tyler Bledsoe, Jake Johnson and Gilbert Crockett form the elite team that carry the Workshop torch to the streets worldwide. With 20 years of history and quality products under it’s belt, AWS continues to push and produce innovative skateboards and accessories with the same passion and drive as the day it was founded. Limitless by design.

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 (161778, 161779, 161780, 161781, 161783, 161784, 161785, 161786, 161787, 161791))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,161778,161779,161780,161781,161783,161784,161785,161786,161787,161791)