Elk Products Detectors

Detectors

Accessories (30)

Bases (38)

CO (7)

Duct (15)

Fire Beam Detector (3)

Flame (1)

Flow (18)

Gas (4)

Heat (48)

Interfase Module (2)

Multicriteria (3)

Pressure (3)

Smoke (56)

Smoke & CO (11)

Smoke & Heat (20)

Sorting

Brand

Display All

Elk Products (1)

Diameter (In)

5.6 (1)

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price

from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_groups pg ON pg.products_id = p.products_id AND pg.group_code = 'G' left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = '1' JOIN products_to_categories p2c ON p2c.products_id = p.products_id JOIN categories c ON c.categories_id = p2c.categories_id

where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '96' or p2c.categories_id = '96' or p2c.categories_id = '97' or p2c.categories_id = '107' or p2c.categories_id = '117' or p2c.categories_id = '164' or p2c.categories_id = '169' or p2c.categories_id = '171' or p2c.categories_id = '172' or p2c.categories_id = '174' or p2c.categories_id = '183' or p2c.categories_id = '232' or p2c.categories_id = '278' or p2c.categories_id = '284' or p2c.categories_id = '355' or p2c.categories_id = '383' or p2c.categories_id = '384' or p2c.categories_id = '98' or p2c.categories_id = '112' or p2c.categories_id = '108' or p2c.categories_id = '176' or p2c.categories_id = '118' or p2c.categories_id = '168' or p2c.categories_id = '165' or p2c.categories_id = '333' or p2c.categories_id = '170' or p2c.categories_id = '334' or p2c.categories_id = '173' or p2c.categories_id = '335' or p2c.categories_id = '175' or p2c.categories_id = '184' or p2c.categories_id = '233' or p2c.categories_id = '279' or p2c.categories_id = '285' or p2c.categories_id = '386') and m.manufacturers_id = '11'

group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name

1 items

Sound All™ Two-way Wireless Heat Detector
# ELK-6053

Elk Products

1 items

Elk Products Detectors

Sorting

Brand

Diameter (In)

About Us

Customer Care

Our Policies

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again