5.11 Tactical Trainer 1.5" Belt Sandstone
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '59409-328 SM' AND (upper(f.web_text) = '5 11 TACTICAL SERIES' or upper(f.orig_text) = '5 11 TACTICAL SERIES' or upper(a.brand) = '5 11 TACTICAL SERIES') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
The consistent choice of law enforcement professionals, our 1.5” Trainer Belt is built from ultra-strong nylon mesh and features a solid stainless steel belt buckle with a 6,000 lb. rating. Ideal for both on duty and off duty wear, the Trainer Belt offers more than enough support and durability to carry your holster and accessories comfortably without sagging, twisting, or losing its shape. With heavy reinforced stitching, the 5.11 Tactical Trainer Belt can be quickly converted into a secure tie down, secondary carry strap, or emergency harness.
Durable and functional 1.5 inch tactical belt
Converts to a tie down, carry strap, or emergency harness
Stainless steel, 6,000 lb. buckle
Fade and rip resistant
Ultra-strong nylon mesh
Heavy stich reinforcements
Buckle is finished in matte stainless
Small - 28-30"
Medium - 32-34"
Large - 36-38"
Extra Large - 40-42"
XX Large - 44-46"
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$139.95 to $139.99