ABUS Padlock 64TI/40 - 3 Pack
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '65941' AND (upper(f.web_text) = 'ABUS' or upper(f.orig_text) = 'ABUS' or upper(a.brand) = 'ABUS') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
As with all Titalium padlocks, the lock body of the 64TI is made from special aluminium.
This makes the padlock extremely light. The hardened steel shackle with NanoProtect™coating can be removed and its length adjusted to the individual conditions. The 5-pin cylinder with paracentric key profile makes unauthorised opening of the lock using picking tools difficult. This padlock is therefore particularly suitable for protecting cupboards, storage rooms, boxes, crates. gates and other items of medium to high value in homes, gardens and industrial buildings against unauthorised access.
- Solid lock body made from TITALIUM™ special aluminium
- Hardened steel shackle with NANO PROTECT™ coating for extreme corrosion resistance
- Paracentric key profile for increased protection against manipulation
- Double bolted shackle
- Chrome-plated cylinder plug for additional corrosion protection
- Tulip-shaped key head
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$16.99 to $19.99