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

Currently Filtered by


3M

Refine Search

  GO
 
Category Filter

Privacy Filters(66)

Eye Protection(13)

Hearing Protection(12)

Glare/Radiation Filters(12)

Safety Masks(8)

Mouse & Keyboard Wrist Rests(6)

Duster Refills(5)

Air Respirator Accessories(5)

Monitor Filters(5)

Multipurpose Cleaners(4)

Safety Tapes(4)

Monitor Arms(3)

Copyholders(3)

Safety Helmets(3)

Cork/Fabric Bulletin Boards(3)

Keyboard/Mouse Platforms & Trays(3)

Desktop Copyholders(3)

Respirators(3)

Dust Mop Frames(2)

Screens & Filters(2)

Monitor Stands/Risers(2)

Packing List/Invoice Enclosed Envelopes(2)

Duct Tapes(2)

Mounting Kits(1)

Laptop Stands & Pads(1)

Sponges & Scouring Pads(1)

Workstations/Computer Desks(1)

Photo Tape(1)

Janitorial Cloths & Wipes(1)

Mouse Pads(1)

Keyboard Drawers/Platforms(1)

Mice(1)

Laminating Supplies(1)

CPU Stands(1)

Computer Cloths/Wipes & Dusters(1)

Multimedia Headphones(1)

Safety/Caution Signs(1)

Safety Gear(1)

Adhesive Corner(1)

Adhesive Note Pads(1)

Mops & Mop Refills(1)

Board Erasers(1)

Easel Pads(1)

Tapes(1)

Towels & Wipes(1)

Laminating Machines(1)

 
Brand

3M(179)

E-A-R(5)

Peltor(4)

Tekk Protection(3)

Aearo(1)

Post-it®(1)

Scotch(1)

 
Color

Black(91)

Matte(41)

Glossy(37)

Clear(22)

White(18)

Yellow(13)

Gold(12)

Silver(10)

Clear Lens(7)

Gray(6)

Pink(4)

Orange(3)

Multicolor(2)

Aqua(2)

Blue(2)

Clear Temple(2)

Neon Yellow(1)

Black Frame(1)

Gray Frame(1)

Red(1)

Gray Lens(1)

Brown(1)

Green(1)

 
Recycled

No(77)

Yes(5)

 
Height

7.64"(7)

11.77"(5)

10.55"(5)

11.30"(5)

3.4"(4)

6.89"(4)

11.69"(4)

12.80"(3)

3"(3)

0.8"(3)

13.27"(3)

11.57"(3)

6.14"(3)

9.33"(2)

10.04"(2)

11.89"(2)

8.74"(2)

4"(2)

8"(2)

1"(2)

11.65"(2)

12.09"(1)

12.36"(1)

12.13"(1)

9.84"(1)

18.78"(1)

21.81"(1)

13.54"(1)

10.31"(1)

13.11"(1)

5.67"(1)

14.33"(1)

13.90"(1)

13.50"(1)

15.79"(1)

13.19"(1)

10.93"(1)

12.56"(1)

13.62"(1)

7.05"(1)

5.71"(1)

8.50"(1)

35.4"(1)

2"(1)

17"(1)

9.09"(1)

3.3"(1)

10.67"(1)

6.85"(1)

3.2"(1)

18"(1)

8.46"(1)

12.76"(1)

5.7"(1)

23"(1)

0.9"(1)

12.1"(1)

2.8"(1)

5.3"(1)

6.87"(1)

8.35"(1)

10.06"(1)

11.75"(1)

10.3"(1)

6"(1)

0.3"(1)

5.8"(1)

5.5"(1)

0.7"(1)

6.5"(1)

7.24"(1)

7.87"(1)

24"(1)

 
Color(s)

White(2)

 
Depth

14"(10)

0.13"(7)

12"(5)

10"(5)

0.19"(4)

21.75"(4)

21.70"(4)

0.25"(3)

13"(3)

1.10"(2)

9"(2)

4.6"(2)

20"(2)

0.02"(2)

10.6"(2)

2"(2)

18"(2)

15"(2)

16"(1)

1"(1)

6.2"(1)

13.20"(1)

0.80"(1)

6"(1)

2.5"(1)

25.56"(1)

21"(1)

11.80"(1)

11.50"(1)

19"(1)

1.3"(1)

17.20"(1)

0.10"(1)

25.38"(1)

1.38"(1)

15.60"(1)

8.5"(1)

0.20"(1)

0.17"(1)

5.5"(1)

3"(1)

10.5"(1)

26.80"(1)

2.75"(1)

5"(1)

 
Size

5" Width(3)

Standard(2)

1" x 36 yds(1)

8" Width(1)

One Size Fits All(1)

 
 
 

© 2020-2021 Crawford Office Supply, All Rights Reserved