WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT wpnf_posts.* FROM wpnf_posts INNER JOIN wpnf_postmeta ON ( wpnf_posts.ID = wpnf_postmeta.post_id ) WHERE 1=1 AND ( ( wpnf_postmeta.meta_key = 'spectra-popup-enabled' AND wpnf_postmeta.meta_value = '1' ) ) AND wpnf_posts.post_type = 'spectra-popup' AND (wpnf_posts.post_status = 'publish') GROUP BY wpnf_posts.ID ORDER BY wpnf_posts.post_date DESC

Shot X10 2.0 MX Boots Adult – Black/Red/White/Yellow – UK 11 / EUR 46

£159.99

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

Available on backorder

SKU: SMXFWA046 Categories: ,

SMXFWA046 Shot X10 2.0 MX Boots Adult – Black/Red/White/Yellow – UK 11 / EUR 46

X10 2.0 boot from the performance SHOT Race Gear protection range. This feature-packed 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 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 (94151) 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_type') AND tr.object_id IN (94161) 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_visibility') AND tr.object_id IN (94161) 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 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 (94161) AND ( ( wpnf_termmeta.meta_key = 'order' OR wpnf_termmeta.meta_key IS NULL ) ) ORDER BY t.term_order ASC

Related products

Scroll to Top
Scroll to Top