Premier Sock Tape Shinguard Retainer Tape

Premier Sock Tape Shinguard Retainer Tape BLUE

Premier Sock Tape Shinguard Retainer Tape GREEN

Premier Sock Tape Shinguard Retainer Tape MAROON

Premier Sock Tape Shinguard Retainer Tape NAVY

Premier Sock Tape Shinguard Retainer Tape ORANGE

Premier Sock Tape Shinguard Retainer Tape RED

Premier Sock Tape Shinguard Retainer Tape ROYAL

Premier Sock Tape Shinguard Retainer Tape WHITE

Premier Sock Tape Shinguard Retainer Tape YELLOW

Premier Sock Tape Shinguard Retainer Tape

Premier Sock Tape Shinguard Retainer Tape

Style: SGR

Brand: premier sock tape

$8.99

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	LIGHT_BLUE	52294	[empty string]	[empty string]	N	LIGHT_BLUE	111	513764	[empty string]
2	BLACK	52295	[empty string]	[empty string]	N	BLACK	74	513765	[empty string]
3	BLUE	52296	[empty string]	[empty string]	N	BLUE	136	513766	[empty string]
4	GREEN	52297	[empty string]	[empty string]	N	GREEN	132	513767	[empty string]
5	MAROON	52298	[empty string]	[empty string]	N	MAROON	96	513768	[empty string]
6	NAVY	52299	[empty string]	[empty string]	N	NAVY	105	513769	[empty string]
7	ORANGE	52300	[empty string]	[empty string]	N	ORANGE	89	513770	[empty string]
8	RED	52301	[empty string]	[empty string]	N	RED	109	513771	[empty string]
9	ROYAL	52302	[empty string]	[empty string]	N	ROYAL	42	513772	[empty string]
10	WHITE	52303	[empty string]	[empty string]	N	WHITE	60	513773	[empty string]
11	YELLOW	52304	[empty string]	[empty string]	N	YELLOW	95	513774	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3,4) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	37592

Colors:

description
shipping & returns

38mm SGR Tape is for use round the bottom of the shin pads. Shin Guard Retainer Tape. Premier Sock Tape “Shin Guard Retainer Tape” has been developed over the past eight seasons as a replacement for the very restrictive zinc oxide tapes that have been used in the past to secure the socks below the shin pads. It has a 38mm width and easy tear construction for player convenience. The SGR tape is made from a special material that stretches when warm, this heat stretch property makes the SGR tape more comfortable to wear and more close fitting around the shin. Premier Sock Tape SGR Tape is now worn and trusted by many Premier League Teams and players alike all of which say they wouldn’t want to wear anything else!

All available shipping options

Return Policy