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(11)

3M(5)

KleenGuard(5)

Bausch & Lomb(3)

Honeywell Uvex(2)

Jackson Safety(1)

 
Color

Black Frame(1)

Smoke Lens(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(1)

 
Warranty

Manufacturer's lifetime frame warranty.(1)

 
Special Features

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

Anti-Scratch, Anti-Fog(1)

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

V30(1)

Clear Anti-Fog Lens(1)

Anti-Fog(1)

 
Manufacturer Part Number

25714(1)

28615(1)

25688(1)

25679(1)

25676(1)

114760000010(1)

118180000020(1)

S3200(1)

S3960C(1)

TGV0120(1)

GG501SGAF(1)

13407000005(1)

20539(1)

59991(1)

50003(1)

50030(1)

50000(1)

8576(1)

8574GM(1)

50033(1)

50103(1)

56033(1)

56080(1)

56000(1)

50133(1)

50130(1)

8565(1)

 
Country of Origin

TW(18)

US(5)

CN(3)

Taiwan(1)

 
Material

Polycarbonate Lens(1)

 
Width

8"(2)

6 1/2"(1)

 
Material(s)

Polycarbonate(1)

 
Frame Color

Black(13)

Clear(3)

Matte Gray(3)

Gray(1)

 
Length

5"(2)

4 3/4"(1)

 
Quantity

1 each(16)

20 per box(1)

20 per carton(1)

 
Frame Material

Nylon(10)

Polycarbonate(3)

Plastic(2)

Magnesium Alloy(1)

 
Packing Type

Box(1)

Packet(1)

Corrugated Container;Plastic Bottle(1)

 
Style

Wraparound(15)

Safety Goggles(2)

Frameless(2)

Half-frame(2)

Strap(1)

 
Capacity (Weight)

.7 oz(1)

16 oz(1)

 
Protection Type

Ultraviolet(1)

 
Size Group

One Size(15)

 
Lens Tint

Clear(14)

Smoke(5)

Photochromatic(1)

Indoor/Outdoor(1)

Smoke Mirror(1)

 
Lens Material

Polycarbonate(17)

Dual Polycarbonate(3)

 
Lens Coating/Filter

Anti-Fog(10)

99.9% UV Rays(2)

UV Filter(1)

Anti-Fog; Anti-Scratch(1)

3M Scotchgard Anti-Fog Technology(1)

Uncoated(1)

 
Wall-Mountable

Yes(2)

No(1)

 
Adjustability Features

Yes(1)

Strap(1)

 
Frame Finish

Gray(2)

 
Antifog

Yes(2)

 
Side Protection

Yes(1)

 
Coated Lenses

Yes(2)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved