f Security | Safety Security
 
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_name` IN ('Alert Chimes','Crowd Control Stanchions/Ropes','Locks','Security Mirrors','Lockout Kit','Safety Horn','Safety Horn Refills')) 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 '%Security' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Security' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Security' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Security"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Security"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Security"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Security"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Security' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Security',`category_4` ='Security') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Security,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Security', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Security

Refine Search

  GO
 
Brand

Master Lock(22)

Tatco(11)

See All(10)

 
Color

Red(7)

Black(6)

Silver(4)

Chrome(4)

White(3)

Brass(2)

Assorted(2)

Blue(1)

Cover(1)

Yellow Frame(1)

Gray(1)

Silver Dial(1)

Steel Gray(1)

Purple Dial(1)

Red Dial(1)

Black Dial(1)

Blue Dial(1)

 
Size

26" Diameter(2)

18" Diameter(2)

18" Width x 12" Length(1)

15" Width x 24" Length(1)

36" Diameter(1)

7" Diameter(1)

18" Width x 24" Length(1)

12" Diameter(1)

 
Recycled

No(39)

 
Packaged Quantity

1 Each(25)

1(8)

2 / Box(6)

1 / Each(2)

6 / Box(1)

2 / Pack(1)

 
Assembly Required

No(28)

Yes(1)

 
Weight (Approximate)

13.60 oz(1)

1.20 lb(1)

7.20 oz(1)

5.70 lb(1)

2.70 lb(1)

3.30 lb(1)

6.30 lb(1)

12.80 oz(1)

 
Recycled Content

0%(38)

 
Durability

Cut Resistant(9)

Rust Resistant(5)

Pick Proof(2)

Dirt Resistant(1)

 
Package Type

Retail(2)

 
Item Capacity

4 x Padlock(1)

 
Viewing Angle

160°(6)

180°(1)

 
Lock Configuration Type

Combination Lock(1)

 
Locking Combination

3-digit(1)

 
Manufacturer Part Number

PV18180(1)

PV26180(1)

RR1218(1)

RR1524(1)

N36(1)

N26(1)

ICU7(1)

N12(1)

N18(1)

11000(1)

11001(1)

11815(1)

12000(1)

12400(1)

15300(1)

11711(1)

11611(1)

11116(1)

11500(1)

11501(1)

FR1824(1)

S806(1)

1534D(1)

175D(1)

22D(1)

265DCCSEN(1)

1530DCM(1)

1505D(1)

1457E410KA(1)

1482B(1)

1500D(1)

3D(1)

3DLF(1)

496B(1)

506(1)

5400 D(1)

S2005(1)

487(1)

4688DBLU(1)

3T(1)

410RED(1)

420(1)

140D(1)

 
Country of Origin

China(25)

United States(18)

 
Material

Steel Shackle(11)

Steel Body(3)

Metal(2)

Stainless Steel Body(2)

Plastic(2)

Steel - Shackle(1)

Xenoy Thermoplastic - Body(1)

Metal Body(1)

Body(1)

Brass(1)

Brass Body(1)

Laminated Steel(1)

Steel(1)

 
Height

4"(1)

12.3"(1)

 
Width

1.6"(4)

1.9"(3)

3.6"(1)

1.5"(1)

2.5"(1)

16"(1)

2"(1)

 
Depth

1.6"(1)

1.8"(1)

 
Shape

Round(5)

Rounded Rectangular(2)

Half-dome(2)

Rectangle(1)

Rectangular(1)

 
Frame Material

Glass(1)

Stainless Steel(1)

 
Placement

Wall Mountable(7)

 
Base Color

White(1)

Black(1)

 
Cable Length

6 ft(1)

 
Key Type

Keyed Different(4)

Master Keyed(2)

Keyed Alike(1)

 
Shackle Size

1" Vertical Clearance - 1" Horizontal Clearance(1)

 
Alarm Type

Security Alarm(1)

 
 
 

© 2019-2020 Edwards Office System, All Rights Reserved