WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT t.*, tt.* FROM wpnf_terms AS t INNER JOIN wpnf_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wpnf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (94101) ORDER BY t.term_order ASC

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT t.*, tt.* FROM wpnf_terms AS t INNER JOIN wpnf_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wpnf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (94101) ORDER BY t.term_order ASC

Shot K10 2.0 MX Boots Kids - Black/White/Neon Yellow - UK 13 / EUR 32 - Motorcycle Website

Shot K10 2.0 MX Boots Kids – Black/White/Neon Yellow – UK 13 / EUR 32

£119.99

K10 2.0 boot from the performance SHOT Race Gear protection range. This feature-packed kids MX boot delivers great on-track performance, comfort and protection.

Available on backorder

SKU: SMXFWG032 Categories: ,

SMXFWG032 Shot K10 2.0 MX Boots Kids – Black/White/Neon Yellow – UK 13 / EUR 32

K10 2.0 boot from the performance SHOT Race Gear protection range. This feature-packed kids MX boot delivers great on-track performance, comfort and protection.

Key Features

Anatomic pre-curved chassis in premium synthetic leather|Lightweight and robust|Injected molded plastic shin protection|3 replaceable double lock buckles with micrometric adjustment straps|Reinforced vamp|Medial specially designed to increase abrasion resistance and provide better bike control|Replaceable metal toe-piece|Comfortable and breathable liner|Protective ankle with cushioned inserts|Double stitched rubber sole provides better shock absorption, grip and good feeling of footpegs|

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT DISTINCT t.*, tt.* FROM wpnf_terms AS t LEFT JOIN wpnf_termmeta ON ( t.term_id = wpnf_termmeta.term_id AND wpnf_termmeta.meta_key='order') INNER JOIN wpnf_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wpnf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('product_cat') AND tr.object_id IN (94105) AND ( ( wpnf_termmeta.meta_key = 'order' OR wpnf_termmeta.meta_key IS NULL ) ) ORDER BY t.term_order ASC

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT t.*, tt.* FROM wpnf_terms AS t INNER JOIN wpnf_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wpnf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('product_tag') AND tr.object_id IN (94105) ORDER BY t.term_order ASC

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT t.*, tt.* FROM wpnf_terms AS t INNER JOIN wpnf_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wpnf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('product_shipping_class') AND tr.object_id IN (94105) ORDER BY t.term_order ASC

Related products

Scroll to Top
Scroll to Top