WELCOME SKATEBOARDS

Welcome Skateboards is a relatively new skateboard company born in 2010. Whilst wildly passionate about skateboarding culture, creativity and individuality, Welcome Skateboards create skateboards, parts and clothing to stand out. Authenticity is at the heart of all designs. If you are looking for a brand which truly represents the subculture and art of skating, then check out Welcome Skateboards. Our selection of Welcome Skateboards decks, wheels and t shirts contain unique and colourful designs which display the innovative nature behind the brand. Welcome Skateboards are based in the UK. Shop the collection now and get free delivery on all orders over £40.

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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 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 (238007, 238004, 238008, 111694, 112322, 112628, 112630, 112638, 161741, 164093, 164094, 164095, 164096))) AND (e.created_in <= '1638957602') AND (e.updated_in > '1638957602') ORDER BY FIELD(e.entity_id,238007,238004,238008,111694,112322,112628,112630,112638,161741,164093,164094,164095,164096)