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 ('30830')) AND `pinfo`.`status` IN ('active','discontinued') 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 '%EyeProtection' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('EyeProtection' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+EyeProtection' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"EyeProtection"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"EyeProtection"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"EyeProtection"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"EyeProtection"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+EyeProtection' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='EyeProtection',`category_4` ='EyeProtection') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'EyeProtection,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('EyeProtection', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Eye Protection

Refine Search

  GO
 
Brand

ergodyne(10)

KleenGuard(7)

3M(5)

Bausch & Lomb(3)

Honeywell Uvex(2)

Ergodyne(1)

Jackson Safety(1)

Honeywell(1)

 
Color

Black(1)

Smoke Lens(1)

Black Frame(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(2)

 
Warranty

Manufacturer's limited one-year warranty.(1)

Manufacturer's lifetime frame warranty.(1)

 
Compatibility

Safety Glasses:

  • Ergodyne Odin
  • Dagr
  • Kvasir
  • Valkyrie
(1)

 
Special Features

Fog-OffT Technology-Fog-OffT Technology anti-fog coating won't wash off or wear off.(5)

Clear Anti-Fog Lens(1)

Indoor/Outdoor Lens(1)

V30(1)

Anti-Fog(1)

Wraparound design; Wall-mountable dispenser box for easy access(1)

Anti-Scratch, Anti-Fog(1)

 
Fits

Over Glasses(1)

 
Manufacturer Part Number

8565(1)

25676(1)

S3200(1)

A610S(1)

TGV0120(1)

GG501SGAF(1)

13407000005(1)

118180000020(1)

114760000010(1)

28615(1)

25714(1)

25688(1)

25685(1)

25679(1)

22609(1)

8574GM(1)

20539(1)

59991(1)

56080(1)

56033(1)

56000(1)

50133(1)

50130(1)

50103(1)

50033(1)

50030(1)

50003(1)

50000(1)

8576(1)

S3960C(1)

 
Country of Origin

TW(18)

US(5)

CN(5)

Taiwan(2)

 
Material

Elastic(1)

Polycarbonate Lens(1)

 
Width

8"(2)

6 1/2"(1)

 
Material(s)

Polycarbonate(1)

Polycarbonate/PVC/Elastic(1)

 
Frame Color

Black(14)

Matte Gray(3)

Clear(3)

Camo(1)

Gray(1)

 
Length

5"(2)

4 3/4"(1)

 
Quantity

1 each(15)

1 pair(1)

20 per carton(1)

20 per box(1)

 
Frame Material

Nylon(10)

Polycarbonate(4)

Plastic(2)

Magnesium Alloy(1)

 
Packing Type

Corrugated Container;Plastic Bottle(1)

Packet(1)

Box(1)

 
Style

Wraparound(17)

Half-frame(2)

Frameless(2)

Safety Goggles(2)

Indirect Vented(1)

 
Capacity (Weight)

16 oz(1)

.7 oz(1)

 
Protection Type

Ultraviolet(1)

 
Size Group

One Size(15)

 
Lens Tint

Clear(15)

Smoke(6)

Indoor/Outdoor(2)

Smoke Mirror(1)

Photochromatic(1)

 
Lens Material

Polycarbonate(17)

Dual Polycarbonate(5)

 
Lens Coating/Filter

Anti-Fog(11)

99.9% UV Rays(2)

UV-Protection(1)

3M Scotchgard Anti-Fog Technology(1)

Uncoated(1)

Fog-Ban Anti-Fog(1)

Anti-Fog; Anti-Scratch(1)

UV Filter(1)

 
Wall-Mountable

Yes(2)

No(1)

 
Adjustability Features

Strap(2)

Yes(1)

 
Frame Finish

Gray(2)

Transparent Green Body(1)

 
Antifog

Yes(3)

 
Side Protection

Yes(1)

Y(1)

 
Coated Lenses

Yes(3)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved