SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('40171')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%WorkGloves' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('WorkGloves' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+WorkGloves' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"WorkGloves"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"WorkGloves"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"WorkGloves"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"WorkGloves"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+WorkGloves' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='WorkGloves',`category_4` ='WorkGloves') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'WorkGloves,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('WorkGloves', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Work Gloves

Refine Search

  GO
 
Brand

Memphis(12)

Anchor Brand(6)

AnsellPro(3)

Mechanix Wear(2)

Honeywell(1)

MCR Safety(1)

MAPA(1)

 
Color(s)

Blue(4)

Black(3)

White/Gray(3)

Blue Striped/White(3)

Pearl Gray; Striped Back(2)

Gray(1)

Gold/Green Stripe(1)

Green(1)

Yellow/Gray(1)

Red(1)

White/Red(1)

Red/Blue Striped/Tan(1)

Beige/White(1)

Brown(1)

Blue/White(1)

Black/Blue(1)

 
Manufacturer Part Number

2010(1)

1935M(1)

9780L(1)

9683M(1)

7800(1)

6820(1)

6218(1)

5310(1)

4600(1)

1950L(1)

1936M(1)

1936L(1)

1700L(1)

2150(1)

1200XL(1)

MG03009(1)

MG02011(1)

KV18A10050(1)

3715510CT(1)

321058(1)

1180011(1)

CW777(1)

7400(1)

7005(1)

3000(1)

334949(1)

 
Country of Origin

CN(16)

MY(3)

MX(2)

VN(2)

PK(2)

LK(1)

 
Material(s)

Cowhide; Cotton(3)

Leather; Canvas(2)

Pigskin(2)

Nitrile(2)

Spandex; Rubber(2)

Nitrile; Cotton(1)

Nitrile; Nylon(1)

Cotton Jersey(1)

Cotton Canvas; Latex(1)

PVC(1)

Leather; Cotton; Kevlar(1)

Cotton; Leather(1)

Leather; Jersey Cotton(1)

Leather(1)

Kevlar; Leather(1)

Nitrile; Fabric(1)

Foam Nitrile; Fabric(1)

PVC; Jersey Cotton(1)

PVC; Fabric(1)

Neoprene; Fabric(1)

 
Length

13"(1)

18"(1)

 
Style

Work(23)

Welding(2)

Cut-Resistant(1)

 
Thickness

15 mil(1)

11 mil(1)

 
Size Group

Large(11)

Men's(4)

Medium(4)

X-Large(3)

Size 10(2)

Size 11(1)

Size 8(1)

 
Wrist Style

Gauntlet(10)

Knit(8)

Safety(5)

Shirred(2)

Straight(1)

 
Thumb Style

Wing(4)

Straight(4)

 
Hand Specific

Pair(26)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved