Pro Shin Guard Wrap

Pro Shin Guard Wrap

Style: PSGW

Brand: premier sock tape

$7.99

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	LIGHT_BLUE	52276	[empty string]	[empty string]	N	LIGHT_BLUE	0	513746	[empty string]
2	NEON_YELLOW	52277	[empty string]	[empty string]	N	NEON_YELLOW	1	513747	[empty string]
3	AMBER	52278	[empty string]	[empty string]	N	AMBER	4	513748	[empty string]
4	AQUA	52279	[empty string]	[empty string]	N	AQUA	177	513749	[empty string]
5	BLACK	52280	[empty string]	[empty string]	N	BLACK	56	513750	[empty string]
6	BLUE	52281	[empty string]	[empty string]	N	BLUE	17	513751	[empty string]
7	FOREST	52282	[empty string]	[empty string]	N	FOREST	1	513752	[empty string]
8	GREEN	52283	[empty string]	[empty string]	N	GREEN	98	513753	[empty string]
9	LIME	52284	[empty string]	[empty string]	N	LIME	29	513754	[empty string]
10	MAROON	52285	[empty string]	[empty string]	N	MAROON	0	513755	[empty string]
11	NAVY	52286	[empty string]	[empty string]	N	NAVY	26	513756	[empty string]
12	ORANGE	52287	[empty string]	[empty string]	N	ORANGE	91	513757	[empty string]
13	PURPLE	52288	[empty string]	[empty string]	N	PURPLE	16	513758	[empty string]
14	RED	52289	[empty string]	[empty string]	N	RED	123	513759	[empty string]
15	ROYAL	52290	[empty string]	[empty string]	N	ROYAL	209	513760	[empty string]
16	VIOLET	52291	[empty string]	[empty string]	N	VIOLET	156	513761	[empty string]
17	WHITE	52292	[empty string]	[empty string]	N	WHITE	0	513762	[empty string]
18	YELLOW	52293	[empty string]	[empty string]	N	YELLOW	92	513763	[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	37591

Colors:

description
shipping & returns

Premier Sock Tape 7.5cm Pro Wrap The PST 7.5cm Pro Wrap is the original and still the best. It has a unique construction which is soft to the touch but extremely supportive to play in. The basic features are as follows; Can be worn next to the skin – no adhesive. Light weight. 4.5m rolls. Multi use and re-usable. Porous and soft yet strong and water resistant. Gives a ‘confident’ feel with Shinguards securely held inplace. A great tape that can be worn every match to give great confidence. A must have for each and every player at all levels of the game ….. Don’t go into battle without it!

All available shipping options

Return Policy