
Your search for "vans old skool" has 27 results
Filter By
Current Filters
- Main Colour Black Remove This Item
Category
Sleeve Length
Material Secondary
Variant Size
Channel Filters
Stock At Supplier
Cross Sell Type
Reporting Status
B-Stock
Purchaser
Google Feed Margin Cat
Order In Active Shipping Group
Order In Product
Export
Export Common
Supplier Name
Is Gift Tier
Is Configurable Product
Longboard Shape
Clothing Style Tops & Shirts
Product Type Basic
- Balance Bikes1 item
- Bike Protectors1 item
- BMX Grips1 item
- Beanies2item
- Caps1 item
- Crews & Sweaters1 item
- T-Shirts2item
- Skate Shoes & Trainers6item
- Cruisers1 item
- Pad Sets1 item
- Roller Derby Skate Boots1 item
- Roller Skates - Detachable1 item
- Skateboard Accessories1 item
- Hoverkarts2item
- Skateboard Wheels3item
- Pogo Sticks2item
Department
Price
Brand Name
Product Type
- Bikes > Balance Bikes1 item
- Bikes > Bike Protectors1 item
- Bikes > BMX Grips1 item
- Clothes/Accessories > Beanies2item
- Clothes/Accessories > Caps1 item
- Clothes/Accessories > Crews & Sweaters1 item
- Clothes/Accessories > T-Shirts2item
- Footwear > Skate Shoes and Trainers6item
- Longboards > Cruisers1 item
- Protection > Pad Sets1 item
- Roller Derby > Roller Derby Skates - Boot Only1 item
- Skateboards > Accessories1 item
- Skateboards > Hoverkarts2item
- Skateboards > Wheels3item
- Toys > Pogo Sticks2item
- Roller Skates > Detachable Skates > Completes1 item
Sport
Grip Length
Shoe Size
- Size - UK 3.5 (EU 36)1 item
- Size - UK 4.5 (EU 37.5)3item
- Size - UK 5 (EU 38)1 item
- Size - UK 6 (EU 39)3item
- Size - UK 6.5 (EU 39.5)2item
- Size - UK 7 (EU 41)5item
- Size - UK 7.5 (EU 41.5)1 item
- Size - UK 8 (EU 42)4item
- Size - UK 9 (EU 43)4item
- Size - UK 9.5 (EU 43.5)1 item
- Size - UK 10 (EU 44)1 item
- Size - UK 10.5 (EU 45)1 item
- Size - UK 11 (EU 46)2item
Pad Size
Gender
Vegan
Longboard Length
Skate Type Boot
Skate Suitability
Age Group
Skate Plate Construction
Skateboard Wheel Size
Skate Closure System
Abec Rating
Size Adjustable?
Adjustable Stopper?
Light-up Wheels?
Skate Wheel Size
Material Primary
Skate Wheel Width
Builder Part
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'
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.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 (139189, 119288, 325298)) ORDER BY FIELD(e.entity_id,139189,119288,325298)
Showing 27 out of 27
View
Page
- Page Previous
- Page 1
- You're currently reading page 2


