WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT t.*, tt.*, tr.object_id 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', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class', 'pa_color', 'pa_size') AND tr.object_id IN (106759) 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', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class', 'pa_color', 'pa_size') AND tr.object_id IN (106759) 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 ('category') AND tr.object_id IN (106759) 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 (106759) ORDER BY t.term_order ASC

Shot Adult Contact Gloves - Shadow Grey Neon Yellow - XL (11) - Motorcycle Website

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SHOW FULL COLUMNS FROM `wpnf_postmeta`

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SHOW FULL COLUMNS FROM `wpnf_postmeta`

WordPress database error: [Can't find file: '/tmp/#sql_361_8.MAI' (errno: 2 "No such file or directory")]
SELECT p.ID, p.post_name, pm.meta_value FROM wpnf_postmeta as pm INNER JOIN wpnf_posts as p ON pm.post_id = p.ID WHERE pm.meta_key = '_bsf-sb-location' AND p.post_type = 'bsf-sidebar' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"basic-global"%' OR pm.meta_value LIKE '%"basic-singulars"%' OR pm.meta_value LIKE '%"product|all"%' OR pm.meta_value LIKE '%"post-106759"%') ORDER BY p.post_date DESC

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_cat') AND tr.object_id IN (106759) ORDER BY t.term_order DESC

Shot Adult Contact Gloves – Shadow Grey Neon Yellow – XL (11)

£26.99

From Shot Race Gear’s advanced kit range, Contact gloves are used by some of the world’s best riders and factory teams in Motocross and Enduro. Highly technical design and materials deliver incredible lightweight comfort, performance and ventilation in both competition and training.

Available on backorder

SKU: SMXGVE050

SMXGVE050 Shot Adult Contact Gloves – Shadow Grey Neon Yellow – XL (11)

From Shot Race Gear’s advanced kit range, Contact gloves are used by some of the world’s best riders and factory teams in Motocross and Enduro. Highly technical design and materials deliver incredible lightweight comfort, performance and ventilation in both competition and training.

Key Features

New adjusted fit|Liteprene panels for optimal comfort|Articulated lycra thumb gusset|Reinforced thumb|3D mesh fingers for optimal airflow|Lycra finger gusset for perfect fit|Velcro adjustable wrist closure|Grotech palm reinforced in suede|Silicon fingers prints for optimal grip and control|TPR patches finish|Never fading color sublimation process|

Scroll to Top
Scroll to Top