NVR Kantech

Sort by:

Sorting

Best Selling

On Sale

CCTV

NVR (2)

Video Technology

IP (2)

HDD's Bays

2 (1)

4 (1)

Channels

64 (1)

75 (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 LEFT JOIN (SELECT products_id, MIN(sort_order) AS best_sort, 1 AS is_featured_match FROM featured WHERE status = 1 AND featured_group_id = 6 GROUP BY products_id) featbs ON featbs.products_id = p.products_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 = '6' or p2c.categories_id = '6') and m.manufacturers_id = '4976'

group by p.products_id order by MIN(CASE WHEN featbs.is_featured_match = 1 THEN 0 ELSE 1 END), MIN(CASE WHEN featbs.is_featured_match = 1 THEN IFNULL(featbs.best_sort, 0) ELSE 0 END), MAX(p.products_last_views) DESC, MIN(pd.products_name)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 AS p 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 AS p2pef ON p2pef.products_id = p.products_id LEFT JOIN products_extra_fields AS pef ON p2pef.products_extra_fields_id = pef.products_extra_fields_id AND pef.products_extra_fields_status = 1 AND pef.products_extra_fields_facet = 1 AND pef.languages_id IN (0, 1) INNER JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id AND pd.language_id = 1 left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on (s.products_id = p.products_id and s.status = 1) LEFT JOIN ( SELECT products_id, MIN(sort_order) AS best_sort, 1 AS is_featured_match FROM featured WHERE status = 1 AND featured_group_id = 6 GROUP BY products_id ) feat ON feat.products_id = p.products_id WHERE p.is_active = 1 AND ptc.categories_id = '6' AND p.manufacturers_id = '4976' group by p.products_id ORDER BY CASE WHEN feat.is_featured_match = 1 THEN 0 ELSE 1 END, p.products_sort_order, p.products_date_available DESC, p.products_last_views DESC, pd.products_name

2 items

Kantech ADVED00N0N5H VideoEdge Desktop NVR, 0 TB JBOD, (2) 2.5 GbE
# ADVED00N0N5H

Kantech

Kantech ADVER12N0N2J VideoEdge 2U NVR, 12 TB, JBOD, (2) 2.5 GbE, (2) 1GbE
# ADVER12N0N2J

Kantech

2 items

NVR Kantech

Sorting

Category

CCTV

Video Technology

HDD's Bays

Channels

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